Our Ability Jobs

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.

By delivering solutions across spectrums of health care Optum is focused on our aspiration of improving experiences and outcomes for everyone we serve while reducing the total cost of care. In support of this, OptumInsight's purpose is to connect the health care system with trusted services, analytics and platforms that make clinical and administrative processes valuable, easy and efficient for everyone

OptumInsight provides analytics, research, consulting, technology and managed services solutions to hospitals, physicians, health plans, government agencies, life science companies and other industry partners. In addition to our many commercial clients, OptumInsight’s capabilities and technologies are leveraged by OptumHealth, OptumRx and our sister company UnitedHealthcare.

The Advisory Svcs Sr Consultant is responsible for creating solutions based on SQL requirements, writing business and/or technical requirements, and validating that developed solutions meet these needs. Initially working with guidance on routine activities, they eventually become independent, actively participating in ensuring high-quality solutions and applying an understanding of testing methodologies. The Development Analyst should possess strong knowledge of performance tuning, query plans, indexing, and table partitioning.

Effective communication with business stakeholders and the QA/UAT team is crucial, as the Development Analyst contributes to solution design through analysis and discussion. They are responsible for documenting processes, adhering to agreed-upon timeframes and protocols, and maintaining high standards. The role also supports numerous production operations, including running and maintaining SQL agent jobs, and coordinating with Quality Assurance and Development teams, Business Analysts, and Project Managers. This position supports several programs that deliver content to various stakeholders on a weekly, monthly, and quarterly schedule, with responsibilities divided into running SQL jobs, problem-solving and performance tuning, and SQL development work for new client requests.

The above will be achieved through demonstrated integrity, improving the client experience by delivery accurate reports, clearly collaborating with others, contributing innovative ideas in a changing environment and driving for results.

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

Primary Responsibilities:

• Write and optimize SQL statements for data storage, sorting, and retrieval.

• Develop solutions that meet business requirements within time and cost constraints.

• Develop and execute database queries and perform data analysis.

• Manage and develop ETL processes.

• Conduct unit testing and troubleshooting.

• Manage common database procedures, including backups and restores.

• Prepare detailed documentation and specifications.

• Follow Change Management protocols and best practices.

• Collaborate effectively with team members and stakeholders.

• Actively participate in departmental meetings, training sessions, and educational activities; assist in training other employees and providing backup support.

• Perform additional duties as assigned by management.

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 SQL experience, preferably in SQL Server

• 5+ years of experience with SSIS

• 4+ years of experience scoping, deriving and building case-based testing from business requirements

• 3+ years of experience with solving advanced analytical problems

• Solid organizational skills and a demonstrated ability to work effectively as a member of highly functioning team of experts

Preferred Qualifications:

• Healthcare claims experience

• SSRS, Power BI, or Tableau experience

• SVN or Git experience

• Advanced technical aptitude (can learn new tech quickly)

• Experience deriving and building case-based testing from business requirements

• Ability to work independently and in a fast-paced environment

• Proven abilities to take initiative and be innovative

• Excellent written and verbal interpersonal communication skills

• Excellent time and resource management skills

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

California, Colorado, Connecticut, Hawaii, Maryland, Nevada, New Jersey, New York, Rhode Island, Washington, 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.