Senior Analyst, Business Intelligence (12 month Contract)

Description

The company Canada is a Fortune 10 company in healthcare, known for insights, products and services that support quality care that is more accessible and affordable.

This role sits in the Supply Chain Analytics centre of excellence and reports to the Director of Business Intelligence. It supports the company Canada's largest segment, Pharma Distribution.

You will work with business analysts and management to build interactive reports and dashboards that show the current state of Pharma Distribution, reveal trends and help solve problems.

Responsibilities

• Meet with management and analysts to pin down business problems, gather requirements and turn them into data models and measures.
• Write SQL to pull and assess data from the reporting database, transactional database, operational data store and external systems, so leaders can make decisions.
• Create data models and DAX measures that feed visualizations.
• Design highly interactive, insightful Power BI reports.
• Bring emerging analytics technology into the supply chain team to encourage new approaches.
• Check data quality across the database and work with IT to fix source data or build translation sources where needed.
• Keep up with best practices in business data analysis through publications, formal training and professional development.
• Explain report content and how to use Power BI to stakeholders.

Requirements

• 3+ years of work in business intelligence or a similarly analytical business function.
• Strong analytical reasoning, able to structure unclear problems and troubleshoot them.
• Experience writing SQL queries.
• Working knowledge of SQL, Oracle and Snowflake databases and their architecture.
• Ability to troubleshoot data quality issues.
• Experienced with Power BI or a similar BI platform.
• Bachelor's degree in a related field such as computer science, mathematics or engineering.
• Bilingual in written and spoken English and French.
• Optional: experience with the Microsoft Power Platform (Power BI, Power Apps and Power Automate).
• Optional: strong knowledge of DAX and the M query language.
• Optional: understanding of data models and of building Power BI reports with a focus on user interface design.
• Optional: knowledge of AI tools such as machine learning and natural language querying.
• Optional: understanding of statistical models for predictive analytics, such as regressions.
• Optional: familiarity with Python.
• Optional: ability to build rapport and credibility across the organization and persuade others with ideas and proposals.

Conditions

12-month contract.

Base pay range is $99,100 to $132,100.

Equal opportunity employer.

Benefits

• Competitive total rewards package, with pay based on performance, experience and skills, equity, regular market reviews and geographic market.
• Other compensation, such as an annual bonus or long-term incentive opportunities, may be offered.