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.

Skills:
Agile Programming Methodologies, Business Administration, Code Reviews, Communication Skills, Computer Science, Consulting, Data Management, Data Mart, Data Modeling, Data Processing, Data Profiling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), English Language, Government, Healthcare, Identify Issues, Information Systems/Technology IS/IT Administration, Knowledge Transfer, Management Consulting, Mathematics, Medicaid, Memory Hardware, Microsoft Windows Azure, Operations Processes, Oracle Database, Performance Tuning/Optimization, Problem Solving Skills, Process Improvement, Production Support, Production Systems, Public Cloud, Quality Assurance, Resource Utilization, Root Cause Analysis, SQL (Structured Query Language), Software Development Lifecycle (SDLC), Statistical Analysis System (SAS), Technical Leadership, Technical Writing, Technical/Engineering Design, Test Plan/Schedule, United States Citizen, Visa Applications

Cleo Consulting