SAS Programmer with ETL dev exp (Remote)

DESCRIPTION AND RESPONSIBILITIES

• SAS is seeking a full-time Senior SAS Data Integration and Data Management Consultant to support a state health care organization. The consultant will work on a SAS Enterprise Data Warehouse implementation and will be responsible for developing, maintaining, and supporting ETL processes that integrate health care data into the Enterprise Data Warehouse and associated data marts.
• The consultant will develop new data loads, maintain and enhance existing data integration processes, troubleshoot production issues, optimize SAS and SQL processing, and support data quality and reporting requirements.
• Experience working with health care data, particularly Medicaid or other government health care data, is preferred.

QUALIFICATIONS

• The position requires a Senior SAS programmer with hands-on experience developing, maintaining, troubleshooting, and optimizing production SAS programs and ETL processes.

Required

• Bachelor’s degree in Computer Science, Mathematics, Information Systems, Business Administration, or a related field, or equivalent professional experience.
• Minimum of 5 years of SAS programming and ETL development experience.
• Experience developing SAS programs using Base SAS, DATA step processing, PROC SQL, SQL pass-through, SAS Macro Language, and SAS arrays.
• Experience analyzing and optimizing SAS and SQL code for processing performance, memory utilization, storage utilization, and database workload.
• Experience developing and maintaining ETL processes for enterprise data warehouses and data marts.
• Experience with relational data modeling, data warehouse design, and ETL architecture.
• Experience creating and maintaining source-to-target data mappings and transformation logic.
• Experience performing data profiling, data validation, and data quality checks.
• Experience building, maintaining, executing, and troubleshooting SAS jobs and job flows in SAS Viya.
• Experience supporting both production systems and new development activities.
• Experience reading and analyzing existing SAS code and processing logic to identify and resolve processing and data issues.
• Experience working within Agile and Software Development Life Cycle (SDLC) methodologies.
• Ability to document and communicate technical requirements, designs, issues, and solutions in written and spoken English.

Preferred

• Experience developing SAS and SQL solutions using Oracle databases.
• Experience working with health care data, including commercial or government health care environments.
• Experience working in public cloud environments, with Microsoft Azure preferred.
• Experience reading, writing, and processing Parquet files.

MAJOR RESPONSIBILITIES AND ACTIVITIES

• The consultant will:
• Design, develop, test, implement, and maintain SAS-based ETL processes for the Enterprise Data Warehouse and associated data marts.
• Develop and maintain SAS programs using DATA step processing, PROC SQL, SQL pass-through, SAS Macro Language, arrays, ODS, and SAS reporting and summary procedures, as required by the assigned solution.
• Develop new data loads from client source systems into the Enterprise Data Warehouse.
• Create and maintain source-to-target mappings, transformation rules, and ETL processing logic.
• Design, develop, and enhance data marts.
• Maintain and enhance existing Enterprise Data Warehouse and data mart processing.
• Develop and maintain processes that support tens of millions of records and terabyte-scale data environments.
• Analyze and optimize SAS and SQL processing to improve execution time and resource utilization.
• Monitor SAS jobs and job flows, investigate failures, identify root causes, implement corrections, and validate successful execution.
• Troubleshoot issues involving SAS programs, SQL queries, ETL processes, data transformations, and data quality.
• Provide development, testing, QA, production support, and performance tuning for assigned data warehouse processes.
• Work with client, SAS, and other delivery teams to implement and support changes to the Enterprise Data Warehouse and associated data marts.
• Participate in code reviews, technical design reviews, and knowledge-transfer sessions.
• Create and maintain technical documentation for SAS programs, ETL processes, data mappings, processing logic, and operational procedures.
• Identify technical and process improvements and provide recommendations to project technical leads and management.

“Cleo Consulting is an equal opportunity employer (Minorities/Women/Veterans/Disabled)”