Senior Analyst, Business Intelligence
Core
Define business challenges, translate requirements into data models, and develop interactive reports and dashboards to support decision-making in McKesson Canada's Pharma Distribution businesses.
Role type
Senior Business Intelligence Analyst
Builds
Data models, DAX measures, and interactive Power BI reports/dashboards
Domain
Healthcare / Supply Chain Analytics
Deliverable
dashboards & analysis
Required skills
SQL, Oracle, Snowflake, Power BI, DAX, data modeling, data quality diagnosis
Preferred skills
Microsoft Power Platform (Power Apps, Power Automate), M Query, Python, machine learning, natural language processing, predictive analytics, statistical models
Technologies
AI, DAX, Machine Learning, Microsoft Power Platform, Oracle, Power BI, Python, SQL, Snowflake
Responsibilities
Work with managers and analysts to define business challenges and gather requirements; Use SQL to retrieve and analyze information from reporting and transactional databases; Create data models and DAX measures for business intelligence; Develop interactive reports and dashboards using Microsoft Power BI; Assess data quality and work with IT to correct source data; Research business data analysis best practices and share information with stakeholders.