Data Engineer SAS to Python Migration

Job Title:

Data Engineer (SAS to Python Migration)

Duration:

12 Months

Location:

Toronto (Hybrid 4 Days Work From Office)

Job Summary

We are seeking a Senior Consultant / Data Engineer to lead large-scale data migration from legacy systems to an Enterprise Data Lake for Group Risk Management at Royal Bank of Canada.

The role involves migrating data from SAS and SQL Server environments into a modern scalable data platform. This includes converting SAS programs to Python enabling IFRS9-compliant risk data systems and ensuring high data quality integrity and regulatory compliance.

Key Responsibilities

Data Migration & Transformation

• Lead migration from SAS and SQL Server to Enterprise Data Lake (EDL)
  
• Convert SAS programs into Python-based workflows
  
• Design and implement ETL processes for historical and incremental data loads
  

Validation & Quality Assurance

• Perform Parallel Independent Validation (PIV) with zero critical defects
  
• Conduct parallel testing to ensure alignment between SAS and Python outputs
  
• Ensure data accuracy consistency and completeness across systems
  

Automation & Efficiency

• Build automated workflows and job scheduling in EDL
  
• Reduce manual intervention and improve operational efficiency
  

Data Integration

• Integrate and validate historical datasets with new data pipelines
  
• Ensure seamless continuity between legacy and modern systems
  

Data Governance & Compliance

• Document end-to-end data lineage for all migrated datasets
  
• Maintain centralized version-controlled repositories
  
• Ensure adherence to regulatory and audit requirements
  

Documentation & Knowledge Transfer

• Develop and maintain comprehensive data dictionaries
  
• Conduct training sessions for internal teams
  
• Provide post-migration support and long-term sustainment
  

Audit & Risk Compliance

• Ensure zero critical audit findings
  
• Align with IFRS9 and enterprise risk management standards
  

Required Skills & Experience

Core Technical Skills

• Advanced SAS Python and SQL expertise
  
• Strong experience in SAS to Python migration
  
• Hands-on experience with:
  
  • Enterprise Data Lake (EDL)
    
  • Data migration & ETL processes
    
  • Job scheduling & workflow automation
    

Big Data & Databases

• Hadoop ecosystem: Hive Pig
  
• SQL Server
  
• Data modeling and big data processing
  

Data Engineering & Analytics

• Data profiling cleansing and mining
  
• Statistical analysis techniques
  
• Parallel testing and validation
  

Domain Knowledge

• IFRS9 and credit risk domain experience
  

Other Skills

• Strong documentation and communication skills
  
• Proven track record of on-time delivery
  
• Post-migration support and maintenance experience
  

Nice to Have

• Experience in banking or financial risk systems
  
• Exposure to enterprise-scale data governance frameworks
  

Work Location

• Toronto (Hybrid 4 days onsite)