Data Validation Test Engineer - SQL, Python, SAS

Job Title: Data Validation Test Engineer - SQL, Python, SAS Location: Toronto, ON

Work Style: Hybrid (4 days WFO)

Duration: 12 Months

Job Summary RBC is seeking a Senior Automation QA Analyst with strong expertise in SAS and Python to support a critical legacy SAS-to-Python migration program . The role focuses on validating data integrity, business logic transformation, and functional correctness during system modernization.

This role combines automation testing, data validation, and business rule verification across financial systems.

Primary Skills SAS (Base, EG, Macros) | Python (Pandas, NumPy) | SQL | Automation Testing | Data Migration Testing | PyTest | Selenium | Robot Framework | Financial Services QA

Key Responsibilities

• Test Strategy & Automation Design
• Design and implement automated test frameworks for SAS-to-Python migration validation
• Ensure Python solutions align with SAS baseline logic and outputs
• Develop test strategies for data-heavy transformation projects
• Business Logic Validation
• Extract and analyze complex business rules from SAS code (macros, procedures, scripts)
• Validate accurate replication of logic in Python implementations
• Ensure functional parity between legacy and modern systems
• Data Integrity & Reconciliation
• Perform SQL-based data validation and reconciliation across SAS and Python datasets
• Identify data mismatches, transformation issues, and defects
• Ensure accuracy of financial and regulatory reporting data
• Stakeholder Collaboration
• Work closely with developers, BAs, and business users
• Define acceptance criteria and support UAT sign-off
• Translate technical validation results into business-friendly insights
• QA Process & Documentation
• Create detailed test plans, test cases, and defect reports
• Maintain documentation for migration validation and knowledge transfer
• CI/CD & Quality Improvement
• Advocate for automation best practices in CI/CD pipelines

Required Skills & Experience

• 5+ years in QA / Automation roles
• At least 1+ year experience in SAS-to-Python migration or data transformation projects
• Strong experience in SAS (Base, EG, Macros)
• Strong proficiency in Python (Pandas, NumPy, automation libraries)
• Advanced SQL skills for data validation and reconciliation
• Experience in financial services (risk, regulatory reporting preferred)
• Automation tools: PyTest, Selenium, Robot Framework
• Strong communication and stakeholder management skills
• Experience in UAT, defect lifecycle, and test documentation

Preferred Skills

• Agile / Scrum experience
• CI/CD tools (Jenkins, Azure DevOps, GitLab CI)
• SAS / Python / QA certifications (ISTQB preferred)
• Experience in large-scale data migration or modernization programs