SAS Code Modernization Specialist

Job Description: We are seeking SAS Code Modernization Specialists to support the migration and transformation of self-service user-coded SAS programs for execution in SAS Viya 4 and integration with Snowflake as the new cloud data layer. The role involves automating code reviews, performing code assessments, and decomposing complex SAS programs into modular components for migration. The ideal candidates must possess deep expertise in SAS programming, handling macros, nested jobs, and shell scripts, with a focus on scalability and performance optimization.

Key Responsibilities:

· Automate SAS code reviews and code assessments to identify dependencies, inefficiencies, and optimization opportunities.

· Decompose complex SAS programs into logical components for input, processing logic, and output.

· Modernize and refactor legacy SAS code for compatibility with SAS Viya 4 and Snowflake.

· Handle advanced SAS constructs, including macros, nested jobs, include statements, and shell script integrations.

· Develop scripts and tools to assess and validate code compatibility for cloud environments.

· Collaborate with DevOps teams to integrate modernized SAS code into CI/CD pipelines.

· Provide recommendations for improving performance, scalability, and security of migrated code.

· Perform data lineage and impact analysis for migration planning and execution.

· Document findings, modernization strategies, and implementation plans.

Qualifications:

· Expert-level SAS programming skills, including Base SAS, Macro, and SQL.

· Experience with SAS Viya 4 programming environments and SAS Studio.

· Strong understanding of Snowflake and explicit pass-through SQL integration.

· Proficiency in analyzing and migrating self-service user-coded programs at scale.

· Hands-on experience with Unix shell scripting and automation frameworks.

· Familiarity with code analysis tools and techniques for identifying optimization opportunities.

· Experience in CI/CD pipeline integration for SAS workloads (e.g., GitLab, Jenkins).

· Knowledge of cloud environments (AWS/Azure) and DevOps methodologies.

Preferred Skills:

· Exposure to SonarQube or equivalent tools for code quality enforcement.

· Experience with workflow orchestration tools like SAS Workflow Orchestrator or Control-M.

· Ability to work with data engineers and DevOps teams for pipeline automation.

· Strong troubleshooting, debugging, and performance optimization skills