Senior Data Engineering Consultant

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 diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together. 

Primary Responsibilities:

• Design, build and maintain batch or real-time data pipelines
• Develop ETL (extract, transform, load) processes to help extract and manipulate data from multiple sources
• Design and develop complex SQL queries, stored procedures, functions, and views for data retrieval and manipulation
• Build, maintain, and deploy data pipeline for seamless data requirement on cloud platform
• Conduct performance tuning and optimization of SQL and SSIS processes
• Collaborate with SMEs and BSAs to gather requirements and understand data integration needs
• Perform data analysis and develop data models to ensure data integrity and accuracy
• Optimize SQL queries and database performance to achieve maximum efficiency
• Troubleshoot and resolve database and data integration issues
• Monitor and maintain data quality and data governance standards
• Provide technical guidance and mentorship to junior developers
• Stay up to date with the latest industry trends and best practices in SQL development and data integration
• 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:

• Undergraduate degree or equivalent experience
• 13+ years of experience as a Microsoft T-SQL/SSIS Developer or similar role
• Extensive experience with Microsoft SQL Server and SSIS
• Experience with ETL processes, data warehousing, and data migration
• End to End DevSecOps setup and execution experience
• Demonstrable experience on Observability setup and execution
• Solid experience on integration and interoperability
• Solid proficiency in SQL programming, including complex query development, stored procedures, and performance optimization
• Solid proficiency in object-oriented languages: C#, Python, Scala
• Solid understanding of SRE functions and ability to lead teams of Engineers, Architects, SRE and other cloud operations
• Solid understanding of database concepts, data modeling, and data integration
• Good understanding of big data distributed processing tools Databricks, Kafka, Airflow
• Proven good Team player, change/innovation agents and self-starter on different techs
• Proven ready to take up any technical challenges and should be research oriented

Preferred Qualifications:

• Experience Care Management systems
• Experience working in Multi-Payer IT systems
• Experience working on Product engineering end to end lifecycle 

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.