Senior Finance Data & BI Analyst - SQL + Python

Loblaw

Brampton

Hybrid

CAD 60,000 - 83,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work policy (4 days in office)
Progressive careers
Comprehensive training
Flexibility
Competitive benefits

Job summary

Loblaw Companies Limited is seeking a Senior Business Data Analyst to join the Finance Insights and Technology Engagement team in a hybrid role at Brampton. You will partner with Finance stakeholders, design BI solutions, and lead analytics projects across tools like Google BigQuery, Power BI, and Python.

Responsibilities include developing dashboards, optimizing ETL processes, and presenting updates to senior leadership. A strong SQL background and familiarity with GCP services are essential.

Qualifications

  • 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 SQL skills, including complex joins, window functions, CTEs, and performance tuning.
  • Working experience with Application Tools such as SAS, Python, Gitlab, etc.
  • Familiar with data governance, predictive analytics, AI and modelling.
  • Familiarity with GCP services (GCS, Dataflow, Composer, Cloud Functions).
  • Familiarity with BI tools such as Power BI, Tableau, MicroStrategy; SAP S4 is an asset.

Responsibilities

  • Partner with Finance stakeholders to analyze and translate BI needs into strategic solutions.
  • Develop reports, dashboards, and analytical models from financial data using Power Platform and Excel.
  • Lead project delivery from inception to completion with scope, estimation, risks, and communication.
  • Facilitate code and data design reviews with team and Loblaw Technology partners.
  • Document team processes, methods, and findings for clear stakeholder understanding.
  • Act as liaison between Finance and Technology for data management, reporting & analytics.
  • Develop and optimize large-scale SQL queries (BigQuery, Teradata) for ETL.
  • Build Python and VBA scripts to automate data transformation and reporting.
  • Perform root cause analysis on data discrepancies and system issues.

Skills

SQL
BigQuery
MS SQL Server
Teradata
Python
SAS
Gitlab
Cloud Platform
Power BI
Tableau
MicroStrategy
SAP S4
Data governance
Predictive analytics
AI
ETL

Education

Finance/Business/Analytics degree

Tools

SAS
Python
Gitlab

Job description

Loblaw Companies Limited is seeking a Senior Business Data Analyst to join the Finance Insights and Technology Engagement team in a hybrid role at Brampton. You will partner with Finance stakeholders, design BI solutions, and lead analytics projects across tools like Google BigQuery, Power BI, and Python.

Responsibilities include developing dashboards, optimizing ETL processes, and presenting updates to senior leadership. A strong SQL background and familiarity with GCP services are essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Loyalty Analytics Specialist — Data-Driven Insights
Loyalty Analytics Specialist — Data-Driven Insights

Loblaw • Brampton

On-site
CAD 80,000 - 110,000
Senior Loyalty Data Analyst & Insights
Senior Loyalty Data Analyst & Insights

myview • Brampton

On-site
CAD 70,000 - 90,000
Senior Business Data Analyst
Senior Business Data Analyst

Loblaw • Brampton

Hybrid
CAD 60,000 - 83,000
Hybrid work policy (4 days in office)
Progressive careers
Comprehensive training
+2
Senior BI Analyst - Power BI, Databricks & Synapse (Hybrid)
Senior BI Analyst - Power BI, Databricks & Synapse (Hybrid)

Canadian Tire Corporation • Oakville

Hybrid
CAD 64,000 - 106,000
Comprehensive benefits
Retirement programs
Performance incentives
+2
Senior Financial Analyst, Retail Store Finance & Insights
Senior Financial Analyst, Retail Store Finance & Insights

Loblaw • Toronto

On-site
CAD 60,000 - 83,000
Retail Analytics Lead: Insights, Dashboards & SQL
Retail Analytics Lead: Insights, Dashboards & SQL

Lululemon Athletica Inc. • Vancouver

On-site
CAD 88,000 - 116,000
Extended health and dental benefits
Mental health plans
Paid time off
+4
Hybrid LBMX & BI Data Analyst (SQL, Qlik)
Hybrid LBMX & BI Data Analyst (SQL, Qlik)

Affiliated Distributors, Inc. • Mississauga

Hybrid
CAD 65,000 - 90,000
Data Science II
Data Science II

myview • Brampton

On-site
CAD 90,000 - 120,000
Data Analyst – Power BI & SQL
Data Analyst – Power BI & SQL

Astra-North Infoteck Inc. • Toronto

On-site
CAD 68,880 - 96,432
Senior Data Engineering & BI Analyst
Senior Data Engineering & BI Analyst

Fidelity International • Toronto, Mississauga

Hybrid
CAD 120,000 - 150,000
Flexible working arrangements - remote
RRSP contribution after 6 months
Comprehensive health benefits