Senior Functional Testing Analyst

Job Title: Senior Functional Testing Analyst
Location: Toronto, ON (Hybrid)
Estimated Duration: 12 Months

SUMMARY OF THE ROLE
Work in close partnership with business, data, and technology stakeholders to analyze requirements, validate business processes, test solutions, and ensure data integrity across QRM and supporting platforms.
Responsibilities include:

• Understand and validate business processes, data flows, system integrations, reporting outputs, and end-to-end workflows.
• Develop test scenarios, test cases, validation approaches, and quality assurance artifacts supporting project delivery.
• Perform detailed analysis of business requirements and translate them into functional, integration, data, and end-to-end testing activities.
• Execute data validation, reconciliation, comparison, and investigative testing activities across multiple applications and datasets.
• Support Agile pod-based delivery teams by providing quality assurance ownership from requirements through production readiness.

 
JOB DESCRIPTION

• Collaborate with business and technology teams to understand requirements, business processes, and system functionality.
• Analyze functional and non-functional requirements and develop comprehensive testing strategies and validation approaches.
• Design, develop, and execute functional, integration, system, end-to-end, and regression test scenarios.
• Perform detailed validation of data ingestion, transformation, processing, reporting, and downstream consumption layers.
• Execute data comparisons, reconciliations, and investigative analysis across multiple systems and environments.
• Validate dashboards, reports, business metrics, calculations, and reporting outputs against business expectations.
• Utilize SQL and Databricks to perform testing, troubleshooting, reconciliation, and root cause analysis activities.
• Partner with Business Analysts, Developers, Data Engineers, and Product Owners to clarify requirements and resolve defects.
• Support defect triage, impact assessments, retesting, and release readiness activities.
• Support production readiness activities, including validation of release scope, testing evidence, defect disposition, and business sign-off requirements.
• Maintain testing documentation, test evidence, traceability, and governance artifacts to support audit and compliance requirements.
• Create process flows, test models, data validation approaches, and quality artifacts using Confluence, Visio, and related tools.
• Author and maintain testing assets, user stories, requirements traceability, and quality documentation using Jira and Confluence.
• Participate actively within Agile delivery pods and provide end-to-end quality ownership throughout the delivery lifecycle.
• Utilize AI-enabled tools to improve test analysis, test design, test coverage assessment, data validation, and documentation activities.
• Promote continuous improvement by identifying opportunities to enhance testing processes, quality controls, automation, and delivery effectiveness.

MUST-HAVE SKILLS
Functional Testing & Quality Assurance

• Minimum 7 years of experience in Functional Testing, QA Analysis, Data Testing, or related testing disciplines.
• Proven ability to analyze requirements and translate business rules into test scenarios, test cases, and validation activities.
• Strong understanding of Functional Testing, Integration Testing, System Testing, End-to-End Testing, Regression Testing, and User Acceptance Testing support.
• Experience supporting Agile delivery and working within sprint-based pod teams.
• Ability to interpret process flows, data lineage, source-to-target mappings, reconciliation models, and system interaction diagrams to support testing and validation activities.

Data Analysis & Reconciliation

• Demonstrated deep experience in analyzing and reconciling large datasets to validate business processes, reporting outputs, calculations, and system integrations.
• Strong experience investigating data discrepancies and performing root cause analysis.
• Experience validating financial calculations, allocations, balances, forecasts, rates, and reporting outputs against expected business results.
• Experience executing source-to-target, ingress-to-egress, upstream-to-downstream, and cross-system reconciliation activities.
• Ability to validate control totals, aggregates, balances, calculations, and reporting outputs.

SQL & Databricks

• Strong SQL skills with the ability to independently investigate data issues, validate business rules, perform reconciliations, and support root cause analysis across large and complex datasets.
• Hands-on experience using Databricks SQL or similar analytics platforms for data validation and investigative analysis.
• Experience validating data ingestion, transformations, business rules, and reporting outputs.
• Understanding of data lineage, mappings, and reconciliation methodologies.

Requirements & Traceability

• Proven ability to translate business requirements into testable conditions and maintain end-to-end traceability.
• Experience defining test data requirements and validating test coverage across complex business scenarios, edge cases, and exception conditions.
• Experience leveraging Jira and Confluence to manage testing activities, requirements, defects, and documentation.
• Experience developing and maintaining testing artifacts, traceability matrices, and quality evidence.

Test Governance & Defect Management

• Experience executing and managing defect life cycles including identification, logging, triage, retesting, and closure.
• Ability to support quality gates, release readiness reviews, and testing governance processes.
• Strong understanding of testing standards, controls, and audit-ready documentation.

Stakeholder Management

• Strong communication, facilitation, and stakeholder management skills across business and technology teams.
• Ability to identify gaps, ambiguities, inconsistencies, and testability concerns within business and functional requirements.
• Proven ability to collaborate effectively with Business Analysts, Product Owners, Developers, Data Engineers, and business stakeholders.
• Ability to identify unexpected results, challenge assumptions, and investigate discrepancies through collaboration with business and technology stakeholders.

 
NICE-TO-HAVE

• Experience testing QRM, Treasury, ALM, FTP, IRR, Risk Management, Regulatory Reporting, or other risk management platforms.
• Knowledge of financial products, balance sheet management, and interest rate risk concepts.
• Experience with Databricks notebooks, Python, PowerShell, or comparable scripting technologies.
• Experience validating dashboards and reporting solutions using Tableau and/or Power BI.
• Experience creating source-to-target mappings, reconciliation models, and data lineage documentation.
• Knowledge of data governance, data quality frameworks, and control validation methodologies.
• Experience with cloud-based data platforms and enterprise integration patterns.
• 5+ years of experience working within Agile delivery environments.