BI Architect II

Posted Feb 7

Founded in 1985, SelectQuote provides solutions that help consumers protect their most valuable assets: their families, health and property. The company pioneered the model of providing unbiased comparisons from multiple, highly rated insurance companies allowing consumers to choose the policy and terms that best meet their unique needs. Two foundational pillars underpin SelectQuote's success: a strong force of highly trained and skilled agents, who provide consultative needs analysis for every consumer, and proprietary technology that sources and routes high-quality leads. The company has three core business lines: SelectQuote Senior, SelectQuote Life and SelectQuote Auto and Home. SelectQuote Senior, the largest and fastest-growing business, serves the needs of a demographic that sees 10,000 people turn 65 each day with a range of Medicare Advantage and Medicare Supplement plans.

Job Summary:

BI Architect is responsible for architecture, development, and some ETL processes for SelectQuote's data warehousing solutions. The job candidate will have a strong understanding in data warehousing methodologies and dimensional modeling, Microsoft SQL Server, and AWS Redshift.

Essential Functions:

  • Architect new and existing data warehouse solutions.
  • Work on projects and tasks assigned by a project manager.
  • Participate in a multiyear project migrating warehouse objects and data from SQL Server to AWS Redshift.
  • Look for warehouse improvement opportunities.
  • Conduct code reviews before code is deployed to production.

Knowledge, Skills and Abilities:

  • Troubleshoot stored procedures and other TSQL code.
  • Adequate performing query tuning techniques by leveraging execution plans and understands how to work with indexes.
  • Strong technical aptitude and enjoys working with data.
  • Provides and welcomes feedback in a team environment.
  • Must be able to adjust when there is a shift in priorities.
  • Excellent communicator with individuals and groups at all levels.
  • Detail oriented, organized, and able to manage expectations.
  • Proficient in time management and able to stay on task.
  • Strong analytical and critical thinking skills with a desire to learn.

Training & Experience:

  • Experience developing in Microsoft SQL Server and AWS Redshift.
  • Strong understanding in data warehousing methodologies and dimensional modeling.
  • Proficient with SQL, indexes, refactoring, and tuning.
  • Python desirable but not required.
  • Bachelor's Degree in IT and/or 2+ years BI experience

Benefits:

It's an exciting time to join SelectQuote. We became a publicly traded company in 2020 with the first 100% virtual IPO (non-biotech) in American history. We have also been recognized nationally on the 2021 Top Workplaces USA list and by the Kansas City Business Journal as a 2020 Best Places to Work honoree.

Full-time employees are eligible for medical, dental, vision, voluntary short-term disability, company-paid long term disability, company-paid life insurance and accidental death & dismemberment (AD&D), 401(k) + company match and 100% vesting after 4 years, discretionary profit sharing, employee stock purchase program (espp), paid time off, floating holidays, paid maternity leave, paid parental bonding leave, tuition reimbursement, jury duty pay, and other paid leaves vary based on work location.