Senior Data Engineer - Remote

Optum is focused on improving health data flow and creating a connected healthcare system. They are seeking a Senior ETL / Data Integration Developer responsible for designing and delivering ETL frameworks to integrate healthcare data from New York State healthcare plans.

Responsibilities:

• Design, develop, and maintain ETL workflows, pipelines, and mappings to load healthcare data into NY APD reporting structures
• Apply ETL development best practices, including parameterization, reusable components, modular design, and avoidance of hard coded logic
• Build reusable frameworks and automation to reduce manual operational activities and improve reliability
• Perform optimization, troubleshooting, and debugging of ETL processes across development, test, and production environments
• Develop and execute unit, system, and integration testing for ETL pipelines
• Tune and optimize ETL jobs for performance, scalability, and throughput; collaborate with data modelers and DBAs on architecture and data model optimization
• Provide development support and conduct code reviews and walkthroughs to ensure adherence to standards and best practices
• Enforce secure coding principles and data protection standards in accordance with State of New York policies
• Document and maintain technical designs, ETL specifications, and operational procedures
• Troubleshoot pre production and production ETL job failures and data quality issues
• Perform data profiling, validation, reconciliation, and balancing checks to ensure data accuracy and completeness
• Design and implement data quality checks and controls across ingestion, transformation, and load phases

Requirements:

• 5+ years of hands on experience designing, developing, and supporting ETL / data integration solutions using any enterprise grade ETL or data integration tool (on prem, hybrid, or cloud)
• 5+ years of experience with Oracle databases and PL/SQL, including solid SQL development and performance tuning skills
• 2+ years of experience with scripting or programming languages (eg, Python, Shell, or similar)
• 2+ years of experience in data analysis, validation, and reconciliation
• 2+ years of healthcare data experience, including Medicaid, Medicare, Exchange, or commercial payer data
• Experience with data modeling techniques for data warehouse and analytical environments
• Proven experience supporting large scale, high volume data processing environments
• Solid understanding of data warehouse architecture, database design principles, and ETL patterns
• Proven excellent problem solving skills, attention to detail, and ability to work independently and collaboratively
• Proven solid communication and documentation skills
• Experience with Informatica ETL suite
• Experience or familiarity with modern or cloud based data platforms and ETL technologies (eg, Snowflake, Databricks, Azure, AWS, or similar)
• Experience working with EDI healthcare transactions, including 834, 837, and NCPDP
• Advanced experience working in large Oracle Exadata or high performance database environments
• Experience implementing data quality frameworks, auditability, and reconciliation controls in regulated data environments
• Experience using AI/LLM models to support data engineering (eg, accelerating SQL/ETL development, automating documentation, enabling data quality anomaly detection, or generating data pipeline templates) in a secure and compliant manner
• Exposure to modern data engineering patterns, such as ELT, scalable batch processing, or hybrid architectures
• Knowledge of HIPAA and healthcare regulatory security requirements