SQL/Report Developer - Optum

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:

• Develop and maintain complex SQL queries and scripts used to create data marts in Teradata


• Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests


• Design, develop, implement, and maintain Business Intelligence reports using healthcare claims data


• Develop complex business intelligence solution and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks


• Develop complex dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data including 835, 277, and 837 transitions


• Maintain effective communication and relationships with all individuals involved with the project


• Improve the delivery and management of health and human services programs by utilizing advanced analytics, including but not limited to advanced algorithms, data
  visualizations, and maps


• Participate in project discussions to document and recommend alternative technical solutions or requirements


• Participating in unit, integration, and system testing


• Perform peer-reviews and provide technical support/guidance to the project team


• Support the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting


• Demonstrate deliverables to the team or the customers for approvals and gain buy-in to implement solutions or adapt to new products/services/programs


• Work with the DBAs, data modelers, and application/system admins to support maintaining the Teradata and application server hardware and software (including patches, fixes, and upgrades) and leading industry level standards or best practices


• Learn new technologies as needed to be able to perform job duties effectively


• Research and consult with resources and/or industry experts to ensure the effectiveness and efficiency of systems and applications


• Perform additional duties that are normally associated with this position, as assigned

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 Teradata version 14+ experience, including SQL Assistant/Teradata Studio


• 5+ years of experience developing, implementing, and maintaining complex Tableau or MS Power BI dashboards, visualizations, and analytics


• 5+ years developing complex business intelligence solutions


• 5+ years of data warehouse project experience


• 5 years of experience developing complex SQL scripts (Teradata/DB2/Oracle Load Utilities) AND stored procedures


• 3+ years of experience using x12/EDI data including 835, 277, and 837


• Experience with healthcare claims

Preferred Qualifications:

• 5+ years of experience analyzing and delivering complex analytics using Medicaid or Managed Care claims.


• 3+ years of Tableau Server Administrative experience


• Experience with State Medicaid / Medicare / Healthcare industry


• Experience in SAP Business Objects or SAS


• Experience in Tableau or BO version upgrades


• Experience in Agile


• Located in Springfield, IL

*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, or Washington, D.C. 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.