Lead Data Engineer - Data Lake Migration (SAS to Python)

Job Title: Lead Data Engineer - Data Lake Migration (SAS to Python)

Key Skills: IFRS9 Data 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 workflo...