SAS Tech Lead

Job summary

Lead discovery and assessment of SAS assets, workloads, dependencies, and business processes, and define migration approaches for moving SAS workloads to Snowflake. Provide technical leadership throughout conversion, validation, cutover, and hypercare, including reviewing converted code and guiding migration teams.

Job details

Job Title: SAS Tech Lead Location: Markham, ON (3x onsite a week) Employment Type: Contract Pay Rate: CAD$70/HR INC We are seeking an experienced SAS Technical Lead to support a large-scale SAS-to-Snowflake modernization and migration program. The ideal candidate should possess deep expertise in Base SAS, SAS Enterprise Guide, SAS Macros, ETL/Data Processing, and enterprise data warehousing concepts, with the ability to analyze complex SAS estates and guide migration teams through discovery, assessment, conversion, validation, and cutover activities. The candidate will act as the primary SAS SME, helping define migration strategies, assess workloads, identify dependencies, and ensure successful conversion of SAS assets to Snowflake-based solutions. Key Responsibilities Lead discovery and assessment activities for SAS modernization and migration initiatives. Analyze existing SAS landscapes including SAS programs, Enterprise Guide (EGP) projects, macros, datasets, reports, and scheduled jobs. Conduct workshops with business and technical stakeholders to understand business processes, reporting requirements, and application dependencies. Perform complexity assessment and classification of SAS workloads into migration categories such as Migrate, Refactor, Re-engineer, Archive, or Retire. Analyze SAS code, macro frameworks, ETL processes, and data transformations to identify migration approaches and conversion strategies. Support Proof of Concept (PoC) activities by selecting representative SAS workloads and validating migration feasibility. Provide technical leadership, mentoring, and guidance to development and migration teams throughout the program lifecycle. Review converted code, validate business logic, and support production cutover and hypercare activities. Required Skills 8 10 years of hands-on experience in SAS development and data engineering projects. Strong Expertise In Base SAS SAS Enterprise Guide (EGP) PROC SQL DATA Step Programming SAS Macros SAS Dataset Management Experience analyzing and supporting large SAS application landscapes. Strong understanding of Data Warehousing, ETL/ELT, and Data Migration concepts. Experience performing application discovery, dependency analysis, and impact assessment. Strong SQL skills and understanding of relational database concepts. Strong analytical and problem-solving skills with the ability to understand complex business logic embedded within SAS assets. Experience working with large data volumes and complex batch processing workflows. Excellent communication and stakeholder management skills. Disclaimer: AI tools may assist in the recruitment process; however, all hiring decisions are made by the recruitment team based on a comprehensive evaluation of candidates.

What you’ll do

Lead discovery and assessment of SAS assets, workloads, dependencies, and business processes, and define migration approaches for moving SAS workloads to Snowflake. Provide technical leadership throughout conversion, validation, cutover, and hypercare, including reviewing converted code and guiding migration teams.

Requirements

Requires 8–10 years of hands-on SAS development and data engineering experience, with strong expertise in Base SAS, Enterprise Guide, PROC SQL, DATA Step programming, macros, and SAS dataset management. Candidates should also have experience with large SAS application landscapes, data warehousing and ETL/ELT, migration assessment, complex batch processing, SQL, and stakeholder communication.

Listed skills

• SQL · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Base SAS
• SAS Enterprise Guide
• PROC SQL
• DATA Step Programming
• SAS Macros
• SAS Dataset Management
• ETL/ELT
• Data Warehousing
• Data Migration
• Application Discovery
• Dependency Analysis
• Impact Assessment
• SQL
• Data Engineering
• Stakeholder Management
• Snowflake

Job areas

• Technology
• Data & Analytics
• Software
• Management & Leadership
• Consulting

More jobs from Aarorn Technologies Inc