Role: SAS Programmer with Python
Location: McLean, VA (Onsite)
Summary:
Seeking an experienced SAS/SQL Programmer to build and optimize data pipelines, support analytics, and collaborate with cross-functional teams. The role focuses on ETL development, data quality, and performance tuning, with exposure to modernization using SQL/Python.
Key Responsibilities:
Develop and maintain SAS programs (Base SAS, Macro, PROC SQL) for data processing and reporting
Write optimized SQL (joins, CTEs, window functions) across RDBMS
Build and manage ETL pipelines; schedule and monitor batch jobs
Ensure data quality, validation, and reconciliation
Collaborate with business and technical teams to deliver solutions
Optimize performance (indexing, partitioning)
Support UAT, production releases, and documentation
Contribute to SAS-to-SQL/Python modernization initiatives
Required Skills:
5 7 years of SAS & SQL development experience
Strong in Base SAS, Macros, PROC SQL, and data step processing
Advanced SQL and query optimization skills
ETL, data warehousing, and dimensional modeling knowledge
Experience with RDBMS (Oracle, SQL Server, PostgreSQL, or Snowflake)
Familiarity with Git, SDLC, and job schedulers (Control-M/Autosys)
Strong debugging and communication skills
Nice to Have:
Python (pandas, PySpark), Airflow, REST APIs
Experience converting SAS logic to Python