Sr. Business Data Analyst, Finance Insights and Technology Engagement

Overview
Venez faire votre différence dans les communautés à travers le Canada, où l'authentic ité, la confiance et l'établissement de liens sont valorisés - alors que nous façonnons l'avenir du commerce de détail au Canada, ensemble. Notre position unique en tant que l'un des plus grands employeurs du pays, celle associée à notre engagement à avoir un impact positif sur la vie de tous les Canadiens, vient offrir à nos collègues une gamme d'opportunités et d'expériences pour aider les Canadiens à Vivre Bien, Vivre Pleinement.

Chez Les Compagnies Loblaw Limitée, nous réussissons grâce à la collaboration, à l'engagement et nous plaçons la barre haute pour nous-mêmes et ceux qui nous entourent. Que vous débutiez votre carrière, que vous réintégriez le marché du travail ou que vous recherchiez un nouvel emploi, votre place est avec nous.

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 Micro Strategy, Power Platform, and Excel, delivering 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 gap between business finance and technical capabilities in data management, reporting, and analytics.

Develop, maintain, and optimize large-scale SQL queries (e.g., in Google Big Query, 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 Big Query, 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 Micro Strategy, Power BI,…