UnitedHealth Group

Advisory Services Analyst - Multiple Locations

1 week agoHyderabad, India

Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)

The production support data engineer will work closely with the Analytics team in monitoring, troubleshooting, and resolving production issues around ETL and Data Analytics daily batch jobs. You will work with other data engineers, architects, and platform engineers to ensure the adequate operation of all components related to our Enterprise Data Warehouse and Business Intelligence batch processing. This position will leverage key development, database, and custom analytics solutions. The individual will support EDW monitoring & troubleshooting, code migration, platform support, automation, optimizations, and access provisioning. Functions may include ETL jobs development and Dashboard developments

Primary Responsibilities:

  • Monitor daily SQL/ETL/BI processes on production and troubleshoot delays & issues, analyze the root cause, and resolve issues
  • Work with onshore stakeholders from data engineers, BI developers, Platform or DBA team as needed in troubleshooting, fixing issues
  • Work on enhancements/change requests of the code
  • Work on performance tuning of ETL jobs/queries or processes to improve overall system performance
  • Processes code migration requests/access requests for EDW platform
  • Follows organization change management and version control procedures
  • Support software release testing and server upgrades, provide production support sign off for new versions
  • Develops and maintains documentation on administration and support
  • Administration, configuration, and support of the EDW and data marts
  • Ability to build ETL processes to pull data from various sources and integrate with existing EDW system
  • Develop SQL/ETL code per technical specifications and business requirements
  • 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:
  • 6+ years of experience working with any ETL tool and Database, Preferably Microsoft SQL Server, and SQL Server Integration Services (SSIS)
  • Prior experience in EDW/Data Integration/ETL Production support and administration experience, preferably in healthcare domain.
  • Experience in optimizing complex SQL/ETL processes
  • Experience in monitoring & troubleshooting scheduled BI processes on server
  • Expertise in technical/support documentation
  • Good working experience with any change management and version control tools
  • Ability to manage multiple projects and tasks
  • Nice to have experience with any reporting tools, Preferably on Qlikview

Preferred Qualifications:
  • Experience working in the healthcare industry
  • Experience working in Data warehouse Development

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make the health system work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)

Job Keywords: Advisory Services Analyst, Data Engineer Production Support, SQL, Healthcare, Date Warehouse, Hyderabad, Telangana, TG, Gurgaon, Haryana, HR