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.

This role will sit in the Optum Advisory organization within Optum Insight. You will be part of Risk Management & Insights team, specializing in Trend Analytics & Payment Innovation.

You will be part of a team responsible for developing specifications which measure medical cost savings associated with Optum Insight cost management payments.

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

Primary Responsibilities:

• Oversee and maintain custom code bases for 17+ clients on 2 tech platforms
• Analyze large datasets to ensure accurate application of SQL logic and calculations
• Identify/research/resolve logic breaks, bugs, and enhancements independently by partnering with SMEs
• Develop detailed business and technical requirements to change/refine code and logic
• Collaborate with data engineers to create new repeatable data ETL processes and/or update existing ETL processes
• Conduct data profiling and analysis using source data to meet business requirements
• Design and perform QA checks and thorough end-to-end testing to confirm accurate savings calculations
• Maintain high performance and quality through ongoing remediation testing and post-production monitoring
• Perform robust regression and UAT testing accompanied by detailed documentation and test plans
• Continuously refine quality control measures and automated processes
• Manage and understand complex and high-volume daily production data processes
• Communicate impacts (savings, claim volumes, etc.) with internal and/or external stakeholders

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:

• 2+ years of experience with hands-on data analysis of health insurer’s medical eligibility/membership and medical claims data; including writing ad hoc SQL against a data warehouse that contains large volumes of data from a variety of different sources
• 2+ years of business analyst experience - gathering requirements and writing functional data specifications
• 1+ years of hands-on experience with at least one of the following database technologies: Oracle, SQL Server, DB2, Teradata, Snowflake
• 1+ years of hands-on experience querying data in a data warehouse that contains large volumes of data from a variety of different sources
• Proficient in reading and writing SQL code to understand data creation
• Hands-on experience writing SQL statements using the following commands in a relational database: GROUP BY, SUM, HAVING, JOIN, WHERE
• Experience with Microsoft Excel, including experience creating pivot tables and writing functions (e.g. SUM, VLOOKUP, CONCATENATE, etc.)

Preferred Qualifications:

• Demonstrated awareness of when to appropriately escalate issues/risks
• Demonstrated excellent communication skills, both written and verbal
• Demonstrated ability to work independently to conduct analysis, and then summarize and review findings with others
• Demonstrated ability to collaborate with data engineers, actuarial staff, project leads and manager
• Demonstrated ability of attention to detail and critical thinking skills
• Experience supporting data production processes that refresh on a regular cadence
• Experience establishing database connections with query tools (e.g. Toad, Dbeaver, DBVisualizer, etc.)
• Claim processing experience across different platforms

• 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, Washington, Washington, D.C. Residents Only: The salary range for this role is $70,200 to $137,800 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.