Business Intelligence Architect II
About Us
More than 35 years ago, SelectQuote was founded on one core promise: to help our customers protect the people they value most. We pioneered the way consumers shopped for term life insurance, and now, we also help people find home insurance, auto insurance, senior health insurance and more. Our quick and easy process saves consumers both time and money, and today, more than 2 million families trust us to help them with their insurance needs.
But what truly sets us apart is our people, and the opportunities to grow your career with SelectQuote are unmatched.
About the Role
BI Architect II 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.
Supervisory Responsibilities:
- This position has no direct supervisory responsibilities.
Essential Duties and Responsibilities:
- 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
Skills/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
Education and 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 and/or Data Warehouse experience
Physical Requirements:
- Work is performed indoors with potential for exposure to safety and health hazards related to office work. Could periodically travel to other office and operational sites. The noise level in the work environment is usually moderate.
- Prolonged periods of sitting at a desk and working on a computer.
SelectQuote Core Values:
Service: We create positive customer experiences.
Entrepreneurship: We create innovate & take risks.
Leadership: We build & invest in high-performing teams.
Empowerment: We embrace a changing environment.
Courage: We challenge the status quo & drive continuous improvement.
Teamwork: We help support & celebrate each other.
Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required.
Our Benefits
The Compensation for this position is listed below. Local minimum wage laws apply. This information is posted pursuant to local requirements to provide applicants with information about what they might be eligible to receive. Individual pay decisions will depend on job-related factors such as experience, education, skill, performance, and geographic location where work will be performed.
Successful candidates may be able to participate in one or more incentive compensation or short-term incentive plans, which could generate additional earnings in accordance with the terms of each plan.
We are proud to offer the following benefits:
- Competitive Medical, Dental, and Vision insurance
- HSA/FSA
- Voluntary Hospital Indemnity, Critical Illness, accident insurance, and short term disability
- Voluntary Life Insurance for self, spouse and dependent
- Company-paid Basic Life Insurance and Long Term Disability
- Retirement plan and employer match contribution with Profit Share
- Tuition Reimbursement program
- Company perks and discount program
- Engaging Wellness and financial education resources
- Employee Assistance Program
- Incentive Plans
Base Salary Minimum
$100,000
Base Salary Maximum
$115,000
Average salary estimate
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
At SelectQuote, we’re passionate about helping our customers protect what matters most to them, and we’re on the lookout for a Business Intelligence Architect II to join our driven team. This remote role is perfect for someone who loves diving deep into data and finding innovative architectural solutions. As a vital part of our data warehousing initiatives, you will harness your expertise in SQL Server and AWS Redshift to architect new solutions and improve existing ones. You will work on a multiyear project focused on migrating our data warehouse objects, and your ability to conduct code reviews will ensure that our production remains top-notch. We value individuals who are proactive, who thrive in collaborative environments, and who have a hunger for knowledge. Your skills in troubleshooting stored procedures and performing query tuning will be crucial in this role. With a keen analytical mindset and a zest for continuous learning, this role will not only challenge you but also provide ample opportunities to grow. Join us at SelectQuote and be part of a culture that values service, entrepreneurship, and teamwork – all while working from the comfort of your own home!
Embark on a career with Liberty Mutual as a Technical Consultant, where you'll engage deeply with a leading logistics firm to enhance their risk management strategies.
Become a vital part of Tradesmen International as a Strategic Account Executive, where your sales expertise will foster relationships with key institutional clients.
Blend360, a leader in data intelligence solutions, is looking for a Business Intelligence Manager to guide BI teams and deliver impactful analytics for Fortune 500 clients.
Join Guidehouse as a PFS Clinical Trials Coder/Biller where you will play a vital role in coding medical documents for clinical trials.
Join Veracyte's pioneering team as a Histology Associate II, where your expertise will directly impact cancer diagnostics.
Become a vital part of Blue Cross NC as a Data & Analytics Governance Associate, driving AI governance and compliance initiatives remotely.
Guidehouse is looking for a certified Oncology Data Specialist to manage cancer registry data while ensuring compliance and quality improvement.
Join Deloitte as a Data Governance BCBS 239/RDARR Manager to transform financial risk management practices in a hybrid role.
Subscribe to Rise newsletter
🔮
Hi, I'm Risa! Your AI Career Copilot
you, just ask me below!
Sign up for our weekly
newsletter of fresh jobs
