We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.
Position Summary
We are looking for a curious and motivated Senior Business Intelligence Engineer to help us shape how data from our Databricks platform is modeled, governed, and delivered for impactful analysis. The platform ingests and validates external healthcare data from 25+ payers across 10+ data domains. This role owns the data quality, delivery timeliness, cost, and operational reporting that domain teams and leadership rely on.
This is more than a dashboard role. Our visualization tools may change, and more users will connect to curated data directly from tools like Power BI and Tableau. We want an engineer who builds trusted, well-documented data products that work in any tool, and who sets the standards, guardrails, and coaching that keep self-service analytics accurate, secure, and consistent. The right candidate will have a flexible mindset and a passion to learn new tools and technologies.
**We can consider remote in US for this role.
Responsibilities
- Reporting Data Models & Metrics: Design and maintain reporting-ready dimensional models, views, and metric definitions in Databricks, so that key metrics are defined once and used consistently across tools.
- Dashboards & Visualization: Build and maintain dashboards for data quality, delivery timeliness, SLA attainment, payer scorecards, and platform cost, from executive summaries to operational detail, applying sound design and accessibility practices.
- Self-Service Enablement: Publish certified, documented datasets that domain teams and analysts can use in their own tools. Maintain the data dictionary, and train and coach users to work with the data correctly.
- Governance & Guardrails: Define how data is exposed to BI tools, including access controls, PHI/PII protection, certified versus exploratory content, and design and naming standards.
- Tool Strategy: Evaluate BI and visualization tools (e.g., Tableau, Power BI, Databricks AI/BI) and keep business logic in the data layer so tools can change without rework. Lead migrations when needed.
- Performance & Reliability: Tune queries, warehouse usage, and refresh schedules, troubleshoot connectivity and performance issues, and manage BI assets in version control across environments.
- Stakeholder Partnership: Gather requirements from domain teams and leadership, turn feedback into improvements, and track adoption and usage.
Required Experience
- 3+ years in business intelligence, analytics engineering, or data engineering, including building enterprise dashboards and reporting data models while working with cross functional teams to drive progress.
- 3+ years experience coding in SQL & Data Modeling: (window functions, CTEs, performance tuning) and strong dimensional modeling skills (star schemas, fact grain, slowly changing dimensions).
- 3+ years experience working with at least one enterprise BI platform (Tableau or Power BI), including publishing, permissions, and performance tuning, and working knowledge of others.
- 3+ years experience building Semantic Layers: Experience building governed, reusable data sources or metric layers (e.g., Power BI semantic models, Tableau published data sources, dbt, Databricks metric views).
- 3+ years experience on Cloud Data Platforms: Hands-on experience with Databricks or a similar cloud data warehouse (e.g., Snowflake, Synapse, BigQuery).
- 3+ years experience with Data Governance: Experience with role-based access, row- and column-level security, and handling sensitive data in reporting.
Preferred Qualifications
- 6+ years experience in business intelligence, analytics engineering, or data engineering, including 4+ years building enterprise dashboards and reporting data models.
- Enablement & Communication: Proven ability to coach users, write clear documentation, and explain data to technical and business audiences.
- Analytics engineering practices, such as Git, code review, CI/CD for BI assets, and dbt or similar frameworks
- Python for data preparation, automation, or analysis
- Thoughtful use of AI tools to accelerate development and analysis, with the same ownership of AI-assisted work as any other work shipped; familiarity with natural-language analytics (e.g., Databricks Genie, Power BI Copilot)
- Tableau, Power BI, or Databricks certifications
Education
● Bachelor's degree or equivalent practical experience.
Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:
$83,430.00 - $203,940.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.
Great benefits for great people
We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.
Additional details about available benefits are provided during the application process and on Benefits Moments.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.
Skills Required
- 3+ years in business intelligence, analytics engineering, or data engineering, including enterprise dashboards and reporting data models
- 3+ years coding in SQL and data modeling, including window functions, CTEs, performance tuning, and dimensional modeling
- 3+ years with an enterprise BI platform such as Tableau or Power BI, including publishing, permissions, and performance tuning
- 3+ years building semantic layers or governed reusable data sources and metric layers
- 3+ years with Databricks or a similar cloud data warehouse such as Snowflake, Synapse, or BigQuery
- 3+ years of data governance experience, including role-based access, row- and column-level security, and sensitive data handling
- Bachelor's degree or equivalent practical experience
- 6+ years in business intelligence, analytics engineering, or data engineering, including 4+ years building enterprise dashboards and reporting data models
- Ability to coach users, write documentation, and explain data to technical and business audiences
- Experience with Git, code review, CI/CD for BI assets, and dbt or similar frameworks
- Python experience for data preparation, automation, or analysis
- Familiarity with AI-assisted analytics tools such as Databricks Genie or Power BI Copilot
- Tableau, Power BI, or Databricks certification
CVS Health Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CVS Health and has not been reviewed or approved by CVS Health.
-
Healthcare Strength — Health coverage includes medical, dental, and vision with HSA-eligible options, free preventive care, virtual care, and access to MinuteClinic services. Mental-health resources such as counseling support are emphasized, and coverage is often considered solid for full-time colleagues.
-
Retirement Support — A dollar-for-dollar 401(k) match up to 5% after one year and an Employee Stock Purchase Plan are consistently highlighted in Total Rewards materials. Feedback suggests retirement programs are a meaningful strength within the overall package.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings include up to 20 no-cost counseling sessions per issue, backup care, tuition assistance, and substantial in-store discounts, alongside broader wellness tools. These everyday perks expand value beyond base pay and can be especially meaningful for full-time schedules.
CVS Health Insights
What We Do
CVS Health is the leading health solutions company that delivers care in ways no one else can. We reach people in more ways and improve the health of communities across America through our local presence, digital channels and our nearly 300,000 dedicated colleagues – including more than 40,000 physicians, pharmacists, nurses and nurse practitioners. Wherever and whenever people need us, we help them with their health – whether that’s managing chronic diseases, staying compliant with their medications, or accessing affordable health and wellness services in the most convenient ways. We help people navigate the health care system – and their personal health care – by improving access, lowering costs and being a trusted partner for every meaningful moment of health. And we do it all with heart, each and every day.
