Senior Analyst, Transport

Loblaw Companies Limited; Cambridge; On-site; CAD 75,000 - 95,000; Full time

Job summary

A leading Canadian grocery retailer is seeking a Data Engineer to design and maintain ELT pipelines, build data models, and develop BI dashboards that support transportation network optimization and performance tracking. The ideal candidate will have over 2 years of experience in data engineering or business intelligence, proficiency in SQL and Python, and strong communication skills. This full-time role offers a dynamic work environment and supports diversity, equity, and inclusion initiatives.

Benefits

Comprehensive training

Flexible work options

Competitive benefits

Qualifications

• 2+ years of experience in data engineering, analytics, or business intelligence roles—preferably within logistics or transportation domains.
• Strong proficiency in SQL and Python.
• Experience designing ELT pipelines and working with automation tools.

Responsibilities

• Own the design and maintenance of ELT pipelines.
• Build and scale data models for optimization and forecasting.
• Develop and maintain BI dashboards (Power BI) to track KPIs.

Skills

Data engineering

Analytics

Business intelligence

SQL

Python

Power BI

Excellent communication skills

Tools

Power Query

VBA

SAS

Teradata

Tableau

Job description

At Loblaw, we help millions of Canadians get through their best days, worst days, celebration days, and every day. Through our innovation and quality products, we’re here for our friends, neighbours, family members and colleagues.
We succeed through collaboration and commitment and set a high bar for ourselves and those around us.
We’re looking for adaptable people who are thrilled to join us in our goal of helping Canadians Live Life Well®. Whether you are just starting your career, re-entering the workforce, or looking for a new job, this is where you belong. We promote leaders at every level and support our people to follow their passion.

What you'll do:

• Own the design and maintenance of ELT pipelines—including API integrations, Power Query transformations, and automation workflows.
• Build and scale data models that support transportation network optimization, volume forecasting, and asset utilization.
• Develop and maintain BI dashboards (Power BI) to support tracking of KPIs such as lane performance, asset turnover rates, and cost trends.
• Automate reporting and data validation processes to enable self-serve analytics and reduce manual workloads.
• Manage and monitor scheduled data refreshes to ensure accuracy and reliability of dashboards and reports.
• Conduct ad-hoc analyses to support contract negotiations, network planning, and seasonal contingency strategies

What you bring:

• Proficiency in Microsoft Office Suite, including Word, Excel, PowerPoint, and Outlook.
• 2+ years of experience in data engineering, analytics, or business intelligence roles—preferably within logistics or transportation domains.
• Strong proficiency in SQL, Python, and data visualization tools such as Power BI or Tableau.
• Experience designing ELT pipelines and working with automation tools (e.g., Power Automate, VBA) and data platforms like Teradata or SAS.
• Familiarity with supply chain data structures and key performance metrics is a plus.
• Ability to collaborate effectively with both technical teams and operational stakeholders.
• Excellent communication skills, with the ability to translate complex business questions into actionable data solutions.

Preferred Skills

• Familiarity with SAS, Teradata, relational databases, and enterprise systems commonly used in logistics (e.g., SAP, TMS, JDA).
• Exposure to agile methodologies and tools such as Jira, Power Apps, and RPA technologies (e.g., UiPath, Appian).
• A background in project-based analytics delivery or experience within the transportation industry is a strong asset

Loblaw is committed to sustainability by sourcing products with integrity and making a positive difference in the community. Our CORE Values – Care, Ownership, Respect and Excellence – guide all our decision‑making and come to life through our Blue Culture. We offer our colleagues progressive careers, comprehensive training, flexibility, and other competitive benefits – these are some of the many reasons why we are one of Canada’s Top Employers, Canada’s Best Diversity Employers, Canada’s Greenest Employers & Canada’s Top Employers for Young People.

Employment Type: Full time

Type of Role: Regular

We have a long‑standing focus on diversity, equity and inclusion because we know it will make our company a better place to work and shop. We are committed to creating accessible environments for our colleagues, candidates and customers. Requests for accommodation due to a disability (which may be visible or invisible, temporary or permanent) can be made at any stage of application and employment. We encourage candidates to make their accommodation needs known so that we can provide equitable opportunities.

Please Note:

Candidates who are 18 years or older are required to complete a criminal background check. Details will be provided through the application process.