Finance Business & Data Analyst

TekWissen ®; Montreal; On-site; CAD 57,000 - 81,000; Full time

Job summary

TekWissen LLC in Montreal, QC is seeking a Finance Business & Data Analyst for a 12-month onsite assignment. The role focuses on SQL development and deploying Data Quality Rules across finance platforms, ensuring data accuracy and regulatory compliance.

You will collaborate with finance, IT, and control functions to troubleshoot issues and implement solutions. The incumbent will monitor data quality dashboards (Power BI/Tableau), document processes, and translate business requirements into

Qualifications

• Bachelor’s degree in Computer Science, Information Management, Data Science, Finance, or a related field.
• 4–6 years of professional experience in SQL development, data quality, and business analysis within financial data environments.
• Experience translating business requirements into technical logic and implementing data quality rules.

Responsibilities

• Develop, test, and deploy Data Quality Rules (DQRs) using SQL to ensure data accuracy and completeness.
• Translate business requirements into technical SQL logic for validation and implementation.
• Collaborate with finance teams to address data quality issues and support remediation.
• Maintain documentation for DQRs, SQL scripts, and business translations.
• Generate dashboards and reports to monitor data quality KPIs.

Skills

SQL development

Data quality

Business analysis

Financial data environments

Education

Bachelor’s degree in a related field

Tools

Power BI

Tableau

Collibra

Jira

Azure DevOps

Excel

Job description

Job Title: Finance Business & Data Analyst

Location: Montreal, QC H3A 2A6

Duration: 12 Months

Job Type: Temporary Assignment

Work Type: Onsite

Pay Rate: $ 50.13- $50.13/ Hr

Overview:

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client is a company who is a provider of banking and financial services. The company operates through two divisions, Retail Banking and Services, and Corporate and Institutional Banking.

Job Description:

• The Financial Data Office (FDO) under FCOO ensures the integrity, usability, and regulatory compliance of financial and operational data across Client. 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.

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.

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 (traducing requirements into technical logic).
• Working within financial data environments.

Languages:

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.

TekWissen® Group is an equal opportunity employer supporting workforce diversity.