Hireblazer
Hire the best of the best technology Staff

Jobs

SAS PROGRAMMER (REMOTE)

Apply Now

Contract: 6+ Months

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

  • 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.

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 Skills:

  • 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.


Kavitha K