Shire 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.

Primary Responsibilities:

• Will be responsible for providing detailed design of the cloud data warehouse solution to the scrum teams

• Guide and coach the team to deliver on the proposed design

• Will lead data mapping and design sessions, participate in code reviews, and conduct research and analysis to troubleshoot issues

• This role is responsible for conducting complex data analysis across multiple data domains; e.g. medical claims, eligibility, Rx, etc. when new data sources are introduced, existing sources have changes, and enhancements are required per NCQA specifications or business stakeholders

• Responsibilities also include engagement with technical teams and business stakeholders to discuss and propose approaches to meet current and future needs with ability to present findings/recommendations at multiple levels in the organization

• Role requires stay up to date on Quality measures, NCQA changes and impact to the technical solutions and business outcomes

• Also will include performance optimization and fine tuning of queries

• Ensure compliance with organization and project defined standards and processes

• Build a healthy relationship with project stakeholders/business partners

• Go-getter attitude and exhibit flexible approach at all times

• Mentor new talent

• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• B.Tech./MCA/Graduation (Minimum 15 years of formal education, Correspondence courses are not relevant)

• 15+ years of total experience

• 2+ years of experience working with snowflake, Exposure to below with solid SQL Skills

• Snowpark experience

• Stored procedures / Functions in SQL, Java script and other languages

• Understand the integration of snowflake with other external applications like Azure blobs, Databricks

• Snowflake system architecture & proven snowflake optimization experience

• Exposure in Databricks skills: 2+ years

• Exposure in Azure cloud: 2+ years

• Exposure with Data integration tools [Data stage or other ETL tools] : 5+ years

• Data Engineering (Modelling, Data Pipeline and solid Data analysis experience): 5+ years

• Ability to analyze complex data requirements and design appropriate data models

• Solid Health care and HEDIS experience 5+ years

• Having Big Data Experience (Hive, spark, MapR FS): 3+ years

• Experience closely working with US Stakeholders: 3+ years

• Experience with Grafana, Airflow

• Excellent problem-solving skills to address data quality issues, performance bottlenecks, and scalability concerns

• Ability to quickly learn and implement new technologies and methodologies

• Proven great attitude (Self Starter, very accountable and great collaborator)

• Proven great communication skills

• Solid understanding of engineering fundamentals: Source Code management, CI/CD pipeline, unit testing, code reviews, telemetry, agile and DevOps

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.