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. Come make an impact on the communities we serve as we help advance health equity on a global scale. Here, you will find talented peers, comprehensive benefits, a culture guided by diversity and inclusion, career growth opportunities and your life's best work.(sm)
Our team provides Analytic Application development and support and Consulting for Optum Payment Integrity. Although we provide data analytic development services that identify opportunities for Coordination of Benefits (COB), Fraud Waste Abuse and Error (FWAE), and Subrogation, this position predominately involves identifying members with other insurance for the various COB projects.
Our Senior Analytic Developer position will develop new analytics, enhance existing analytics, and maintain and improve the applications that support these analytics. Additionally, this position will have the opportunity to conduct analysis research and consulting for new project initiatives across the portfolio the team supports. Currently most analytics are written in SSIS executing in a SQL Server environment, but the team is transforming these analytics leveraging open-source tools like Python, Scala, Spark.
You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges.
Primary Responsibilities:

• Provide realistic effort estimates and project timelines for development and support project
• Interpret business requirements and functional specifications and create technical design and technical specifications documents
• Develop analytic processes following existing standard structures and macros. Develop for a production environment
• Conduct data extraction and research studies that may include analyzing, reviewing, trending, and presenting information, based on provided specifications, to support adhoc data request
• Work with business engagement leaders and technical analysts to develop new and modify existing process documentation and templates
• Conduct analyses of data elements within existing source data mart schemas
• Analyze healthcare claims from different data sources and identify data integrity issues
• Perform unit, system and regression testing for programs for quality assurance
• Performance tuning of existing applications and analytics
• Guide and advise developers to identify and improve the efficiency of current programming practices
• Contribute to knowledge sharing, ideas and information relating to technologies and be a key technical expert within the team
• Lead/Mentor new and existing team members
• Continually identify deficiencies in production processes, propose enhancements, and implement those enhancements to increase productivity or reduce manual effort

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:

• 3+ years SQL Server development (developing stored procedures, query development, etc)
• 3+ years SSIS
• 1+ years Healthcare Data Experience

Preferred Qualifications:

• Bachelor's degree or equivalent
• SAS/SAS Grid experience
• Python, Spark, Scala, or Drools Experience
• Relational Database experience - Oracle, Teradata, Netezza, DB2
• Data Analysis experience
• Functional Testing experience
• UNIX
• Knowledge of COB (Coordination of Benefits)
• Solid analysis, process, problem solving and critical thinking skills

Careers with Optum. Our objective is to make health care simpler and more effective for everyone. With our hands at work across all aspects of health, you can play a role in creating a healthier world, one insight, one connection and one person at a time. We bring together some of the greatest minds and ideas to take health care to its fullest potential, promoting health equity and accessibility. Work with diverse, engaged and high-performing teams to help solve important challenges.
Colorado, Connecticut, Nevada, or New York City Residents Only: The salary range for Colorado residents is $82,100 to $146,900. The salary range for Connecticut/Nevada/New York City residents is $90,500 to $161,600. Pay is based on several factors including but not limited to education, work experience, certifications, etc. 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.
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
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.