Senior Business Intelligence & Automation Analyst

McKesson Corporation

Confirmed live 2 days ago High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Irving, TX
Salary
$114,200–$190,400 / yr
Posted
6 days ago
Freshness
Confirmed live 2 days ago

Market check

Salary context

Competitive pay

How this pay compares to similar roles

Similar $149k
This role $152k
$105k most similar roles pay here $200k

This role pays more than 57% of similar roles. Most pay $120,250–$177,850 — the shaded band above. At the midpoint, this role pays about $152k versus about $149k for comparable roles.

Based on 239 similar postings.

Employer

About McKesson Corporation

McKesson Corporation is a premier American healthcare services company that distributes pharmaceuticals, medical-surgical supplies, and provides technology to the healthcare industry.

McKesson Corporation currently has 4 open roles on FindRole.

Most-posted roles

View all roles at McKesson Corporation

At a glance

TL;DR · Senior Business Intelligence & Automation Analyst

Senior Business Intelligence & Automation Analyst The Senior Business Intelligence & Automation Analyst serves as a high-visibility individual contributor within the AIM28 Finance team to build and scale analytics, reporting, and value-realization capabilities. This role involves designing end-to-end data models, ETL pipelines, and automated dashboards to transform fragmented data into trusted insights for executive leadership. The position requires expert proficiency in SQL, Python, Power BI, Tableau, and tools like Databricks or Snowflake. Candidates must also utilize Power Automate and explore AI-enabled capabilities such as automated narratives and conversational agents. Working within the U.S. Pharmaceutical Distribution segment, the role focuses on the AIM28 transformation program to track KPIs and investment outcomes. The ideal candidate possesses strong financial acumen regarding ROI and forecasting while independently managing the full technical stack to provide a single source of truth for complex business programs.

What you'll do

  • Design and maintain executive-facing dashboards to track KPIs, investments, and value-realization for the AIM28 program.
  • Build and manage scalable ETL/ELT pipelines to transform raw, multi-dimensional data into structured, consumable datasets.
  • Automate recurring reporting workflows by replacing manual processes with scheduled data flows and AI-enabled narratives.
  • Establish business logic and metric definitions to create a single source of truth for financial and program performance.
  • Conduct deep-dive analyses on benefit variances and performance trends to provide actionable recommendations to senior leadership.
  • Develop semantic models and curated datasets that support both human self-service and AI-powered analytics.
  • Partner with finance teams to codify complex financial concepts like ROI, forecasting, and variance-to-plan into data models.
  • Manage the end-to-end delivery of analytics solutions, including requirements gathering, design, development, and user adoption.

What we're looking for

  • Bachelor’s degree in a quantitative field or equivalent experience; advanced degrees are preferred.
  • At least 7 years of relevant experience as a BI Engineer, Data Analyst, Analytics Engineer, or Data Engineer (fewer years required with a Master's).
  • Expert proficiency in SQL for complex query development and performance tuning on large datasets.
  • Advanced skills in Power BI or Tableau for creating executive-grade dashboards and data modeling.
  • Experience building ETL/ELT pipelines using tools like Databricks, Microsoft Fabric, Azure Data Factory, or Snowflake.
  • Proficiency in Python or similar languages for automation and scripting to clean and transform data.
  • Proven experience with financial concepts such as ROI, forecasting, variance-to-plan, and business-case logic.
  • Demonstrated ability to work as a standalone technical individual contributor without a dedicated engineering team for support.

More like this

Similar roles

Senior Business Intelligence Engineer

DoorDash, Inc

New York, NY +7 127 days ago $118,300$174,000
DBT Looker BigQuery Fivetran Census Cloud Functions Salesforce NetSuite SQL Python Airflow Cloud Composer API Integration Data Pipelines AI Infrastructure Tableau Mode

Business Intelligence Analyst II

Twilio

Remote (Colombia) 9 days ago
SQL Tableau Confluence Acryl Looker ETL Hive Presto Spark Zeppelin Generative AI GitHub Copilot ChatGPT Gemini Data Warehousing Distributed Computing
3+ yrs exp Remote