Senior Data Engineering Analyst

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.  

About UHG

United Health Group is a leading health care company serving more than 85 million people worldwide. The organization is ranked 5th among Fortune 500 companies. UHG serves its customers through two different platforms – United Health Care (UHC) and Optum. UHC is responsible for providing healthcare coverage and benefits services, while Optum provides information and technology enabled health services.

India operations of UHG are aligned to Optum. The Optum Global Analytics Team, part of Optum, is involved in developing broad-based and targeted analytics solutions across different verticals for all lines of business.

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:

• Bachelors or 4 year university degree
• 5+ years of experience 
• Experience in developing ETL jobs using Snowflake, ADF , Databricks 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, Databricks
• Good experience in building data pipelines using ADF
• Knowledge of Agile methodologies, roles, responsibilities and deliverables
• Proficiency in Python for data processing and automation
• Demonstrated ability to learn and adapt to new data technologies

Preferred Qualifications: 

• Certified in Azure Data Engineering (AZ-205)
• Extensive experience with Azure cloud services (Azure Data Factory, Azure Databricks, Azure SQL Database, etc.)
• Solid understanding of CI/CD principles and tools (e.g., Jenkins, GitLab CI/CD)
• Knowledge of SQL and NoSQL databases
• Proficiency in Python for data processing and automation
• Proven excellent time management, communication, decision making, and presentation skills
• Proven good problem-solving skills
• Proven good communication skills

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.