Key Responsibilities: · Automate SAS code reviews and code assessments to identify dependencies, inefficiencies, and optimization prospects. · 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.
· Robust 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. · Robust troubleshooting, debugging, and performance optimization skills