SAS Developer

EXL•United States,

14h

About The Position

We are seeking a skilled SAS Developer to join our team. The role involves developing, maintaining, and enhancing SAS programs, macros, and scripts, as well as performing data extraction, transformation, and loading (ETL) activities. You will analyze large datasets, generate reports for business insights, and design/optimize SAS data models and workflows. A key part of this role will be validating and troubleshooting SAS jobs and production issues, collaborating with cross-functional teams to gather business requirements, and creating automated reports and dashboards. Ensuring data accuracy, integrity, and compliance with company standards is crucial. You will also participate in code reviews, documentation, and support the deployment and maintenance of SAS applications. A significant focus will be on migrating SAS workloads, ETL jobs, and batch processes from SAS GRID to SAS Viya, which includes analyzing existing SAS GRID environments, converting and validating SAS programs for SAS Viya compatibility, and ensuring migrated jobs execute efficiently. You will also identify compatibility issues and recommend remediation approaches. In terms of Quality Assurance & Validation, you will perform code validation and reconciliation, conduct various testing phases, troubleshoot migration and ETL-related issues, and ensure data quality throughout the migration process. Stakeholder and client engagement will involve collaborating with various teams, providing progress updates, and supporting technical discussions.

Requirements

Proficiency in SAS programming, including macros and scripts.
Experience with ETL processes.
Ability to analyze large datasets and generate reports.
Experience in designing and optimizing SAS data models and workflows.
Skills in validating and troubleshooting SAS jobs and production issues.
Experience with SAS GRID.
Experience with SAS Viya.
Ability to convert and validate SAS programs for SAS Viya compatibility.
Experience with SAS Enterprise Guide projects, batch scripts, and shared libraries.
Knowledge of code validation and reconciliation.
Experience with unit testing, system testing, and parallel run validations.
Strong collaboration and communication skills.

Nice To Haves

Experience in migrating SAS workloads from SAS GRID to SAS Viya.
Familiarity with identifying compatibility issues and recommending remediation approaches.

Responsibilities

Develop, maintain, and enhance SAS programs, macros, and scripts.
Perform data extraction, transformation, and loading (ETL) activities.
Analyze large datasets and generate reports for business insights.
Design and optimize SAS data models and workflows.
Validate and troubleshoot SAS jobs and production issues.
Collaborate with cross-functional teams to gather business requirements.
Create automated reports and dashboards.
Ensure data accuracy, integrity, and compliance with company standards.
Participate in code reviews and documentation activities.
Support deployment and maintenance of SAS applications.
Participate in migration of SAS workloads, ETL jobs, and batch processes from SAS GRID to SAS Viya.
Analyze existing SAS GRID environments, ETL workflows, scheduling dependencies, and data pipelines.
Convert and validate SAS programs, macros, and ETL processes for SAS Viya compatibility.
Support migration of SAS Enterprise Guide projects, batch scripts, and shared libraries.
Ensure migrated jobs execute efficiently within the SAS Viya compute environment.
Identify compatibility issues and recommend remediation approaches.
Perform code validation and reconciliation between SAS GRID and SAS Viya outputs.
Conduct unit testing, system testing, and parallel run validations.
Troubleshoot migration and ETL-related issues.
Ensure data quality, accuracy, and process integrity throughout migration activities.
Collaborate with business users, data teams, infrastructure teams, and architects.
Provide regular updates on migration progress and issue resolution.
Support client discussions and technical walkthroughs as needed.