MID Business Intelligence Analyst

McKesson is an impact-driven, Fortune 10 company that focuses on making quality healthcare more accessible and affordable. The Business Intelligence Analyst – Medically Integrated Dispensing will support analytics, reporting, and insights for MID programs, partnering with internal teams to drive operational performance and financial visibility.

Responsibilities:

• Analyze distribution data along with operational metrics to support internal performance monitoring
• Identify trends in volume, reimbursement, utilization, and payer mix
• Support root cause analysis to identify performance gaps and operational issues
• Contribute to development and tracking of standard MID KPIs
• Assist with trend analysis, performance tracking, and forecasting support
• Contribute to reporting on program ramp and growth across the MID portfolio
• Partner with internal Operations, Finance, and Account Management teams to support performance management
• Collaborate with internal data and technology teams to ensure data availability, quality, and consistency
• Support analytics needs across the MID client portfolio, including routine and ad hoc analysis
• Support analysis of financial performance, including: Revenue and margin trends, Drug acquisition costs, Reimbursement variability
• Prepare inputs and insights for quarterly business reviews (QBRs) and client deliverables
• Translate data into clear, actionable insights and summaries for client consumption
• Support customization of analytics for practice-level and program-level decision making
• Participate in client meetings and data reviews, as needed
• Respond to client and internal requests for data, analysis, and performance insights
• Support analytics for new business opportunities and prospective MID clients
• Develop data inputs and supporting insights for proposals and solution design
• Analyze referral trends, utilization patterns, and growth opportunities
• Support preparation of data for pro forma models and business cases
• Develop and maintain tables, reports, dashboards in Power BI, SSRS, Tableau, Snowflake, Databricks, or similar tools
• Build and update client-facing and internal reporting outputs
• Support creation of standardized reporting templates across clients
• Ensure accuracy, consistency, and timeliness of all reporting deliverables
• Maintain and enhance existing dashboards and reporting assets

Requirements:

• Degree or equivalent and typically requires 4+ years of relevant experience
• 4+ years of experience analyzing prescription claims data
• Substantially proficient with PowerBI, SQL, Databricks, Snowflake
• 4+ years of experience in data analysis, reporting, or business intelligence in a healthcare related field
• Strong knowledge of Pharmacy claims and dispensing data
• Strong knowledge of Drug purchasing data and cost structures
• High proficiency in PowerBI, SQL, Snowflake, Tableau and Databricks
• Extensive understanding and application of ETL processes
• Experience working with large, complex datasets
• Strong attention to detail and ability to produce accurate, reliable outputs
• Ability to communicate findings clearly in written and verbal formats
• Strong analytical and problem-solving skills
• Ability to translate data into structured insights with guidance
• High attention to detail and commitment to data accuracy
• Ability to manage multiple tasks simultaneously in a fast-paced environment
• Experience of specialty pharmacy and MID environments
• Exposure to client-facing environments or consulting models
• Experience using AI tools to support analytics and reporting
• Experience supporting financial or operational reporting