SAS Tech Lead
- Markham, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 8 10 years of hands-on experience in SAS development and data engineering projects.
- Posting language
- English
- Posted
Original job description
Role Summary
8 10 years of hands-on experience in SAS development and data engineering projects.
Strong Expertise In
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.
- 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.
- 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.
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
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.
More about this job
Responsibilities
Lead discovery and assessment of SAS application landscapes, analyze code, data, reports, jobs, and dependencies, and define migration strategies for moving SAS workloads to Snowflake. Guide migration teams through proof-of-concept work, conversion reviews, business logic validation, cutover, and hypercare.
Requirements
Requires 8–10 years of hands-on SAS development and data engineering experience, with strong expertise in Base SAS, SAS Enterprise Guide, PROC SQL, DATA Step programming, macros, and dataset management. Candidates should also have experience with large SAS landscapes, data warehousing, ETL/ELT, migration and dependency analysis, complex batch processing, SQL, and stakeholder communication.
Skills
- Base SAS
- SAS Enterprise Guide
- PROC SQL
- DATA Step Programming
- SAS Macros
- SAS Dataset Management
- ETL/ELT
- Data Warehousing
- Data Migration
- SQL
- Application Discovery
- Dependency Analysis
- Impact Assessment
- Workload Complexity Assessment
- Stakeholder Management
- Snowflake
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Management & Leadership
- Consulting
Keywords
- SAS
- Base SAS
- SAS Enterprise Guide
- SAS Macros
- PROC SQL
- DATA Step
- SAS Datasets
- Snowflake
- ETL
- ELT
- Data Engineering
- Data Warehousing
- Data Migration
- SAS Modernization
- Application Discovery
- Dependency Analysis
- Impact Assessment
- Workload Classification
- Code Conversion
- Proof Of Concept
- Business Logic Validation
- Batch Processing
- Relational Databases
- Cutover
- Hypercare
- Stakeholder Management