▷ [Urgent] Advisory Services Consultant

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 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 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 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 Eligibility To apply to an internal job employees must meet the following criteria The candidate should have completed 12 months in the current role The candidate should not be on any active CAP PIP The performance review of the candidate has to be ME Above in the last common review Required Qualifications Undergraduate or Masters degree 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 Experience or knowledge in OOPS C Or any coding Advanced level of proficiency with Microsoft Excel including complex formulas calculations VBA macros etc Proficiency with Microsoft Excel VBA Programming Macros Proficiency with query writing in SQL SAS or similar Understanding of the healthcare industry especially commercial group business lines Demonstrated ability to work independently troubleshoot problem solve while driving deliverables to completion 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