ETL Developer SQL, Python, SAS

Overview

Remote
$60 - $66
Contract - W2
Contract - 8 Month(s)

Skills

Legacy SAS
SQL Programming
ETL
Python
GIT
Microsoft Office

Job Details

Job Title: ETL Developer SQL, Python, SAS Duration: 8 Months
Location: Salem, OR Remote
Key Skills: Legacy SAS, SQL Programming, ETL, Python, Advanced Data Analysis, DevOps, GIT, Microsoft Office
We are seeking a ETL Developer to modernize ETL processes for a Medicaid analytical and reporting data mart. The work includes converting existing ETL processes, developing new SQL/Python-based solutions, and preparing for future cloud migrations (AWS Azure).
The data mart supports Medicaid analytics and reporting, integrating claims and enrollment data from the state s Medicaid management and information system. Analysts also access data through a Medicaid data warehouse and decision support environment, which stores raw transactional data. The data mart enhances this information with analytical groupings for easier reporting and analysis.
Primary Responsibilities:

  • Analyze existing data mart systems, including data models, schemas, ETLs, and reporting environment.
  • Collaborate with project teams, management, and end users to gather business/technical requirements.
  • Document system, data, and integration requirements for improvements.
  • Design, develop, and implement new ETL code/packages.
  • Migrate ETL processes from SAS to SQL/Python stored procedures, ensuring modular design.
  • Review, update, and test new SQL-based ETL processes in development and production environments.

Required Skills & Experience:

  1. Advanced SQL Development 7 10+ years in SQL programming and Microsoft SQL Server, including stored procedures and complex ETL logic.
  2. ETL Process Modernization Migration from legacy SAS to SQL/Python, modular code design, and performance optimization.
  3. Python Programming 7 10+ years of experience for data processing, automation, and integration.
  4. Healthcare/Medicaid Data Expertise Understanding of claims, enrollment, eligibility, and national coding standards.
  5. Data Warehousing Experience designing and maintaining analytical data environments and reporting data marts.
  6. Version Control & DevOps Tools Proficiency with Microsoft DevOps, GIT, or similar tools for code management.
  7. Collaboration & Communication Ability to work with business teams, data owners, and technical staff in a government/public health setting.


Email your resume to:
To learn more about Mavensoft visit us online at

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.