Financial Data Analyst
- Montreal, QC, Canada
Pay Rate Range: $30-49 /hr · Contract
Applications open in a new tab.
Job details
- Pay
- Pay Rate Range: $30-49 /hr
- Job type
- Contract
- Apply by
- Experience
- 4–6 Years Of Professional Experience In
- Posting language
- English
- Posted
Original job description
Job Title :Financial Data Analyst
Location: Montreal Quebec
Duration: 12+ months to long term
T4 Only
Pay Rate Range: $30-49 /hr
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.
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.
Education
Bachelor’s degree in computer science, Information Management, Data Science, Business Administration, Finance, or a related field.
#INDPRO
Location: Montreal Quebec
Duration: 12+ months to long term
T4 Only
Pay Rate Range: $30-49 /hr
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.
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.
Education
Bachelor’s degree in computer science, Information Management, Data Science, Business Administration, Finance, or a related field.
#INDPRO
More about this job
Responsibilities
Develop, test, and deploy SQL-based data quality rules, translate business requirements into technical validation logic, and help resolve data discrepancies in financial and regulatory contexts. Support data quality dashboards, reporting, documentation, process improvements, and collaboration across IT, finance, business, and control teams.
Requirements
The role seeks 4–6 years of professional experience, including SQL development, data quality support, business analysis, and work in financial data environments. A bachelor’s degree in a related field is listed, along with strong SQL skills; familiarity with data quality tools, visualization platforms, project management tools, and Microsoft Office is also relevant.
Skills
- SQL Development
- Data Quality Rules
- Data Validation
- Business Analysis
- Data Quality Monitoring
- Power BI
- Tableau
- Collibra
- Jira
- Azure DevOps
- Microsoft Excel
- Technical Communication
- Problem-Solving
- Stakeholder Collaboration
- Data Documentation
- Financial Data Analysis
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Finance & Accounting
- Technology
Keywords
- SQL
- Data Quality Rules
- Data Quality Reporting
- Data Validation
- Data Accuracy
- Data Completeness
- Data Consistency
- Financial Data
- Business Analysis
- Business Requirements
- Data Quality Dashboards
- Power BI
- Tableau
- Collibra
- Metadata Management
- Jira
- Azure DevOps
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Data Integration
- Regulatory Reporting
- KPI Monitoring
- SLA Monitoring
- Workflow Automation
- Data Documentation
- Risk Mitigation
- Data Anomalies
- Data Quality Standards