Finance Business Analyst

Axelon Services Corporation

Montreal

On-site

CAD 65,000 - 90,000

Full time

10 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

BNP Paribas in Montreal is seeking a Finance Business Analyst to join the Financial Data Office. You will develop SQL scripts and implement Data Quality Rules for the Finance and Tax systems, ensuring data accuracy and regulatory compliance, with a focus on deployment and documentation.

You will collaborate with finance, IT, and control functions to diagnose data quality issues, translate business needs into technical logic, and contribute to dashboards (Power BI/Tableau) and reporting, in a

Qualifications

  • Bachelor’s degree in computer science, information management, data science, business administration, finance, or a related field.
  • 4-6 years of experience in SQL development, data quality support, and business analysis in financial data environments.
  • Fluent English; French a plus.

Responsibilities

  • Develop, test, and deploy Data Quality Rules (DQR) using SQL.
  • Translate business requirements into technical SQL logic.
  • Monitor data quality dashboards and prepare status reports.
  • Document DQRs, SQL scripts, and business requirements translations.

Skills

SQL development
Data quality
Business analysis
Financial data experience

Education

Bachelor's degree

Tools

Collibra
Power BI
Tableau
Jira
Azure DevOps

Job description

The position at a glance

The Financial Data Office (FDO) Under FCOO Ensures The Integrity, Usability, And Regulatory Compliance Of Financial And Operational Data Across BNP Paribas. It Operates Through Three Key Pillars To Drive Data Excellence

  • DI&C (Data Integrity & Control): Ensures data accuracy, consistency, and adherence to standards.
  • DS&R (Data Stewardship & Remediation): Addresses data quality issues, performs root cause analysis, and oversees end-to-end remediation.
  • DS&I (Data Solutions & Innovation): Develops and implements data-driven solutions to enhance efficiency and innovation.
Title: Finance Business Analyst
Location: Montreal, QC
Duration: 12 Months
The position at a glance

The Financial Data Office (FDO) Under FCOO Ensures The Integrity, Usability, And Regulatory Compliance Of Financial And Operational Data Across BNP Paribas. It Operates Through Three Key Pillars To Drive Data Excellence

  • DI&C (Data Integrity & Control): Ensures data accuracy, consistency, and adherence to standards.
  • DS&R (Data Stewardship & Remediation): Addresses data quality issues, performs root cause analysis, and oversees end-to-end remediation.
  • DS&I (Data Solutions & Innovation): Develops and implements data-driven solutions to enhance efficiency and innovation.

This role falls under DI&C and supports DS&R and DS&I initiatives by focusing on data quality rule creation, SQL development, and business requirement translation for the Deployment of Data Quality Rules (DQRs) across platforms.

Role Overview

The Finance Business & Data Analyst will be a key contributor to the FDO team in Montreal, focusing on the hands-on development of SQL scripts and the implementation of Data Quality Rules (DQRs) for the systems used by the Finance and Tax departments. This role ensures service continuity by assisting in the deployment of rules, maintaining documentation, and translating business requirements into technical logic.

analyst will work closely with finance teams, IT, and control functions to troubleshoot data quality issues, assist in root cause analysis, and implement defined solutions.

Staff Supervision/ Organizational Structure

The Analyst will report to the Head of Data Integrity and Control and will work within a global team environment.

Work conditions: This position provides for standard working conditions in an office and a normal work schedule from Monday to Friday. This position requires little travel.

Key Responsibilities
Data Quality Rule Implementation (DQR)
  • 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.
  • Assist in troubleshooting data quality gaps and supporting the implementation of sustainable solutions.
Data Quality Monitoring & Reporting
  • Support the maintenance of data quality dashboards (e.g., Power BI, Tableau) to track KPIs (e.g., accuracy, completeness, timeliness).
  • Generate regular status reports highlighting data inconsistencies and anomalies for stakeholders.
  • Assist in monitoring alerts for SLA breaches and producing performance reports for management.
Process Support & Documentation
  • Assist in identifying opportunities to automate workflows and enhance data quality processes.
  • Maintain clear and up-to-date documentation for DQRs, SQL scripts, and business requirement translations.
  • Contribute to knowledge sharing to ensure team alignment on data quality standards.
Collaboration & Stakeholder Engagement
  • Work alongside IT, business lines, and control functions to support the integration of DQRs across platforms.
  • Support data integration projects by validating data fitness for reporting.
  • Assist in implementing mitigation plans for identified data-related risks.
The strengths and skills that will help you succeed
Education
  • Bachelor’s degree in computer science, Information Management, Data Science, Business Administration, Finance, or a related field.
Years of Experience
  • 4-6 years of professional experience in:
    • SQL development (writing queries, testing, and rule implementation).
    • Data quality support (assisting in DQR creation and validation).
    • Business analysis (translating requirements into technical logic).
    • Working within financial data environments.
Languages
  • English (mandatory).
  • French (a plus).
Technical Skills
  • SQL: Strong proficiency in query development and data manipulation.
  • Data Quality Tools: Experience with data validation frameworks or metadata management tools (e.g., Collibra) is an asset.
  • Visualization Tools: Familiarity with Power BI or Tableau for dashboarding.
  • Project Management Tools: Experience with Jira or Azure DevOps.
  • Microsoft Office Suite: Proficiency in Excel (for analysis) and Word/PowerPoint (for documentation).
Soft Skills
  • Technical Communication: Ability to translate business needs into technical steps and communicate with both technical and non-technical colleagues.
  • Problem-Solving: Analytical mindset to troubleshoot data discrepancies and identify causes.
  • Collaboration: Ability to work effectively within a global, multi-functional team.
  • Rigour: High attention to detail and a commitment to data accuracy.
  • Adaptability: Ability to manage tasks in a fast-paced, regulatory-driven environment.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Finance Business & Data Analyst
Finance Business & Data Analyst

Infotree Global Solutions • Montreal

On-site
CAD 65,000 - 90,000
Finance Business & Data Analyst
Finance Business & Data Analyst

eTeam • Montreal

On-site
CAD 85,000 - 110,000
Business Data Analyst
Business Data Analyst

HireTalent • Montreal

Hybrid
CAD 85,000 - 110,000
Finance Data Quality Analyst - SQL & DQR Implementation
Finance Data Quality Analyst - SQL & DQR Implementation

Axelon Services Corporation • Montreal

On-site
CAD 65,000 - 90,000
Business Analyst - Level 2
Business Analyst - Level 2

eTeam • Montreal

Hybrid
CAD 55,104 - 61,992
Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033
Data Engineer IV (8+ years of experience) to develop data quality rules and controls using SQL for FCRM 59033

S.I. Systems Ltd. • Toronto

Hybrid
CAD 100,000 - 130,000
Analyst, Data valorization
Analyst, Data valorization

Desjardins • Montreal West

On-site
CAD 80,000 - 110,000
Competitive salary and annual bonus
4 weeks vacation
Defined benefit pension plan
+3
Analyste d'Affaires Finance (Intermédiaire)
Analyste d'Affaires Finance (Intermédiaire)

SII Group • Montreal

On-site
CAD 70,000 - 110,000
Chief Functionnal Analyst MCP Client Domain
Chief Functionnal Analyst MCP Client Domain

National Bank of Canada • Montreal

Hybrid
CAD 90,000 - 130,000
Health and wellness program
Flexible group insurance
Generous pension plan
+6
Data scientist
Data scientist

Desjardins • Montreal

Hybrid
CAD 90,000 - 120,000