Advisory Services Analyst – SQL, Macros – Hyderabad

Advisory Services Analyst

Optum, the fastest growing part of UnitedHealth Group, is a leading information and technology-enabled health services business. Our teams are dedicated to modernizing the health care system and improving the lives of people and communities.

Serving virtually every dimension of the health system, we work with a diverse set of clients across 150 countries – from those who diagnose and treat patients to those who pay for care, deliver health services, and those who supply the cures. Optum maintains operations across North America, South America, Europe, Asia Pacific and the Middle East. Our innovative partnerships provide technology and tools that enable unprecedented collaboration and efficiency. As a result, we can tap into valuable health care data to uncover insights and develop strategies for better care at lower costs.

About the role:

We all know that there’s a lot more to come in the changes sweeping through the health care industry. But if change is going to shape our world, it’s comforting to know that we’re shaping the change. At Optum, the actuarial consulting leader in health care innovation, your performance, your ideas and your innovative thinking will help us improve the lives of millions.

As the Advisory Consultant, you will join an elite team committed to changing health care through outstanding service and valuable products. You will work with pricing/rating and underwriting systems consulting with internal stakeholders on system design, configuration and implementation. 

Primary Responsibilities: 

• Work with Optum client leadership to gather requirements for implementing new rating and underwriting models, driving automation and effectiveness of underwriters
• Create wireframes and process flow diagrams to model user experiences and workflows, then use StepWise Portal to configure and deliver
• Build business rules and mathematical models using Excel-like calculation syntax
• Work with various data sources using SQL Server and other database tools to connect data into StepWise
• Build client presentation exhibits and reports using Word and Excel based document templates
• Work as part of a team to deliver a comprehensive solution to customers
• Present to and collaborate with Optum peers and Optum management
• Establish trust, credibility and thought leadership within Optum and with our clients
• Deliver quality solutions to customers within project deadlines

• Advanced level of proficiency with Microsoft Excel, including complex formulas, calculations, VBA macros, etc. 
• Undergraduate or Masters degree
• Proficiency with Microsoft Excel/VBA Programming /Macros
• Proficiency with query writing in SQL, SAS or similar
• Demonstrated ability to work independently, troubleshoot / problem solve, while driving deliverables to completion

 Preferred Qualifications: 

• Advanced level of proficiency with Microsoft Excel, including complex formulas, calculations, VBA macros, etc. 
• Experience independently building rating models or other complex financial or business models in Excel or other software
• Experience designing effective user interfaces and/or workflows
• Experience in SQL
• Understanding of the healthcare industry, especially commercial group business lines
• OOPS,C# Or any coding

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

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.