Data Developer (ADF)

About This Role

This role involves developing and maintaining ETL pipelines and workflows for the Arkansas Medicaid Decision Support System, optimizing data processes, and creating automated data shares for intrastate agencies. This position directly impacts health outcomes by connecting people with necessary resources.

Responsibilities

• Supports the Arkansas Medicaid Decision Support System (DSS) by developing and maintaining ETL pipelines and workflows
• Identifying and resolving data quality issues
• Optimizing processes to improve performance
• Supports intrastate agencies by creating and monitoring automated data shares and file extracts
• Working directly with state partners to create new extracts based on business specifications

Requirements

• 5+ years of Extract Transform and Load (ETL) Developer experience preferably in a data warehouse project environment
• 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements
• 3+ years working with SDLC processes
• 2+ years of experience creating pipelines in Azure Data Factory (ADF)
• 2+ years of batch or Powershell/Python scripting
• 2+ years of experience processing common complex file formats (ex: JSON, XML), as well as simpler formats (ex: fixed-width, delimited, etc.)
• 1+ years of Federal Reporting experience (Medicaid or similar programs)

Qualifications

• 5+ years of Extract Transform and Load (ETL) Developer experience preferably in a data warehouse project environment

Nice to Have

• 3+ years of data modeling experience in a data warehouse environment
• 2+ years of experience with GitHub, SVN, or similar source control systems
• Experience with HL7 and FHIR standards, and processing files in these formats
• Extract, Transform and Load (ETL) experience in a cloud environment
• Experience with Medicaid, Healthcare data or MMIS systems
• Proven solid SQL programming skills and performance tuning
• Demonstrated leadership skills and ability to manage smaller projects independently

Skills

* Required skills

Benefits