Senior SAS Data Integration and Management Consultant

PEOPLE FORCE CONSULTING INC; United States; Remote; USD 96,000 - 165,000; Full time

Job summary

People Force Consulting Inc is seeking a Senior SAS Data Management Consultant to support a state health care client on a remote basis. The role focuses on SAS-based ETL for the Enterprise Data Warehouse and data marts, with extensive SAS programming, SQL optimization, and data integration work.

Responsibilities include building, maintaining, and troubleshooting ETL processes, data mappings, and transformations, while operating within Agile/SDLC and health care data frameworks.

Qualifications

• Bachelor's degree in CS, Math, IS, or related field, or equivalent experience.
• 10+ years of SAS programming and ETL development.
• Strong SAS programming using Base SAS, DATA step, PROC SQL, and macros.
• Experience optimizing SAS and SQL for performance and resource use.
• Experience with ETL for EDW and data marts; data modeling and mappings.
• Strong English communication.

Responsibilities

• Design, develop, test, and maintain SAS ETL for EDW and data marts.
• Develop SAS programs using DATA step, PROC SQL, macros, arrays, and ODS.
• Create and maintain source-to-target data mappings and transformation rules.
• Optimize SAS and SQL to improve speed and resource use.
• Provide production support, QA, and performance tuning for warehouse processes.
• Collaborate with client and delivery teams on changes to the warehouse.

Skills

Senior SAS programming

ETL development

SQL optimization

SAS Viya

Data warehousing

Agile / SDLC

English communication

Education

Bachelor's degree in Computer Science or related field

Tools

SAS Base

DATA step

PROC SQL

SAS Macro

SAS Viya

Oracle DB

Parquet

Job description

Job Title

Senior SAS Data Management Consultant (S&L Client) - Remote

Position

3

Duration

6 months (960 hours).. with strong possibility to get extended long term.

Location

Remote

Visa Requirement No

Due to the nature of the assignment US Citizen, Green Card. Must live in the Continental US.

Client needs a 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 10 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.