Note: The job is a remote job and is open to candidates in USA. Optum is hiring a Software Engineer within Optum Technology to design and deliver scalable software and ETL solutions that standardize data across healthcare systems. The role builds Python-based ETL pipelines, optimizes Oracle queries, and produces standardized files for downstream applications and health technology solutions.
Responsibilities
- Design, develop, test, deploy, and maintain robust software applications and ETL data integration processes
- Create full ETL format codes utilizing enterprise/proprietary software platforms and Python for data pre-processing and post-processing
- Understand data integration workflows to design, generate, and deliver flat file outputs for enterprise data standardization
- Write, optimize, and maintain complex SQL queries, stored procedures, and data structures within Oracle relational databases
- Troubleshoot, debug, and resolve data pipeline bottlenecks, processing errors, and application performance issues
- Collaborate with cross-functional teams, including product owners, data architects, and quality engineers, to translate complex business and data requirements into technical deliverables
- Maintain thorough technical documentation and adhere to established software engineering best practices, version control, and data governance standards
Skills
- Bachelor's degree OR 4+ years of software development or data engineering experience
- 2+ years of professional experience in software engineering, application development, or ETL pipeline engineering
- 2+ years of experience programming in Python for data processing, scripting, and pre-/post-processing tasks
- 2+ years of hands-on experience writing complex SQL queries and some experience with Oracle databases
- 1+ years of experience building ETL format codes and generating standardized flat file outputs for data integration
- Experience with Git version control and Agile development methodologies
- Bachelor's degree in Computer Science, Computer Engineering, Information Technology, or a related technical field
- Experience utilizing proprietary or enterprise ETL development software tools
- Knowledge of healthcare technology standards and healthcare data structures
Benefits
- Comprehensive benefits package
- Incentive and recognition programs
- Equity stock purchase
- 401k contribution
- Telecommute from anywhere within the U.S.
- Career development opportunities
Company Overview
Company H1B Sponsorship