ETL Developer SQL, Python, SAS

ETL Developer SQL, Python, SAS

Posted 2 weeks ago by 1755329976

Apply
Negotiable
Outside
Remote
USA
Apply
Amazon Web Services (AWS) Automation Cloud Computing Cloud Technology Data Analysis Data Integration Data Mart Datamodel Data Modeling Data Processing Data Warehousing DevOps Extract Transform Load (ETL) File Servers Generic Programming Git (Version Control System) Information Systems Management Microsoft 365 Microsoft Azure Microsoft SQL Servers Python (Programming Language) SAS (Software) Software Coding Software Development SQL (Programming Language) Stakeholder Management

Summary: The ETL Developer role focuses on modernizing ETL processes for a Medicaid analytical and reporting data mart, involving the conversion of existing ETL processes and the development of new SQL/Python-based solutions. The position requires collaboration with various stakeholders to gather requirements and enhance data integration for improved analytics and reporting. The developer will also prepare for future cloud migrations to AWS and Azure. This role is remote and emphasizes advanced SQL and Python programming skills, particularly in a healthcare context.

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

Key Skills:

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

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

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

Apply
Similar Jobs
Loading data...