Job Description

Data Engineering Analyst - Data Acquisition Team The Role in Brief: The Data Engineering Analyst, leveraging technical and analytical skills, is responsible for supporting Data Acquisition team with ongoing implementations and incremental data. The role requires ownership of the complete analysis and implementation of issues to their final resolution, including creative problem solving and technical decision making. Specific Responsibilities: Implementation: Data Mapping and Transformation: File Mapping: Complete file mapping based on layouts and requirements provided by Project Managers. Business Logic: Write business logic (in SQL or other languages as appropriate) for transforming data into product specifications. Data Quality Checks: Run and interpret quality checks against loaded data to ensure accuracy and completeness. Data extraction / Data Transfer: Ability to extract data from client source system and transfer to internal Optum servers. Troubleshooting and Support: Issue Resolution: Troubleshoot issues raised by project managers 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. Basic Qualifications: o Experience: 2+ years of experience working with ETL Data warehousing services. o Skills: Strong analytical and problem-solving skills. o Education: Bachelor s degree in Computer Science or any engineering field. o Technical Aptitude: Ability to learn new technologies. Required Qualifications: o Database Knowledge: Oracle, SQL Server, MySQL. o ETL Tools: MSBI (SSIS/SSRS/SSAS)/Informatica o SQL and Scripting: Proficiency in SQL and procedural scripting. o Preferred Technology: Azure/AWS, Databricks, Python, Bigdata Documentation: Contribute to technical documentation of specifications and processes. Preferred Qualifications: o SQL Skills: Ability to query large data sets and optimize queries. o US Health care Knowledge: Highly preferred o Health Information Systems: Working knowledge preferred. o Clinical Data Analysis: Highly preferred. o Clinical Processes: Understanding of clinical processes and vocabulary. Soft Skills: o Analytical and Creative: Highly analytical, curious, and creative. o Organized: Strong organization skills and attention to detail. o Ownership: Takes ownership of responsibilities.