Senior BI Engineer (Platform, Databricks)

8350 Oak Street Health MSO LLC; Illinois; Hybrid; USD 83,000 - 204,000; Full time

Job summary

CVS Health is seeking a Senior Business Intelligence Engineer to shape how data from our Databricks platform is modeled, governed, and delivered for impactful analysis. You will own data quality, timeliness, and cost, building trusted data products for self-service analytics across tools like Power BI and Tableau.

We welcome remote work in the US. The role requires 3+ years in BI/data engineering, strong SQL, data modeling, and proficiency with Tableau/Power BI and Databricks.

Qualifications

• 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.

Responsibilities

• Design and maintain reporting-ready dimensional models and metric definitions in Databricks.
• Build dashboards for data quality, delivery timeliness, SLA attainment, payer scorecards, and platform cost.
• Publish certified datasets and maintain the data dictionary; train users.
• Define data exposure controls and naming standards for BI tools.
• Evaluate BI tools and lead migrations when needed.
• Tune queries and manage BI assets across environments.
• Gather requirements from domain teams and leadership; track adoption.

Skills

SQL

Data Modeling

Tableau

Power BI

Databricks

Python

Git

CI/CD

Education

Bachelor's degree or equivalent

Tools

Tableau

Power BI

Databricks

dbt

Job description

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

40

Time Type

Full time

Pay Range

The typical pay range for this role is: $83,430.00 - $203,940.00 This 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.

Our Work Experience

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. This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility. Additional details about available benefits are provided during the application process and on Benefits Moments.

We anticipate the application window for this opening will close on: 11/28/2026

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.

Our Work Experience is the combination of everything that's unique about us: our culture, our core values, our company meetings, our commitment to sustainability, our recognition programs, but most importantly, it's our people. Our employees are self-disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.