Senior BI Engineer, Platform, Databricks

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Create and uphold reporting-ready dimensional models, views, and metric definitions within Databricks.

• Develop and sustain dashboards that monitor data quality, delivery timelines, SLA compliance, payer scorecards, and platform expenses.

• Release certified and documented datasets for domain teams and analysts.

• Oversee the data dictionary and provide training and guidance to users on proper data utilization.

• Establish data exposure standards for BI tools, covering access controls, PHI/PII protection, certified versus exploratory content, and naming conventions.

• Assess BI and visualization tools including Tableau, Power BI, and Databricks AI/BI.

• Retain business logic within the data layer and lead migrations as necessary.

• Optimize queries, warehouse utilization, and refresh schedules.

• Diagnose connectivity and performance challenges.

• Manage BI assets in version control across various environments.

• Collect requirements from domain teams and leadership.

• Transform stakeholder feedback into enhancements and monitor adoption and usage.

⛳️ Requirements

• Over 3 years of experience in business intelligence, analytics engineering, or data engineering, with a focus on enterprise dashboards and reporting data models.

• More than 3 years of coding experience in SQL and data modeling, including window functions, CTEs, and performance optimization.

• Strong expertise in dimensional modeling, including star schemas, fact grain, and slowly changing dimensions.

• A minimum of 3 years working with an enterprise BI platform such as Tableau or Power BI, focusing on publishing, permissions, and performance optimization.

• Familiarity with additional BI platforms.

• At least 3 years of experience creating semantic layers, governed reusable data sources, or metric layers.

• Over 3 years of hands-on experience with Databricks or a comparable cloud data warehouse like Snowflake, Synapse, or BigQuery.

• More than 3 years of data governance experience, including role-based access, row- and column-level security, and managing sensitive reporting data.

• Bachelor's degree or equivalent practical experience.

• Preferred: 6+ years in business intelligence, analytics engineering, or data engineering, with at least 4 years focused on building enterprise dashboards and reporting data models.

• Capability to mentor users, produce clear documentation, and convey data concepts to both technical and business audiences.

• Experience with Git, code reviews, CI/CD for BI assets, and dbt or similar frameworks.

• Proficiency in Python for data preparation, automation, or analysis.

• Familiarity with natural-language analytics tools, such as Databricks Genie or Power BI Copilot.

• Certifications in Tableau, Power BI, or Databricks are preferred.

🏝️ Benefits

• CVS Health bonus, commission, or short-term incentive program in addition to base salary.

• Medical insurance coverage.

• Dental insurance coverage.

• Vision insurance coverage.

• Paid time off.

• Retirement savings options.

• Wellness programs.

• Additional resources to support physical, emotional, and financial well-being.