Senior Data Engineer - Remote

Optum Insight is improving the flow of health data and information to create a more connected system. We remove friction and drive alignment between care providers and payers, and ultimately consumers. Our deep expertise in the industry and innovative technology empower us to help organizations reduce costs while improving risk management, quality and revenue growth. Ready to help us deliver results that improve lives?

Join us to start Caring. Connecting. Growing together.

We are seeking a skilled and motivated Senior ETL / Data Integration Developer to join our team. This role is responsible for designing, developing, and delivering scalable ETL frameworks and components within a multi terabyte Oracle Exadata environment that integrates encounter and enrollment data from New York State (NYS) healthcare plans.

In this role, you will synthesize and integrate large, complex datasets to support the management, evaluation, and analysis of the NYS healthcare system, including the New York All Payer Database (APD). This is a hands on technical role requiring deep expertise in data integration, transformation, data quality, and performance optimization using enterprise ETL and data integration platforms. Exposure to modern or cloud based data platforms is desirable.

You'll enjoy the flexibility to work remotely
* from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

Primary 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

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Required Qualifications:

* 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…