Business Data Analyst

Job Title: Finance Business & Data Analyst

Location: Montreal, Qc (Hybrid — Minimum 3 Days Onsite/Week, One of Which Must Be Monday And/or Friday)

Duration: 12 Months

ABOUT THE TEAM

The Financial Data Office ensures the integrity, usability, and regulatory compliance of financial and operational data across the organisation, operating through three pillars: Data Integrity & Control (accuracy and standards), Data Stewardship & Remediation (root-cause analysis and end-to-end remediation), and Data Solutions & Innovation (data-driven solutions). This role sits within Data Integrity & Control, supporting the deployment of Data Quality Rules (DQRs) across platforms.

WHO ARE WE LOOKING FOR

A hands-on analyst who can write SQL, build and deploy data quality rules, and translate business requirements into technical logic within a financial data environment. You will work closely with finance teams, IT, and control functions to troubleshoot data quality issues and implement sustainable solutions.

WHAT WILL YOU WORK ON

• Develop, test, and deploy Data Quality Rules (DQRs) using SQL to ensure data accuracy, completeness, and consistency.

• Translate business requirements into technical SQL logic for validation and implementation.

• Collaborate with finance teams to identify and address data quality issues raised in operational or regulatory contexts.

• Support the maintenance of data quality dashboards (Power BI, Tableau) to track KPIs such as accuracy, completeness, and timeliness.

• Generate regular status reports highlighting data inconsistencies and anomalies for stakeholders.

• Monitor alerts for SLA breaches and produce performance reports for management.

• Identify opportunities to automate workflows and enhance data quality processes.

• Maintain clear, up-to-date documentation for DQRs, SQL scripts, and business requirement translations.

WHO WILL YOU WORK WITH

You will report to the Head of Data Integrity and Control and work within a global team environment, alongside IT, business lines, and control functions. Standard office working conditions, Monday to Friday, with little travel.

MUST-HAVE

• 4–6 years of professional experience in SQL development (writing queries, testing, and rule implementation), data quality support (DQR creation and validation), business analysis (translating requirements into technical logic), and working within financial data environments.

• Bachelor's degree in Computer Science, Information Management, Data Science, Business Administration, Finance, or a related field.

• Strong SQL proficiency in query development and data manipulation.

• Familiarity with Power BI or Tableau for dashboarding.

• Experience with Jira or Azure DevOps.

• Proficiency in Excel for analysis and Word/PowerPoint for documentation.

• English (mandatory).

• Strong technical communication, problem-solving/root-cause mindset, collaboration, rigour, and adaptability in a regulatory-driven environment.

NICE-TO-HAVE

• French.

• Experience with data validation frameworks or metadata management tools (e.g., Collibra).