Sr. Business Intelligence Analyst

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.

What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow's health today, we want to hear from you.

Job Description

As a senior member of the Enterprise Portfolio Management Office (EPMO) within McKesson Technology (MT), this position plays a critical role in translating complex data into strategic insights that drive enterprise decision-making, portfolio optimization, and operational efficiency. The Sr. BI Analyst will lead data initiatives that enhance visibility, drive accountability, and support performance measurement across portfolios, programs, and IT investments.

This role requires a high degree of technical expertise, cross-functional collaboration, and business acumen to influence outcomes at both tactical and strategic levels. You will champion data quality, standardization, and governance practices, working closely with stakeholders across MT, finance, and business units to design and deliver impactful analytical products and visualizations.

This position will collect, manipulate and analyze business data from a variety of clients and sources. Preparing reports, in the form of visualizations such as graphs, charts and dashboards, detailing the significant results they deduced. A primary role will be to guard and protect the organization's data, making sure that the data repositories produce consistent, reusable data. Using standard formulas and methods, perform basic and advanced statistical evaluations and analysis of data in all stages including collection, analysis and reporting. You will be required to work closely with both internal teams and external customers to understand, define, and replicate best practices related to data quality and integrity programs. Responsibilities will include interpreting data, creating ad hoc reports, modifying and updating standard reports when applicable, perform statistical analysis, analyzing data to forecast trends and conduct predictability outcomes.

Key Responsibilities

• Uses Structured Query Language (SQL) to gather and assess data from the reporting database, transactional database, operational data store, and external systems to assist internal and external leadership in decision making.
• Lead the development and delivery of advanced dashboards, reports, and models using tools such as Power BI and other data visualization tools to provide insights on portfolio performance, resource utilization, and investment outcomes.
• Establish and champion data integrity protocols. Partner with IT and business units to monitor, improve, and enforce data quality standards across systems impacting EPMO reporting and analytics.
• Identify opportunities to optimize and automate reporting processes. Stay current on BI and analytics trends and bring forward best practices to improve the maturity of the organization's data capabilities.
• Lead efforts to forecast trends and model portfolio performance using advanced statistical techniques and business scenario analysis.

Reasonable and consistent attendance to fulfill requirements of the position

Educational Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field
• 7+ years of experience in data analysis, business intelligence, or portfolio analytics, ideally in an enterprise IT environment

Required Skills

• Advanced Power BI expertise, including data modeling, DAX, and development of impactful data visualizations tailored for executive and operational audiences
• Hands-on experience with Microsoft Fabric for unified data management and analytics across data engineering and business intelligence workflows
• Proficient in Power Automate to streamline and automate workflows between Microsoft and third-party applications
• Strong command of SQL for complex querying, data extraction, and transformation across multiple data platforms
• Experience with Databricks and Snowflake for scalable data processing, pipeline development, and advanced analytics use cases
• Awareness and practical application of Microsoft Copilot or similar generative AI tools to accelerate insights, reporting, and documentation
• Proven ability to partner across IT, finance, and business units to deliver actionable insights that drive strategic decisions

Desired Skills and Qualifications

• Working knowledge of company functions and the effects of data changes on those departments
• Working knowledge of research and communication skills and established skills in analytical tools such as MS Excel and MS Access
• Basic knowledge of business intelligence applications (e.g., Business Objects) and SQL
• Familiarity with Planview or similar portfolio/project management platforms
• Working knowledge of Python for data manipulation, statistical analysis, and integration into BI workflows

Strong understanding of data architecture principles, including data governance, integration, and metadata management

Physical Requirements
Professional office environment

Travel may be required in some circumstances < 10%

We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, pleaseclick here.

Our Base Pay Range for this position

McKesson is an Equal Opportunity Employer

McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson's full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.

Join us at McKesson!