Senior Data Engineer - Remote
About The Position
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. 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.
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
Nice To Haves
- 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
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
Benefits
- In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).
- No matter where or when you begin a career with us, you’ll find a far-reaching choice of benefits and incentives.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
