Data Analyst - 2332094

EMPLOYER:    Optum Services Inc.

JOB TITLE:    Data Analyst

LOCATION:    1 Optum Circle, Eden Prairie, MN 55344 (Telecommuting available from anywhere in the U.S.)

DUTIES:    Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software. Duties include: Develop and manage effective working relationships with other departments, groups, and personnel; Efficiently communicate with Data architect while understanding the requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users; Assist in the overall architecture of the ETL Design, and proactively provide inputs in designing, implementing, and automating the ETL flows; Investigate and mine data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions; Develop ETL pipelines and data flows in and out of the data warehouse using a combination of Azure Data Factory and Snowflake toolsets; Develop idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines; Work in Snowflake Virtual Warehouses as needed in Snowflake and automate data pipelines using Snow pipe for tedious ETL problems; Capture changes in data dimensions and maintain versions of them using Stream sets in snowflake and schedule them using Tasks; Optimize every step of the data movement, not only limited to source and during travel, but also when it's at rest in the database for accelerated responses; Build a highly efficient orchestrator that can schedule jobs, execute workflows, perform Data quality checks, and coordinate dependencies among tasks; Responsible for testing of ETL system code, data design, and pipelines and data flows; Root cause analysis on all processes and resolve production issues as a part of the process and routine tests on databases and data flow and pipeline testing; and Responsible for documenting the implementations, and test cases as well as responsible for building deployment documents needed for CI/CD. Telecommuting available from anywhere in the U.S.    

REQUIREMENTS:    Employer will accept Master's degree in Computer Science or related field and one (1) year of experience in the job offered or in a Data -related occupation. Position requires one (1) year of experience in the following: Data warehousing concepts, ETL concepts, and working with ETL/Data quality tools on any ETL platform; Building, deploying, and troubleshooting data extraction and loading pipelines (ETL) using Azure Data Factory (ADF); Writing complex SQL queries, Stored Procedures, and Performance tuning; Analyzing and executing data profiles; Working with healthcare data; and Developing a data solution on Snowflake Data Warehouse using snowflake continuous data pipelines with Snowpipe, Streams and Tasks.

RATE OF PAY:  $112,739.00-$138,495.00/per year

Please apply via careers.uhg.com and search for job #2332094

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)

UnitedHealth Group offers a full range of comprehensive benefits, including medical, dental and vision, as well as matching 401k and an employee stock purchase plan.

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.