Finance Business & Data Analyst
Location: Montreal, QC (Hybrid)
Duration: 12 Months
Department: Finance COO (FCOO) - Financial Data Office (FDO)
Job Summary
We are seeking a Finance Business & Data Analyst to join the Financial Data Office (FDO) team. The ideal candidate will have strong expertise in SQL development, data quality management, and business analysis within financial services environments. This role will focus on implementing and maintaining Data Quality Rules (DQRs), translating business requirements into technical solutions, analyzing financial data, and supporting data governance initiatives across Finance & Tax functions.
Key Responsibilities
Data Quality & SQL Development
- Develop, test, and deploy Data Quality Rules (DQRs) using SQL.
- Translate business requirements into technical SQL logic and validation rules.
- Perform data analysis to identify data quality issues, inconsistencies, and anomalies.
- Support root cause analysis and remediation of data quality gaps.
- Validate and monitor data accuracy, completeness, and consistency across financial systems.
Business Analysis & Stakeholder Management
- Gather, analyze, and document business requirements from Finance, Tax, and operational teams.
- Act as a liaison between business stakeholders and technical teams.
- Support regulatory and operational data quality initiatives.
- Collaborate with IT, Finance, and Risk teams to implement data solutions.
Reporting & Data Monitoring
- Develop and maintain data quality dashboards using Power BI or Tableau.
- Generate KPI and performance reports for management and stakeholders.
- Monitor data quality metrics and SLA compliance.
- Provide actionable insights to enhance reporting accuracy and efficiency.
Documentation & Process Improvement
- Maintain technical documentation for DQRs, SQL scripts, and business requirements.
- Identify opportunities for process automation and operational efficiency.
- Support data governance and data management best practices.
- Contribute to knowledge-sharing initiatives across global teams.
Required Qualifications
Education
- Bachelor's degree in Computer Science, Data Science, Information Management, Finance, Business Administration, or a related field.
Experience
- 4-6 years of experience in:
- SQL development and data manipulation.
- Data quality management and validation.
- Business analysis and requirement gathering.
- Financial data environments within banking or financial services.
Technical Skills
- Strong SQL querying, scripting, and data analysis skills.
- Experience creating and implementing Data Quality Rules (DQRs).
- Knowledge of data governance and data quality frameworks.
- Experience with Power BI or Tableau.
- Familiarity with Jira, Azure DevOps, or similar project management tools.
- Advanced Microsoft Excel and working knowledge of Word and PowerPoint.
- Experience with Collibra or similar data governance tools is a plus.
Preferred Skills
- Understanding of financial reporting, finance operations, or regulatory reporting.
- Knowledge of metadata management and data lineage concepts.
- Banking or capital markets experience preferred.
Soft Skills
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management abilities.
- Ability to translate business requirements into technical solutions.
- Strong attention to detail and commitment to data accuracy.
- Ability to work in a fast-paced, global environment.
- Collaborative team player with strong organizational skills.
Nice to Have
- French language proficiency.
- Experience in data governance, risk, or regulatory reporting environments.
- Exposure to large-scale financial data transformation initiatives.
