Analyst Business Intelligence

Medline; Mississauga; On-site; CAD 81,600 - 122,400; Full time

Benefits offered by this job

Comprehensive benefits plan

RRSP with company match

Paid vacation and personal days

Job summary

Medline is looking for an Analyst, Business Intelligence, to support the design and maintenance of Power BI dashboards for Inventory Management in Mississauga. This role entails translating complex financial data into actionable insights and collaborating with various teams.

The successful candidate will have 3–5 years of BI experience, particularly with Power BI. A competitive salary ranging from $81,600 to $122,400 annually, plus benefits, is offered.

Qualifications

• 3–5 years of experience in BI/reporting roles.
• Strong proficiency in Power BI Desktop & Service.
• Solid understanding of Inventory Management.

Responsibilities

• Design and maintain Power BI dashboards for Inventory Management.
• Collaborate with stakeholders to gather business requirements.
• Ensure data accuracy and integrity across inventory reports.

Skills

Power BI proficiency

SQL skills

Data modeling

Problem-solving

Education

3–5 years of experience in BI/reporting roles

Tools

Microsoft Power BI

SAP

Python

Job description

Job Description Summary

We are seeking an Analyst, Business Intelligence to support the design, development, and maintenance of interactive dashboards and reports for Inventory Management stakeholders. This role will work closely with Inventory Management, Accounting, FP&A, and business teams to translate financial data into meaningful insights that support decision‑making.

The ideal candidate has strong experience in Microsoft Power BI, solid understanding of Inventory Management processes, and the ability to transform complex datasets into intuitive visualizations.

Benefits

• Collaborative work environment with highly engaged employees
• Market competitive compensation and benefits plan, including LTD & Insurance
• RRSP with a company match
• Annual Employee Appreciation Week
• Paid vacation and personal days
• Employee Assistance Program (EAP) Resources supporting mental, physical, family and financial well‑being
• Career growth and training programs
• Open communication with Senior Leaders
• Tailored incentives for eligible employee groups, such as home office reimbursement
• Employee referral program
• Education support programs
• Fitness subsidy
• Recognition programs
• Social activities
• And much more…

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports for Inventory Management processes (e.g., inventory health, stock levels, turns, aging, service levels, fill rate, OTIF, and KPI tracking).
• Collaborate with Inventory Management, Demand Planning, and Purchasing stakeholders to gather business requirements and translate them into scalable reporting and analytics solutions.
• Build and optimize Power BI data models, measures, and relationships to support inventory visibility and decision‑making.
• Develop and maintain ETL processes using Power Query and related data transformation tools to integrate inventory, supply, and demand data.
• Ensure data accuracy, consistency, and integrity across inventory reports and analytics outputs.
• Manage and maintain Power BI workspaces, including access control, deployment pipelines, and governance practices.
• Leverage Microsoft Fabric capabilities (e.g., dataflows, lakehouse, semantic models) to enhance data integration, scalability, and performance of inventory analytics.
• Work with data from ERP systems (e.g., SAP), warehouse management systems, and other enterprise data sources.
• Optimize report performance and troubleshoot issues related to data refresh, model performance, and visualization efficiency.
• Document data models, report logic, KPIs, and business definitions related to inventory management.
• Provide training and support to end‑users on Power BI dashboards and self‑service inventory analytics capabilities.
• Support continuous improvement initiatives focused on inventory optimization, working capital reduction, and service level performance.
• Leverage Python for advanced data analysis, automation, and data transformation (e.g., building data pipelines, performing complex calculations, and enhancing Power BI datasets through integrated workflows).

Qualifications

• 3–5 years of experience in BI/reporting roles, with at least 2–3 years of hands‑on experience in Power BI.
• Strong proficiency in:
  • Power BI Desktop & Service
  • Power Query (M language)
  • Data modeling concepts
• Solid understanding of Inventory Management and accounting principles.
• Strong SQL skills and experience working with relational databases.
• Experience integrating data from ERP systems (e.g., SAP, Oracle, Dynamics, etc.) is an asset.
• Hands‑on experience with Power BI Service, including workspace management and deployment pipelines.
• Familiarity with Microsoft Fabric (Dataflows Gen2, Lakehouse, or related components) is an asset.
• Ability to translate business requirements into technical solutions.
• Strong analytical, problem‑solving, and communication skills.

Salary Range

$81,600.00 – $122,400.00 Annual

EEO Statement

Medline Canada, Corporation is proud to be an equal opportunity employer. All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

Diversity and Inclusion Commitment

Medline Canada is committed to diversity and inclusivity and encourages applications from historically disadvantaged and marginalized groups, including First Nations, Metis and Inuit peoples, Indigenous peoples of North America, racialised persons/persons of colour, women, persons with disabilities and LGBTQ+ persons.

Accessibility Commitment

Medline Canada is committed to the principles of accessibility in Canada. We endeavor to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities. If you require any accommodations at any point during the application and hiring process, please contact [e-mail].