Lead Specialist – Data Analytics & Insights

Company:

Marsh

Description:

Job Profile: Lead Specialist – Casualty Advisory, Marsh, US&C

Location: Mumbai                                                                   

Business Unit: Marsh

Office Name: Marsh McLennan Global Services India Private Limited (MMGS)

MMGS Function: Knowledge Services

As a part of the Marsh Advisory team in Knowledge Services function of MMGS, the colleague would support our Casualty Advisory stakeholders in US by enabling their data analytics and claims value propositions. The Casualty Advisory team works closely with clients and carriers to proactively, identify ways to achieve optimal claims outcomes. Additionally, we provide end-to-end integrated experience across advocacy, preparation and handling, specifically designed to drive simplicity and close claims quickly. We prepare organizations with claims strategies using proprietary technology and data to minimize a client’s claims exposure and improve their cost of risk transfer. 

MMGS is a global knowledge center for Marsh McLennan and houses teams, which work closely with the colleagues across various operating units and locations. This position is out of our Mumbai, India office of MMGS.

What can you expect?

• Work as a core member of the Claims and Data Analytics team aligned to the Casualty Advisory practice of Marsh US
• Contribute to the creation and development of excel based Claims Analytics and Dashboards
• Collate information from various sources to further harvest for the purpose of analytics
• Apart from BAU, collaborate and contribute to project based initiatives that the Data Analytics and Reporting team within Knowledge Services keep signing-up

We will count on you to:

• Wrangle, standardize and integrate US Worker’s Compensation and Auto Liability (AL) claims data across clients and transform them to be consumed for Analytics
• Build excel dashboards with descriptive and trend based analytics on US Worker’s compensation and AL claims data
• Review all the metrics in the Dashboard to make sure that the values are within the defined range and call out any anomaly or unusual trends
• Handle complex and large claim files originating from third party’s Risk Management Information Systems (RMIS)
• Review claims data to identify the gaps and raise flags highlighting the impact
• Help in creating reports critical to invoice the client on the agreed scope of work
• Demonstrate great project management skills to ensure quality and timelines
• Create efficiency by automating repetitive tasks using VBA Macro

What you need to have: 

• 3 to 5 years of experience with strong data analytics skillsets. Candidates with General Insurance domain across different types of claims, claims lifecycle and claim data will be preferred
• Graduate or Masters in Commerce or Business Administration or any equivalent education programme
• Candidates with experience on US Worker’s Compensation and/or Auto Liability claims will have an advantage
• Microsoft Excel – Expert on data wrangling, data integration, macros and exceptional ability to handle large sets of data. Must be at ‘Expert’ level of proficiency
• Expert level VBA Macros with demonstrated experience in building data linkages and automation
• Beginner to intermediate level experience of SQL , R and Python scripting to fetch data will be an added advantage
• Strong verbal and written communication skills - excellent email writing skills.

What makes you stand out?

• Problem solving and critical thinking approach
• Strong communication and presentation skills. Ability to interact with all levels of internal and external business partners
• Capable of bringing in efficiency in existing processes
• Knowledge and experience of working on claims data
• Quick learner and enthusiasm for data analytics and hunger to explore new tools/platforms

Marsh is a global leader in insurance broking and risk management. In more than 130 countries, our experts in every facet of risk and across industries help clients to anticipate, quantify, and more fully understand the range of risks they face. In today’s increasingly uncertain global business environment, Marsh helps clients to thrive and survive. We are a wholly owned subsidiary of Marsh McLennan (NYSE: MMC), a global professional services firm offering clients advice and solutions in the areas of risk, strategy, and people. With 76,000 colleagues worldwide and annual revenue approaching $17 billion, Marsh & McLennan Companies also include global leaders Guy Carpenter, Mercer, and Oliver Wyman.

Marsh, a business of Marsh McLennan (NYSE: MMC), is the world’s top insurance broker and risk advisor. Marsh McLennan is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marsh.com, or follow on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.