Senior Automation QA Analyst SAS to Python Migration

Job Title: Senior Automation QA Analyst -SAS to Python Migration

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

1. 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
  

2. 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
  

3. 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
  

4. 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
  

5. QA Process & Documentation

• Create detailed test plans test cases and defect reports
  
• Maintain documentation for migration validation and knowledge transfer
  

6. 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