Senior Business Data Analyst

About the role

Responsibilities

• Translate Finance stakeholders' BI needs into strategic solutions and deliver timely, accurate insights.
• Build reports, dashboards, and analytical models using Strategy, Power Platform, and Excel.
• Manage project scope, estimates, risks, progress, and escalations from initiation to completion.
• Facilitate code and data design reviews; document processes, methods, and findings.
• Bridge Finance and Technology needs across data management, reporting, and analytics.
• Develop and optimize SQL for ETL and reporting, including in BigQuery and Teradata.
• Automate data transformation, validation, and reporting with Python and VBA.
• Investigate data and system issues affecting financial integrity and implement corrections.
• Join weekly huddles and present project updates to senior leadership.

Role requirements

• At least 3 years of related experience in a similar role.
• University degree or post-secondary education in Finance, Business, Math/Statistics, Analytics, or a relevant field.
• Working knowledge of Google BigQuery, MS SQL Server, and Teradata; advanced SQL including joins, window functions, CTEs, and tuning.
• Working experience with tools such as SAS, Python, and GitLab.
• Foundational knowledge of data governance, predictive analytics, AI, and modelling.
• GCP services such as GCS, Dataflow, Composer/Airflow, or Cloud Functions are listed as familiarity.
• BI tools such as MicroStrategy, Power BI, or Tableau and financial systems familiarity are listed as desirable.
• SAP S/4 or similar ERP experience is an asset.
• Strong analytical, organization, communication, and teamwork capabilities.

Work arrangement

• Hybrid work policy requires 4 days in the office at 1 President's Choice Circle in Brampton.

Hiring range

• Hiring range is $60,000 to $82,500 per year; candidate experience, knowledge, and geographic region may affect pay.