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 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:

• In this role, the resource will “own” data source implementation and improvement projects from the data analytics perspective, including: 
• Conduct gap analysis to compare the client’s data structure and content to that of the standard expected for that EMR, billing, or adjudicated claims data source
• Look through the client’s data to locate data elements of interest to our application. Complex cases involve reconciliation of data in multiple locations, clever ways of imputing information from sub-par data, and de-duplication strategies
• Map client local terminologies to Optum Analytics standard concepts
• Work closely with clinical informatics specialists in domains such as lab and medication data
• Write specifications for ETL engineers regarding how to transform the data
• Work closely with engineering and operations teams as the project is implemented, to answer questions and resolve data issues that arise
• Be responsible for monthly review of client data and dictionary updates and implementing appropriate revisions to Optum Analytics mapping tables
• Contribute to technical documentation of specifications and processes
• Participate in the ongoing invention, testing and use of tools used by the team to improve processes and bring scale
• 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, or work equivalent, in health sciences, health information systems, computer science, mathematics, engineering or related field
• 2+ years of experience working with data, analyzing data and understanding data
• 2+ years of experience working with SQL (SQL Server or Oracle)
• 2+ years of experience working with Scripting (PowerShell, Batch scripting or Python)
• Best to know Cloud (AWS or Azure)
• Understanding of relational data bases and their principles of operation
• Intermediate skills using Microsoft Excel
• Proven good communication skill for client facing calls or emails

Preferred Qualification:

• Knowing UNIX, any ETL tool

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.