Senior Specialist - Data Analytics & Insight

Company:

Description:

Job Profile: Senior Specialist – Data Analytics & Insights

Location:Mumbai

No. of Roles :1

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:

• Set-up meetings/calls with the stakeholders in US to understand the business questions, scope of analytics and agree on timelines

• 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 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 the world’s leading insurance broker and risk adviser. With more than 45,000 colleagues advising clients in over 130 countries, Marsh serves commercial and individual clients with data-driven risk solutions and advisory services. Marsh is a business of Marsh McLennan (NYSE: MMC), the world’s leading professional services firm in the areas of risk, strategy and people. With annual revenue of $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses: Marsh, Guy Carpenter, Mercer, and Oliver Wyman. For more information, visit marshmclennan.com, follow us 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.