Data Engineer – ETL, Snowflake, ADF, Databricks

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.  

Job Summary: We are seeking a skilled Data Engineer with a minimum of 2 years of experience in Oracle, Snowflake, Azure Data Factory (ADF), and Databricks. The ideal candidate will be responsible for designing, developing, and maintaining scalable data pipelines and architectures to support our data analytics and business intelligence needs.

Primary Responsibilities:

• Gather, analyze and document business requirements. At the same time leveraging knowledge of claims, clinical and other healthcare systems
• ETL jobs Development using Talend, Python, Cloud Based Data-Warehouse, Jenkins, Kafka and an orchestration tool
• Writing advanced SQL queries
• Create and interpret functional and technical specifications and design documents
• Understand the business and how various data elements and subject areas are utilized in order to develop and deliver the reports to business
• Be an SME either on Claims, member or provider module
• Provide regular status updates to higher management
• Design, develop, and implement scalable and high-performing data models and solutions using Snowflake and Oracle
• Manage and optimize data replication and ingestion processes using Oracle and Snowflake
• Develop and maintain ETL pipelines using Azure Data Factory (ADF) and Databricks
• Optimize query performance and reduce latency by leveraging pre-aggregated tables and efficient data processing techniques
• Collaborate with cross-functional teams to understand data requirements and deliver high-quality data solutions
• Implement data security measures and ensure compliance with industry standards
• Automate data governance and security controls to maintain data integrity and compliance
• Develop and maintain comprehensive documentation for data architecture, data flows, ETL processes, and configurations
• Continuously optimize the performance of data pipelines and queries to improve efficiency and reduce costs
• Basic, structured, standard approach to work
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Fulltime graduate degree in relevant field
• Experience in developing ETL jobs using SNOWFLAKE , ADF , Data BRICKS and Python
• Experience in writing efficient and advanced SQL queries
• Experience in both producing and consuming data utilizing Kafka
• Experience working on large scale cloud-based data warehouse- Snowflake,
• Experience in workflow scheduling tool using Apache Airflow or similar
• Experience in CI CD using GIT
• Knowledge of Agile methodologies, roles, responsibilities and deliverables
• Understanding about clinical applications

Preferred Qualification: 

• Experience in US Healthcare domain

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes — an enterprise priority reflected in our mission.