SAS Consultant

Markham, ON
On-site
Posted Oct 9, 2026
1 position

Opens LinkedIn

Employment type: Full-time
Experience level: Senior · 5+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Lead discovery and assessment of SAS applications, code, data, reports, and scheduled jobs, and determine migration strategies for moving SAS workloads to Snowflake. Guide migration teams, validate converted code and business logic, and support proof-of-concept work, production cutover, and hypercare.

Job details

Role Summary 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 analysing 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.

What you’ll do

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 datasets. Candidates should also have experience with large SAS landscapes, data warehousing, ETL/ELT, migration and dependency analysis, complex batch processing, SQL, and stakeholder communication.