Associate Software Engineer II, Python, Big Data, Hadoop, PySpark

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:

• Work under supervision of Senior Data Engineers to gather requirements to create Datamodel for Data Science & Business Intelligence projects
• Engage in client communications for all important functions including data understanding/exploration, strategizing solutions etc.
• Document the Metadata information about the data sources used in the project & present that information to team members during team meetings
• Develop Data Marts, De-normalized views & Data Models for projects
• Develop Data Quality control processes around the data sets used for analysis
• Should be able to create/analyze/optimize complex SQL queries
• Lead and Drive Knowledge sharing session within the team
• Work with Senior team members to develop new capabilities for the team
• 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
• 3+ years of experience 
• Good Understanding of Python programming language
• Understanding of – Big Data, Hadoop, PySpark, Distributed or Parallel Processing, Map Reduce
• Good Knowledge of Databricks and Snowflake
• Knowledge or Experience on Cloud Technologies – Azure or AWS or GCP
• Understanding Relational Database Model and Entity Relation diagrams
• Good Knowledge on Relational Databases – SQL Server, Oracle, Teradata
• Knowledge on Orchestration tool – AirFlow, Data Factory, Databricks Workflows or Jobs
• Configuration Management – GitHub
  

Preferred Qualifications: 

• Relevant Databricks Certifications
• Knowledge or experience in messaging Queues – Kafka or ActiveMQ or RabbitMQ
• Knowledge or experience  on CI or CD Tools – GitHub Actions
• Knowledge or experience  in Unix Shell Scripting for automation and scheduling Batch Jobs
• Knowledge or experience using Microsoft Excel, Power Point
• Knowledge on Agile or Scrum

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.