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 diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. 

 
Primary Responsibilities: 

• Work closely with data analysts to transform specification into client algorithms (4 Oracle, 2 Snowflake)
• Code complex procedures to support new client algorithms (4 Oracle, 2 Snowflake)
• Contribute to technical documentation of specifications and processes
• Responsible for weekly data loads and balancing of 9 accounts (6 Oracle, 3 Snowflake)
• Investigate data anomalies to determine root cause, specify appropriate changes and work with engineering and operations teams as the change is implemented and tested
• Research client questions on data results by identifying underlying data elements leveraged and providing descriptions of data transformations involved
• Work closely with engineering and operations teams to answer questions and resolve data issues that arise
• Extracting and replicating data into a common data mart
• Drive adoption of best practices and agreed upon design patterns
• Communicate clearly and effectively in oral and written forms, and be able to present and demonstrate work to technical and non-technical leadership

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: 

• 10 years of Oracle database experience
• 5 years of experience with data warehouses/marts supporting business requirements
• 5 years of intermediate to advanced PL/SQL and SQL experience (ability to create queries/joins)
• 5 years of UNIX command prompt navigation, including VI editor (Shell Scripts) 
• 5 years of experience working with healthcare data, to include 2 years with claims data 

Preferred Qualifications: 

• Experience working in a matrixed environment on a fast-paced project
• Experience developing within an agile (i.e. Scrum or Kanban) framework
• Experience with Snowflake
• Experience with data loading tools (Talend, Informatica, Data Factory, ODI)
• Exposure to cloud environments experience (Azure)

 
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy.

California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, or Washington Residents Only: The salary range for this role is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers 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 UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.  
 
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. 
 
 
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.