Automation Analyst

TaskVerse; United States; On-site; USD 110,000 - 180,000; Full time

Benefits offered by this job

Health benefits

Professional growth

Collaborative environment

Work-life balance

Job summary

McKesson seeks a Senior Business Intelligence Analyst to own the analytics stack for the AIM28 program, delivering trusted insights to executives and program leaders. You will design end-to-end data models, ETL pipelines, dashboards, and AI-enabled reporting in a finance-centric environment.

As the sole analytics builder within AIM28 Finance, you will partner with Big Bet teams and McKesson Technology to codify KPI definitions, automate reporting, and drive self-service analytics across the US

Qualifications

• Builder's mindset: transform loosely defined problems into comprehensive solutions.
• Comfort with ambiguity and imperfect data.
• Business acumen and financial literacy; experience with ROI, forecasting, variance analysis, and business-case logic.

Responsibilities

• Design, build, and maintain program-level and Big Bet dashboards tracking KPIs, benefits, investments, milestones, and value realization.
• Develop executive-facing reports for leadership meetings; translate data into actionable insights.
• Automate recurring benefit and program reporting; replace manual workflows with automated data flows.
• Implement automation across reporting workflows, including AI-driven narratives and summaries to surface insights.
• Build and maintain scalable ETL/ELT pipelines for large, multi-source datasets.
• Ingest and integrate data from various sources into harmonized datasets and models.
• Document business logic, data lineage, and metric definitions for transparency.
• Partner with finance to codify KPI definitions and benefit methodologies into governed data models.
• Conduct deep-dive analyses on KPI movements and program performance; provide root cause insights.
• Respond to ad hoc analytical questions; triangulate data sources to validate findings.
• Enable governed self-service analytics for stakeholders; reduce ad hoc requests.
• Prioritize reporting and automation backlog based on business impact; keep stakeholders informed.
• Set standards for analytics practices and coach junior analysts.

Skills

SQL

Data modeling

BI visualization

Automation

AI analytics

Finance acumen

Strong communication

Standalone IC

Job description

About The Company

McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve - we care.

About The Company

McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve - we care.

About The Role

The Senior Business Intelligence Analyst at McKesson is a highly visible, hands-on individual contributor responsible for building and scaling AIM28's analytics, reporting, and value-realization measurement capabilities. Reporting directly to the AIM28 Finance Lead, this role involves designing and owning end-to-end data models, ETL pipelines, dashboards, and automation solutions that convert complex, fragmented data into trusted insights for executives and program leaders. The role also includes supporting strategic projects across the organization. Ideal candidates will possess deep technical expertise in SQL, data modeling, BI visualization, automation, and AI-enabled analytics, combined with strong business and finance acumen. Operating as the sole analytics builder within the AIM28 Finance team, this individual will establish the program's single source of truth for key performance indicators, benefits, investments, and value-realization reporting. They will also drive self-service analytics, reporting automation, and AI-powered insights across the AIM28 portfolio. This position involves leading the development of business intelligence, data visualization, analytics, and automation for the AIM28 program and other strategic initiatives within U.S. Pharmaceutical Distribution (USPD). AIM28 is McKesson's AI-enabled transformation program, structured around Big Bets, each accountable for delivering measurable business outcomes. The Senior Business Intelligence Analyst will translate Big Bet data into automated, trusted benefit and value-realization reports for program leadership and senior executives. The role requires architecting AI-ready analytics and reporting models that combine traditional dashboards with AI capabilities such as automated narratives and conversational agents, enabling stakeholders to self-serve insights more efficiently. The candidate will establish transformation logic for raw data, integrate scattered reporting sources into standardized solutions, and act as a highly visible individual contributor, owning the full analytics stack from requirements to deployment and adoption. Working closely with the AIM28 Finance Lead, Big Bet teams, transformation office, and McKesson Technology, the analyst will codify KPI definitions and benefit methodologies into governed data models, ensuring consistency and accuracy across the program. This role is embedded within Finance, not a traditional BI or data engineering team, requiring the candidate to independently design, develop, troubleshoot, and maintain solutions, often working with raw, manual, or inconsistent data sources.

Qualifications

To excel in this role, candidates should demonstrate a builder's mindset, capable of transforming loosely defined problems into comprehensive solutions. Comfort with ambiguity and imperfect data is essential, as the role involves working with raw extracts, manual spreadsheets, and shifting requirements. Business acumen and financial literacy are critical, with experience partnering with finance or FP&A teams, understanding ROI, forecasting, variance analysis, and business-case logic.

The ideal candidate is a standalone technical individual contributor, comfortable owning the entire analytics process end-to-end without reliance on a dedicated team. Proven experience developing and monitoring KPIs, building automated reporting systems, and replacing manual workflows is required. Strong communication skills are necessary to present findings to senior leadership effectively, both in writing and verbally.

Additional qualifications include excellent organizational and prioritization skills, curiosity about AI applications such as GenAI and conversational agents, and a proactive approach to continuous improvement and stakeholder engagement. Technical skills should include expert-level SQL, data modeling, and design skills, with the ability to optimize complex queries and performance tuning on large datasets.

Responsibilities

• Design, build, and maintain program-level and Big Bet dashboards that track KPIs, benefits, investments, milestones, and value realization, serving as the single source of truth for program performance.
• Develop executive-facing reports for leadership meetings, translating complex data into actionable insights.
• Automate recurring benefit and program reporting processes, replacing manual workflows with scheduled, validated, and monitored data flows.
• Implement automation opportunities across reporting workflows, including AI-driven narratives and summaries to surface insights proactively.
• Build and maintain scalable ETL/ELT pipelines to extract, transform, and clean large, multi-source datasets for automated reporting.
• Ingest and integrate data from various sources, including raw operational data, manual files, and dashboards, into harmonized, consumable datasets and models.
• Establish and document business logic, data lineage, and metric definitions, ensuring transparency and maintainability.
• Partner with finance teams to codify KPI definitions and benefit methodologies into governed data models for consistent measurement.
• Conduct deep-dive analyses on KPI movements, benefit variances, and program performance, providing leadership with root cause insights and recommendations.
• Respond to ad hoc analytical questions, triangulating data sources to validate findings and ensure data fidelity.
• Enable governed self-service analytics for stakeholders, reducing ad hoc requests and fostering data-driven decision-making.
• Prioritize reporting and automation backlog based on business impact, keeping stakeholders informed of progress and trade-offs.
• Set standards for analytics practices, including data integrity, documentation, and version control, and coach business analysts in reporting best practices.

Benefits

McKesson offers competitive compensation packages, comprehensive health benefits, and opportunities for professional growth and development. Employees gain access to a collaborative environment that fosters innovation and continuous learning. We support work-life balance through