CVS Health logo

Senior BI Engineer (Platform, Databricks)

CVS Health
  • Illinois
    4 days ago

    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.

    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.

    Numbers & Facts

    LocationIllinois
    IndustryBiotechnology/Pharmaceuticals
    Company Size10,000 employees or more
    Websitehttps://cvshealth.com/

    About Company

    CVS Health offers a world of promising job opportunities across a diverse range of careers in everything from corporate and pharmacy roles to retails positions. No matter where you work at CVS Health, your unique skills, talents and abilities are welcome and valued. We recognize and reward greatness and want our employees to know their work is making a difference in the lives of millions. Join us today. Together we can continue making innovative, high-quality health and pharmacy services safe, affordable and accessible – for all.

    Skills

    • Access Controlunmatched
    • Analysis Skillsunmatched
    • Artificial Intelligence (AI)unmatched
    • Asset Managementunmatched
    • Automationunmatched
    • Business Intelligenceunmatched
    • Business Intelligence Softwareunmatched
    • Cloud Computingunmatched
    • Coachingunmatched
    • Code Reviewsunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Cross-Functionalunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Setsunmatched
    • Data Warehousingunmatched
    • Dimensional Modelingunmatched
    • Establish Prioritiesunmatched
    • Geographyunmatched
    • Gitunmatched
    • Healthcareunmatched
    • Incentive Programsunmatched
    • Leadershipunmatched
    • Metricsunmatched
    • Network Supportunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Product Documentationunmatched
    • Python Programming/Scripting Languageunmatched
    • Reporting Dashboardsunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Safety/Work Safetyunmatched
    • Scorecardingunmatched
    • Service Level Agreement (SLA)unmatched
    • Snowflake Schemaunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Star Schemaunmatched
    • Strategic Analysisunmatched
    • Tableauunmatched
    • Team Playerunmatched
    • User Documentationunmatched
    • Warehousingunmatched

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Resume Builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Resume Builder