Associate Data Engineer – SQL

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:

• Implementation
  • Completing file mapping based on layouts and requirements provided by Business Analysts/Project Managers; Writing business logic (in SQL or other languages as appropriate to the particular business intelligence technology) for transforming data into product specifications; running and interpreting quality checks against loaded data; spinning up the product front-end; completing quality testing and articulating potential issues back to the BA/PM
• Production:
  • End-to-end management of the ongoing data load process, including monitoring of feeds and outreach when data is delayed; creating customized reports based on specifications provided by Business Analysts; Completing configuration, mapping, or logic changes as described and prioritized by BAs; Troubleshooting issues raised by BAs from root cause identification to resolution
• In all phases of the client life cycle, the Data Analyst is responsible for writing complex SQL queries to complete business requirements. He/she must have the ability to analyze and understand data to support decision making. He/she is also responsible for working on projects focused on continuous improvement to improve team’s effectiveness
• 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:

• Bachelor’s degree in Computer Science or any engineering
• 1+ years of experience working with ETL & Data warehousing services
• Experience with or an interest in learning to work with complex health care databases
• Solid analytical and problem solving skills
• Passion to work with lot of data in a challenging environment
• Technical aptitude for learning new technologies
• Intermediate to expert knowledge on AWS, Scala, Spark SQL, Python(good to have)
• Knowledge on Relational Databases like Oracle, SQL Server, MYSQL
• Knowledge on SQL and procedural scripting
• Ability to contribute to technical documentation of specifications and processes
• Ability to participate in the ongoing invention, testing and use of tools used by the team to improve processes and bring scale
• Intermediate skills using Microsoft Excel and Microsoft word
• Proven highly analytical, curious and creative
• Solid organization skills, very detail oriented, with careful attention to work processes
• Ability to take ownership of responsibilities and follows through hand-offs to other groups
• Competence with PCs and Windows Office applications
• Ability to enjoy a fast paced environment and the opportunity to quickly learn new skills
• Ability to work creatively and flexibly, both independently and as part of a team
• Proven good written and oral communications skills
• Ability to analyze user requests, define requirements, investigate and report conclusions

Preferred Qualifications:

• Ability to query large data sets using SQL and query optimization skills.
• Working knowledge of health information systems
• Clinical or medical data analysis highly preferred
• Understanding of clinical processes and vocabulary

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.

#njp