SAS Developer (Fully Remote)

Techead; United States; À distance; USD 110 000 - 150 000; Plein temps

Résumé du poste

Techead is seeking an experienced SAS Developer to design, develop, and optimize complex data pipelines and analytics workloads. The role bridges traditional SAS analytics with modern cloud architectures on AWS, including PostgreSQL and Oracle PL/SQL.

You will work with EST teams remotely, and be required to travel to Washington, DC to pick up a security badge from the government customer. Responsibilities include building SAS pipelines, tuning performance, and collaborating with data scientists

Qualifications

• 4+ years of SAS development and relational DB engineering.
• Strong knowledge of Base SAS, SAS Macros, PROC SQL, and data transformation.
• Experience with PostgreSQL and Oracle PL/SQL.

Responsabilités

• Design, develop, optimize, and maintain SAS data pipelines and ETL workflows.
• Migrate legacy SAS workflows to modern cloud architectures on AWS.
• Collaborate with data scientists, BI engineers, and stakeholders to deliver analytics solutions.
• Maintain design docs, data lineage, and version control with Git.

Connaissances

SAS development

Base SAS

SAS Macros

PROC SQL

PostgreSQL

PL/SQL

AWS

ETL pipelines

Git

SAS Enterprise Guide

Formation

Bachelor’s degree in Computer Science / Information Systems / Statistics / Data Analytics

Outils

Git

SAS Enterprise Guide

pg_cron

AWS services

Description du poste

This position is fully remote / work from home working with EST teams.

Must be willing to travel to Washington, DC, to pick up security badge from government customer.

We are seeking an experienced SAS Developer with a strong relational database and cloud engineering background to join our analytics and data engineering team. In this role, you will design, develop, optimize, and maintain complex data pipelines, ETL workflows, and analytical data marts. The ideal candidate bridges traditional data analytics (SAS, Base SAS, SAS Macros) with modern database architecture (PostgreSQL, Oracle PL/SQL) and cloud data pipelines (AWS). You will be instrumental in migrating legacy SAS workflows, optimizing complex stored procedures, and deploying scalable analytics solutions in the cloud.

Key Responsibilities

• SAS Pipeline Engineering: Design, code, test, and maintain robust SAS applications using Base SAS, SAS Macros, PROC SQL, and SAS Enterprise Guide.
• Write, debug, and optimize complex SQL queries, stored procedures, functions, triggers, and views in both PostgreSQL and Oracle PL/SQL.
• Leverage AWS services (e.g., S3, RDS/Aurora PostgreSQL, Glue, Lambda, EC2, Athena) to ingest, process, and store analytical datasets, supporting initiatives to modernize on-premise SAS workloads into cloud architectures.
• Build and maintain scalable data pipelines integrating diverse data sources into normalized databases and reporting schemas.
• Performance Tuning: Troubleshoot performance bottlenecks across SAS sessions, database indexes, execution plans, and AWS-hosted databases to ensure optimal throughput.
• Implement automated data validation checks, error-handling routines, and audit logging across data extraction and transformation steps.
• Partner with data scientists, BI engineers, and business stakeholders to translate analytical specifications into reliable production pipelines.
• Maintain technical design documents, data lineage mappings, and code repositories using Git/version control best practices.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Statistics, Data Analytics, or a related quantitative field (or equivalent practical experience).
• 4+ years of professional experience in SAS development and relational database engineering.
• Advanced experience with Base SAS, SAS Macro Facility, PROC SQL, and data transformation procedures (PROC TRANSPOSE, SUMMARY/MEANS, SORT).
• Hands-on proficiency with PostgreSQL (schema design, indexing strategies, query planning, pg_cron, or PL/pgSQL).
• Strong working knowledge of PL/SQL (packages, procedures, functions, cursor management, and performance tuning).
• Practical experience interacting with AWS data ecosystems (Amazon RDS/Aurora PostgreSQL, S3, IAM, CloudWatch; familiarity with AWS Glue, Lambda, or Redshift is a major plus).
• Proven track record designing dimensional and relational models, pipeline orchestration, and handling large data volumes.