Business Intelligence – Report Developer

at  McKesson

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 SUMMARY

Reporting to the Director of Data & Analytics, the Business Intelligence (BI) Report Developer acts as a business enabler to a select line of business of the Biopharma & Provider Solutions (“BPS”) organization to ensure teams have advanced dashboards, analytics and insights that (i) augment their experience and intuition to make sound business decisions and (ii) unlock additional value for both McKesson and its biopharma or provider customers.
With this role, you will be responsible for design, development, implementation, and support of internal and customer facing Business Intelligence reports and dashboards. Working with cross-functional teams, you will participate to gather and document reporting requirements to meet business needs. Using your skills and experience as a BI Report Developer, you will then use those requirements to design, develop, test and implement reports and dashboards to drive strategic decision making and improve business performance. You will recommend solutions to new and complex problems, partner with D&A and IT teams to develop innovative strategies, evaluate the potential impact of changes, and recommend process improvements. You will transform data into meaningful insights that enable the success of our internal and external customers. You will create and leverage complex models, reports, and dashboards from internal and external data sources, in collaboration with our data & analytics (“D&A”) and IT teams, to drive an impactful dialogue on hindsight, insight, and foresight. You will also be asked to execute other related analytics activities.

MINIMUM QUALIFICATIONS

• University degree in relevant data related field of study. Master’s degree preferred.
• Minimum 4+ years’ experience in developing and implementing enterprise-scale reports and dashboards including (i) working with users in a requirements analysis role (ii) extensive experience with data warehouse implementations (iii) knowledge and experience with data modelling concepts
• Strong knowledge of data visualization tools such as Power BI, Tableau. Experience in a Power BI administrator position, either as a User admin or Power Platform admin is an asset.
• Experience with cloud data warehouses is a must (e.g. Snowflake)
• Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures
• Knowledge of Canadian biopharma landscape, Patient Support Programs, Specialty pharmacies, infusion clinics, technology solutions for physicians, and general healthcare industry is an asset.

SPECIFIC RESPONSIBILITIES

• Analyzes and understands business requirements in the context of desired reporting and dashboard requirements
• Translates business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
• Designs and maps data models to shift raw data into meaningful analytics and insights
• Provides support, as required, to ensure the availability and performance of developed reports and dashboards for both external and internal users
• Utilizes Power BI to build interactive and visually appealing dashboards and reports
• Identifies, standardizes, and/or automates existing and new reports, scorecards, and processes (where applicable) – in collaboration with other members within the team and/or business unit
• Oversees SSRS reports shared with assigned customers. Executes the transition of reporting into Power BI Report Builder.
• Develops strong data documentation about algorithms, parameters, models. Ensures proper configuration management and change controls are implemented.
• Provides technical assistance and cross training to other team members. Design and implement best practices, guidelines and repeatable processes.
• Focuses on data and information reporting that requires (1) additional analysis or thinking, and/or (2) discussion on insights, gaps, and opportunities
• Identifies, investigates, evaluates new opportunities for business value creation
• Manages and executes change requests as per internal and customer needs
• Challenges the way we are doing things to set up teammates and the business for success

GENERAL RESPONSIBILITIES

• Identifies and reviews opportunities for continuous improvement with the D&A team; makes recommendations and implements solutions, as required.
• Promotes cooperation within own team, as well as between groups and with other departments, especially IT
• Acts as a McKesson ambassador of corporate values and of data-driven decision-making.
• Build a strong understanding of strategic priorities for the business through development of stakeholder relationships
• Develops and maintains internal and external networks to support knowledge gathering and sustainable sharing of best practices in descriptive, predictive, and prescriptive analytics across McKesson Canada.
• Recommends creation and adoption of new tools for advanced reporting and analytics in line with customer and business needs.