Business Data Analyst

Job summary

Develop, test, and deploy SQL-based data quality rules, translating business requirements into technical validation logic and resolving data issues with finance, IT, and control teams. Maintain data quality dashboards and documentation, report anomalies and SLA performance, and identify opportunities to automate and improve data quality processes.

Job details

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).

What you’ll do

Develop, test, and deploy SQL-based data quality rules, translating business requirements into technical validation logic and resolving data issues with finance, IT, and control teams. Maintain data quality dashboards and documentation, report anomalies and SLA performance, and identify opportunities to automate and improve data quality processes.

Requirements

Requires 4–6 years of experience in SQL development, data quality support, business analysis, and financial data environments, plus a bachelor's degree in a relevant field. Candidates must have strong SQL skills, familiarity with Power BI or Tableau, Jira or Azure DevOps, and office productivity tools; English is mandatory, while French and experience with validation frameworks or metadata tools are preferred.

Listed skills

• Data Validation · Preferred
• Business analysis · Preferred
• Power BI · Preferred
• Tableau · Preferred
• Jira · Preferred
• Microsoft Excel · Preferred
• Root Cause Analysis · Preferred
• Workflow Automation · Preferred
• Documentation · Preferred
• Regulatory Compliance · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL Development
• Data Quality Rules
• Data Validation
• Business Analysis
• Financial Data
• Power BI
• Tableau
• Jira
• Azure DevOps
• Excel
• Root-Cause Analysis
• Data Quality Dashboards
• Workflow Automation
• Technical Communication
• Documentation
• Regulatory Compliance

Job areas

• Data & Analytics
• Finance & Accounting
• Technology

More jobs from HireTalent