CVS Health Logo

CVS Health

Senior Business Intelligence (BI) Engineer

Posted 10 Days Ago
In-Office
Northbrook, IL, USA
102K-204K Annually
Senior level
In-Office
Northbrook, IL, USA
102K-204K Annually
Senior level
Senior BI Engineer supporting Pharmacy Services Finance Intelligence by analyzing financial data, identifying trends and risks, and delivering decision-ready insights to CFO stakeholders. The role develops semantic-layer data sources, integrates disparate datasets, partners on analytics product delivery, improves solution quality and automation, explores AI-enabled analytics, and mentors junior analysts. Advanced SQL, analytics programming, visualization, statistical modeling, data engineering, communication, and large-scale analytics leadership are central to the position.
The summary above was generated by AI

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:

As a Sr BI Engineer within the Pharmacy Services Finance Intelligence organization, you will operate as a trusted analytical advisor to the CFO organization — proactively surfacing what matters most in the business’s financial data and translating it into insight, recommendations, and a clear call to action, delivered through the medium that best drives the decision. You’ll dive deep into CVS Health’s data, applying sound research, statistical reasoning, and business judgment to influence tactical and strategic decisions across the enterprise. You’ll distill complex, cross-functional analytics into curated, decision-ready insight, communicating it in the language and format each audience needs, across all levels of the organization. And you’ll help shape how the team works alongside AI-enabled conversational and agentic analytics tools, evolving how insight gets discovered, validated, and delivered.

Job Responsibilities:

  • Proactively identify trends, risks, and opportunities in the data, distilling them into curated, decision-ready insight and advocating for the recommended action — tailoring the narrative to audiences across all levels of the organization

  • Explore and adopt AI-enabled conversational and agentic analytics capabilities, helping evolve how the team surfaces and delivers insight beyond traditional dashboarding

  • Partner with Finance stakeholders to anticipate analytical needs before they’re formally requested, shaping priorities around where insight can have the greatest business impact

  • Partner with Analytics Engineering colleagues, providing subject matter expertise across the project lifecycle — scope, architecture, deliverables, acceptance, and deployment — to develop analytics products effectively and efficiently

  • Blend and integrate massive amounts of data from disparate sources to design and engineer holistic semantic layer data sources that can be used across multiple solutions

  • Ensure developed solutions are of sound quality, consistently available, and performing to expectations, driving continuous improvement by automating and streamlining technical processes

  • Provide technical guidance and mentorship to junior analysts, driving design and code quality through Peer Design and Code Reviews

Required Qualifications:

  • 5+ years of experience with financial data or working in a finance organization, translating complex data into actionable business insight

  • 5+ years of experience writing advanced to expert SQL, complemented by experience leveraging Python or R in an analytics setting

  • 5+ years of experience with modern BI/analytics visualization tools (e.g., Tableau, Power BI, Looker) or comparable technologies and cloud database platforms

  • 5+ years of experience leading large-scale analytics efforts with a proven track record of driving measurable business impact

Preferred Qualifications:

  • Exceptional written and oral communication and storytelling skills, with the ability to distill complex analytical findings into clear, decision-ready narratives for audiences across all levels of the organization

  • Experience across a broad analytics tech stack — BI/visualization platforms, statistical modeling, and data engineering fundamentals (ETL, dimensional/semantic modeling) —with the judgment to choose the right delivery mechanism for the insights

  • Exposure to or interest in AI-enabled conversational or agentic analytics tools (e.g., natural language querying, AI agents for automated insight generation or anomaly detection)

  • Demonstrated ability to identify ambiguous or complex technical problems and craft innovative solutions under time pressure

  • Experience creating or leveraging statistical models to inform business action

Education:

Bachelor’s degree in a quantitative or analytical field; equivalent years of related professional work experience may substitute.

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$101,970.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: 10/01/2026

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

CVS Health Chicago, Illinois, USA Office

525 W Monroe St, Chicago, IL, United States, 60661

CVS Health Northbrook, Illinois, USA Office

2211 Sanders Road, Northbrook, IL, United States, 60062

Similar Jobs

5 Days Ago
In-Office
Senior level
Senior level
Financial Services
Supports federal financial management through financial analysis, reconciliations, audit readiness, data validation, and executive reporting. Develops and maintains Tableau and Power BI dashboards, reports, datasets, scorecards, and visualizations; analyzes trends and exceptions; translates business requirements into reporting solutions; responds to leadership data requests; coordinates across teams; and mentors analysts.
Top Skills: Erp SystemsExcelPower BIPower Bi ServicePythonQlikRRelational DatabasesSQLTableauTableau PrepTableau Server
8 Days Ago
In-Office
Chicago, IL, USA
38-58 Hourly
Senior level
38-58 Hourly
Senior level
Legal Tech • Other • Professional Services • Real Estate • Business Intelligence • Consulting • Financial Services
Develops enterprise dashboards, reports, data models, and analytics solutions using Power BI or Tableau. Responsibilities include advanced SQL development, ETL/ELT workflows, data integration, executive reporting, data quality controls, issue resolution, testing, deployment, documentation, and stakeholder collaboration. The role supports operational, risk, regulatory, and financial services reporting initiatives.
Top Skills: AzureData WarehousingDatabricksDimensional Data ModelingEtl/EltMicrosoft FabricPower BISnowflakeSQLSynapse AnalyticsTableau
9 Days Ago
In-Office
Senior level
Senior level
Artificial Intelligence • Information Technology • Software • Database • Analytics
Owns enterprise BI reporting from stakeholder requirements through semantic modeling, SQL optimization, Power BI dashboards, paginated reports, governance, security, testing, and performance tuning. The role also supports Tableau development and administration, mentors junior developers, establishes BI standards, and documents architecture and data lineage.
Top Skills: AlteryxAzure SynapseBigQueryDatabricksDaxDbtFigmaLookerPower BIPower Query MQuicksightRedshiftSnowflakeSQLSQL ServerTableauTableau CloudTableau PrepTableau Server

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account