Business Data Analyst

HireTalent; Montreal; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

HireTalent is seeking a Finance Business & Data Analyst in Montreal on a hybrid setup (minimum 3 days onsite per week, with Monday and/or Friday onsite required). The 12-month contract focuses on building data quality rules, translating business needs into SQL logic, and partnering with finance and IT to improve data integrity across regulatory contexts.

You will develop DQRs, support dashboards in Power BI/Tableau, and generate stakeholder reports while maintaining thorough documentation and

Qualifications

• 4–6 years of SQL development, data quality support, and business analysis in financial data environments.
• Bachelor's degree in CS, Information Management, Data Science, Finance, or related field.
• Strong SQL proficiency for query development and data manipulation.
• Experience with Power BI or Tableau for dashboards.
• Experience with Jira or Azure DevOps.
• Proficiency in Excel for analysis and Word/PowerPoint for documentation.

Responsibilities

• Develop, test, and deploy Data Quality Rules (DQRs) using SQL to ensure data accuracy and consistency.
• Translate business requirements into technical SQL logic for validation and implementation.
• Collaborate with finance teams to identify and address data quality issues in operational or regulatory contexts.
• Maintain data quality dashboards (Power BI, Tableau) to track KPIs such as accuracy and timeliness.
• Generate regular status reports highlighting data inconsistencies for stakeholders.
• Monitor alerts for SLA breaches and produce performance reports for management.
• Identify opportunities to automate workflows and enhance data quality processes.
• Maintain up-to-date documentation for DQRs, SQL scripts, and requirements translations.

Skills

SQL development

Data quality

Business analysis

Technical communication

Regulatory/data governance

Education

Bachelor's in CS

Information Management

Data Science

Finance background

Business Administration

Tools

Power BI

Tableau

Jira

Azure DevOps

Excel

Word/PowerPoint

Job description

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.
• Strong technical communication, problem-solving/root-cause mindset, collaboration, rigour, and adaptability in a regulatory-driven environment.

NICE-TO-HAVE

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