Data Analyst

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 Extraction / Transfer

Extract data from client source systems and transfer it to internal Optum servers.

Data Transformation

Author and test ETL processes to convert data formats. This includes cleaning, filtering, aggregating, enriching, normalizing, and encoding data for analysis, processing, or integration.

Troubleshooting and Support

Issue Resolution: Troubleshoot issues raised by Project Managers and cross-functional teams, from root cause identification to resolution.
Support Requests: Handle support requests and deliver timely solutions to ensure client satisfaction.

Collaboration and Communication

Stakeholder Interaction: Collaborate closely with Clients, 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 conceptsboth verbally and in writingto team members and clients.

Undergraduate degree or equivalent experience.
Experience Summary

2+ years of experience working with ETL and Data Warehousing services in Cloud Environments (AWS/Azure)

Skills & Qualifications
Core Skills

Strong analytical and problem-solving abilities
Technical aptitude with a quick learning curve for new technologies

Education

Bachelor’s degree in Computer Science or any Engineering field

Required Technical Qualifications

Database Knowledge: Oracle, SQL Server, MySQL
ETL Tools: MSBI (SSIS/SSRS/SSAS), InformaticaSQL and Scripting: SQL, Python, ScalaCloud Platforms: Azure, AWSBig Data Technologies: Databricks, Hadoop, Apache Spark

Documentation

Contribute to technical documentation of specifications and processes

Preferred Qualifications

SQL Skills: Ability to query large datasets and optimize queries
US Healthcare Knowledge: Highly preferredHealth Information Systems: Working knowledge preferredClinical Data Analysis: Highly preferredClinical Processes: Understanding of clinical workflows and vocabulary

Soft Skills

Analytical & Creative: Highly analytical, curious, and creative
Organized: Strong organizational skills and attention to detailOwnership: Demonstrates accountability and ownership of responsibilities