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 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.
Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data. Selects, develops and evaluates personnel to ensure the efficient operation of the function.
Primary Responsibilities:

• Implementation: Data Mapping and Transformation
• File Mapping: Complete file mapping based on layouts and requirements provided by Project Managers
• Business Logic: Document business logic for transforming data into product specifications
• Data Quality Checks: Run and interpret quality checks against loaded data to ensure accuracy and completeness
• Data transformation: Author and test ETL to convert data from one format to another. This includes cleaning, filtering, aggregating, enriching, normalizing, and encoding data to make it suitable for analysis, processing or integration
• Troubleshooting and Support:
  • Issue Resolution: Troubleshoot issues raised by project managers and cross matrix teams from root cause identification to resolution
  • Support Requests: Handle support requests and provide timely solutions to ensure client satisfaction
• Collaboration and Communication:
  • Stakeholder Interaction: Work closely with Client, Project Managers, Product managers and other stakeholders to understand requirements and deliver solutions
  • Documentation: Contribute to technical documentation of specifications and processes
  • Communication: Effectively communicate complex concepts, both verbally and in writing, to team members and clients
• Analyzes and investigates
• Provides explanations and interpretations within area of expertise
• 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:

• Education: Bachelor's degree in Computer Science or any engineering field
• Experience: 5+ years of experience working with ETL and Data warehousing services in Cloud
  Environment (AWS/Azure)
• Experience in documentation: Contribute to technical documentation of specifications and processes
• Database Knowledge: Oracle, SQL Server
• Knowledge on ETL Tools: MSBI (SSIS/SSRS/SSAS)
• Knowledge on SQL and Scripting: SQL / Python / Scala
• Knowledge on Cloud : Azure / AWS
• Knowledge on Big Data: Hadoop / Hive/ Apache Spark
• Technical Aptitude: Ability to learn new technologies
• Skills: Proven solid analytical and problem-solving skills

Preferred Qualifications:

• SQL Skills: Ability to query large data sets and optimize queries
• Knowledge on US Health care
• Working knowledge on Health Information Systems
• Knowledge on Clinical Data Analysis
• Clinical Processes: Understanding of clinical processes and vocabulary

Soft Skills:

• Analytical and Creative: Highly analytical, curious, and creative
• Organized: Solid organization skills and attention to detail
• Ownership: Takes ownership of responsibilities

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 #NIC