Senior BI Engineer (Platform, Databricks)

CVS Health

Springfield (IL)

Remote

USD 83,000 - 204,000

Full time

5 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical

Dental

Vision coverage

Paid time off

Retirement savings options

Wellness programs

Other resources

Job summary

CVS Health seeks a Senior Business Intelligence Engineer to model and govern data from our Databricks platform, delivering trusted data products for self‑service analytics. You will own data quality, delivery timeliness, costs, and operational reporting across multiple domains, with dashboards and direct data tool connections in Tableau and Power BI.

You will design dimensional models, publish certified datasets, define guardrails, and partner with domain teams and leadership.

Qualifications

3+ years in business intelligence, analytics engineering, or data engineering, including building enterprise dashboards and reporting data models.
3+ years experience coding in SQL & Data Modeling: window functions, CTEs, performance tuning; strong dimensional modeling.
3+ years experience with at least one enterprise BI platform (Tableau or Power BI) including publishing, permissions, and performance tuning.
3+ years experience building Semantic Layers: governance of data sources or metric layers (Power BI semantic models, Tableau published data sources, dbt, Databricks metric views).
3+ years experience on Cloud Data Platforms: Databricks or similar (Snowflake, Synapse, BigQuery).
3+ years experience with Data Governance: RBAC, row/column security, handling sensitive data.

Responsibilities

Design and maintain reporting-ready dimensional models, views, and metric definitions in Databricks for consistent metrics across tools.
Build and maintain dashboards for data quality, delivery timeliness, SLA attainment, payer scorecards, and platform cost.
Publish certified, documented datasets; maintain data dictionary; train users to work with data correctly.
Define governance and guardrails: access controls, PHI/PII protection, and content certification standards.
Evaluate BI tools (Tableau, Power BI, Databricks AI/BI) and keep business logic in the data layer; lead migrations when needed.
Tune queries, optimize warehouse usage, refresh schedules; troubleshoot performance; manage BI assets in version control.
Gather requirements from domains and leadership; translate feedback into improvements; track adoption.

Skills

SQL

Data Modeling

Tableau

Power BI

Databricks

Python

Git/CI-CD for BI assets

Data Governance

Self-Service BI

Analytics Engineering

Education

Bachelor's degree

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

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.

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.