Data Developer (ADF) - Remote

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.
The ADF developer is part of a consulting team within Optum that manages a product solution, Medicaid Management and Administrative Reporting System (MARS), for state gov't agencies. The reporting solution integrates into a larger system which is the Medicaid Management Information System (MMIS). The team is comprised of Project Managers, MMIS Subject Matter Experts, Business Analysts, Database Administrators / Developers, and this ETL Informatica Developer, which is responsible for extracting, transforming, and loading the client claims data into MARS.
The preferred candidate will be a creative thinker who is comfortable working independently or in teams. They will be a quick learner who is confident they can master a complex ETL model with little guidance. Previous Snowflake, Azure Data Factory, Python scripting or cloud migration experience is a plus.
You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.
Primary Responsibilities:

• Supports the Arkansas Medicaid Decision Support System (DSS) by developing and maintaining ETL pipelines and workflows, identifying, and resolving data quality issues, and optimizing processes to improve performance
• Supports intrastate agencies by creating and monitoring automated data shares and file extracts and working directly with state partners to create new extracts based on business specifications

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:

• 5+ years of Extract Transform and Load (ETL) Developer experience preferably in a data warehouse project environment
• 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements
• 3+ years working with SDLC processes
• 2+ years of experience creating pipelines in Azure Data Factory (ADF)
• 2+ years of batch or Powershell/Python scripting
• 2+ years of experience processing common complex file formats (ex: JSON, XML), as well as simpler formats (ex: fixed-width, delimited, etc.)
• 1+ years of Federal Reporting experience (Medicaid or similar programs)

Preferred Qualifications:

• 3+ years of data modeling experience in a data warehouse environment
• 2+ years of experience with GitHub, SVN, or similar source control systems
• Experience with HL7 and FHIR standards, and processing files in these formats
• Extract, Transform and Load (ETL) experience in a cloud environment
• Experience with Medicaid, Healthcare data or MMIS systems
• Proven solid SQL programming skills and performance tuning
• Demonstrated leadership skills and ability to manage smaller projects independently

*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $89,900 to $160,600 annually based on full-time employment. We comply with all minimum wage laws as applicable.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
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.
UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.