Senior Business Data Analyst

Loblaw Companies Limited; Brampton; Hybrid; CAD 60,000 - 83,000; Full time

Job summary

Loblaw Companies Limited is seeking a Senior Business Data Analyst to join the Finance Insights and Technology Engagement (FITE) team in Brampton. You will work with Finance stakeholders to turn BI needs into actionable insights using SQL, Python, and BI tools.

The role requires strong SQL, GCP, and data governance knowledge, plus experience with BigQuery/Teradata. Enjoy a hybrid work model with four days in office at Brampton.

Qualifications

• We require 3+ years in a similar analytics role.
• University degree in Finance, Business, Math/Statistics, Analytics or related field.
• Strong SQL and data modeling skills with BigQuery/ Teradata experience.
• Experience with Python, VBA, and BI tools (Power BI/Tableau).
• Knowledge of data governance and cloud analytics (GCP) a plus.

Responsibilities

• Partner with Finance stakeholders to translate BI needs into solutions.
• Develop reports, dashboards, and models from financial data using Strategy, Power Platform, and Excel.
• Lead project delivery from inception to completion with risk mitigation.
• Facilitate code and data design reviews with teams and Loblaw Technology.
• Document processes and findings for technical and non-technical readers.
• Bridge Finance and Technology needs in data management and analytics.
• Develop and optimize large SQL queries for ETL in BigQuery and Teradata.
• Build Python and VBA scripts to automate data tasks.
• Perform root cause analysis on data issues and implement fixes.
• Present project updates to senior leadership weekly.

Skills

SQL

BigQuery

Teradata

Python

SAS

Gitlab

Power BI

Tableau

GCP

AI modelling

Data governance

Education

University degree in Finance/Business/Analytics

Tools

MS SQL Server

Power Platform

Excel

Google Cloud Platform (GCP) tooling

Job description

Come make your difference in communities across Canada, where authenticity, trust and making connections is valued – as we shape the future of Canadian retail, together. Our unique position as one of the country’s largest employers, coupled with our commitment to positively impact the lives of all Canadians, provides our colleagues a range of opportunities and experiences to help Canadians Live Life Well®.

At Loblaw Companies Limited, we succeed through collaboration and commitment and set a high bar for ourselves and those around us. Whether you are just starting your career, re-entering the workforce, or looking for a new job, this is where you belong.

About the Team

The Finance Insights and Technology Engagement ( FITE ) team at Loblaw is responsible for managing centralized financial analytics and reporting for Canada’s largest and most successful retailer. Our multifaceted team synergizes their skills across various key domains including data governance, analytics, business intelligence development, and process automation.

About the Role

We are looking for a talented and motivated Senior Business Data Analyst to join the Finance Insights and Technology Engagement (FITE) team. You will be working with various teams and stakeholders to foster relationships, understand requirements, and use a vast array of tools to deliver tech-based solutions. You will also rely on a creative mind and be able to think outside of the box. The ability to communicate and present to various levels within the business and to external partners is of utmost importance. A strong knowledge of SQL is required, as well as working knowledge of Google Cloud Platform (GCP) and Python.

Please note our hybrid work policy is 4 days in office at 1 President’s Choice Circle in Brampton.

Responsibilities:

• Proactively partner with Finance stakeholders to identify, analyze, and translate their Business Intelligence needs into strategic solutions, delivering timely and accurate insights.
• Develop insightful reports, dashboards, and analytical models from extensive financial data using Strategy, Power Platform, and Excel, and deliver data-driven solutions to critical business challenges.
• Drive successful project delivery by expertly managing all phases from inception to completion encompassing requirement gathering, project scoping, effort estimation, risk mitigation strategies, progress tracking, and critical issue escalation.
• Drive technical excellence by actively facilitating code and data design reviews with both internal team members and Loblaw Technology counterparts.
• Create and maintain comprehensive, accurate documentation of team processes, methodologies, and analytical findings, ensuring clarity for both technical and non-technical stakeholders and preserving institutional knowledge.
• Act as a technical liaison between Finance and Technology teams to bridge the gap between Finance business needs and technical capabilities in data management, reporting, and analytics.
• Develop, maintain, and optimize large-scale SQL queries (e.g., in Google BigQuery, Teradata) for data extraction, transformation, and loading (ETL) to support financial reporting and analysis.
• Design, build, and enhance Python and VBA scripts to automate data transformation, validation, and reporting processes to reduce manual effort and improve data accuracy.
• Perform root cause analysis on data discrepancies and system issues impacting financial data integrity, proposing, and implementing corrective actions.
• Participate in weekly huddles and present project updates to senior leadership during team meetings.

Role Requirements:

• Minimum 3 years related work experience in a similar role.
• University degree or post-secondary education in Finance, Business, Math/Statistics, Analytics or other relevant field.
• Working knowledge of database applications such as Google BigQuery, MS SQL Server and Teradata.
• Advanced level SQL skills, including complex joins, window functions, Common Table Expressions (CTEs), and performance tuning.
• Working Experience with Application Tools such as SAS, Python, Gitlab, etc.
• Foundational knowledge of data governance, predictive analytics, AI and modelling.
• Familiarity with other GCP services such as Google Cloud Storage (GCS), Dataflow, Composer (Airflow), or Cloud Functions.
• Familiarity with and/or exposure to BI Tools such as MicroStrategy, Power BI, Tableau, and financial systems and processes etc.
• Previous experience with SAP S4 (or similar ERP systems) is an asset.

Core Competencies:

• Exceptional analytical skills and proven capability to drive insights from data and analytics.
• Ability to self-organize multiple tasks well and to complete them on time with a clear focus on quantitative and/or qualitative results.
• Excellent verbal and written communication skills.
• Willingness to work well in a fast-paced team environment.
• Ability to “think outside the box”.

Our commitment to Sustainability and Social Impact is an essential part of the way we do business, and we focus our attention on areas where we can have the greatest impact. Our approach to sustainability and social impact is based on three pillars – Environment, Sourcing and Community – and we are constantly looking for ways to demonstrate leadership in these important areas. 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.

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.

Our commitment to Sustainability and Social Impact is an essential part of the way we do business, and we focus our attention on areas where we can have the greatest impact. Our approach to sustainability and social impact is based on three pillars – Environment, Sourcing and Community – and we are constantly looking for ways to demonstrate leadership in these important areas. 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.

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.

Hiring Range / Échelle salariale à l’embauche :

$60,000.00 - $82,500.00 / 60.000,00$ - 82.500,00$ (per year / par an)

A candidate’s experience and knowledge as well as the geographical region in which the position is located may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy. The Company uses artificial intelligence for the purpose of screening, assessing and/or selecting applicants for this position. / L’expérience et les connaissances d’un candidat ainsi que la région géographique dans laquelle le poste est situé peuvent être prises en compte dans la rémunération qu’un candidat reçoit pour ce poste. Cette offre d’emploi concerne un poste vacant existant. L’entreprise utilise l’intelligence artificielle dans le but de filtrer, d’évaluer et/ou de sélectionner les candidats à ce poste.

#EN

#SS #FINAN #ON