Design and build scalable ETL/ELT data pipelines into a cloud data warehouse (preferred Snowflake); author, optimize, and troubleshoot complex SQL queries; collaborate on code quality, CI/CD, reporting, and AI-first development; perform code reviews and maintain security/compliance standards.
Requisition Number: 2334231
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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.
Primary Responsibilities:
Required Qualifications:
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.
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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.
Primary Responsibilities:
- Develop solid scalable and reusable Data pipelines to Extract, load and transform data into cloud based Datawarehouse Snowflake
- Develop complex SQL queries (using joins, analytic functions, aggregation functions, windows functions), ETL Jobs, Reports/Dashboards to meet complex business requirements and data needs
- GitHub Copilot usage in software development Promote AI-first mindset in product development
- Collaborate with cross-functional teams to improve code quality, development practices, and processes
- Maintain development standards, perform critical development, and release operations Maintain Zero security violation (x-ray scan etc), Zero code vulnerabilities
- Troubleshoot and debug complex technical issues
- Conduct code reviews and provide constructive feedback
- 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:
- AI-Powered Solutions Development - Experience in developing and deploying AI-powered solutions using no-code, low-code, and advanced platforms, translating business needs into scalable solutions
- Good understanding of Database concepts
- Expert/ln-depth knowledge Of SQL: Building, debugging and tuning complex queries, business rules engines
- Knowledge in Dimensional Data Modelling and Semantic layer building for DWH, Reporting and Analytics
- Technical Skills
- Solid knowledge of:
- SQL,
- Datawarehouse
- ETL
- Database concepts
- SQL performance tuning
- Reporting and Analytics
- Cloud platform
- Agile methodologies
- Familiar with:
- Cloud based Datawarehouse (Preferred Snowflake)
- Cloud based Reporting/Analytics platform (Preferred Looker)
- ETL and Integration tools (Preferred Snaplogic)
- Ansible and Jenkins for CICD
- Cloud platform (Preferred Azure)
- AI technologies
- Solid knowledge of:
- Demonstrated ability to create big complex SQL queries (using joins, analytic functions, aggregration functions, windows functions) to load, transform and present data to downstream consumers to meet business data needs
- Demonstrated ability to prepare data as part Of an ETL or ELT process, and perform transform-load in cloud based Datawarehouse
- Proven efficient at resource optimization, analytics, and SQL performance tuning
- Proven solid programming and algorithmic skills
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.
Top Skills
Sql,Snowflake,Github Copilot,Looker,Snaplogic,Ansible,Jenkins,Azure,Etl,Elt,Data Warehouse,Reporting And Analytics,Ai Technologies
Similar Jobs at Optum
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
The Senior Manager Data Engineering leads the architecture and optimization of Oracle Exadata systems, ensuring operational availability and performance in large-scale data environments.
Top Skills:
AIDevOpsOracle DatabaseOracle Enterprise ManagerOracle ExadataZdlra
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
The role involves managing projects, coaching teams on Agile practices, planning sprints, identifying risks, and improving project communication.
Top Skills:
AgileJIRAMS OfficeRallySafeScrum
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design and deploy scalable AI/ML solutions, optimize model performance, and collaborate with teams to translate business challenges into AI solutions.
Top Skills:
BertHadoopKafkaNlp LibrariesNltkPysparkPythonPyTorchRScikit LearnSpacySQLTensorFlow
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
