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.
· Solid 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