Role - Lead Specialist - Data Analytics & Insights


Marsh is a global leader in insurance broking and risk management. Marsh McLennan Global Services India Private Limited (MMGS) is seeking candidates for the following position based in the Mumbai, India office


What can you expect?


Working on strategic projects that are a part of a global transformation journey of an industry leader

An entrepreneurial, outcome focused environment, with an opportunity to build a team in a fast paced environment

Opportunity to set up and institutionalise high impact processes

Opportunity to develop analysis that will directly impact client development, retention and experience


What is in it for you?

Discover what's great about working at Marsh and McLennan Companies from the opportunities that our size brings, to our commitment to our communities and understanding the benefits youll receive. We are four businesses with one PURPOSE: helping companies meet the challenges of our time.
As a global leader in insurance broking and risk management, we are devoted to finding diverse individuals who are committed to the success of our clients and our organisation. Joining us will provide a solid foundation for you to accelerate your career in the risk and insurance industry. You will join a team of talented professionals from across the globe which is dedicated to helping clients manage some of the world's most challenging and complex risks. We can promise you extraordinary challenges, extraordinary colleagues, and the opportunity to make a difference.
Our rich history has created a client service culture that we believe is second to none. Our commitments to Diversity and Inclusion, Corporate Social Responsibility, and sustainability demonstrate our commitment to stand for what is right.


We will count on you to have the following skills and experience:

Expertise in Data Integration and Transformation:

Ability to merge and integrate data from multiple sources, such as internal databases, external APIs, spreadsheets, JSON and flat files.

Expertise in data transformation techniques, including data cleansing, normalization, aggregation, and de normalization.

Proficiency in creating data pipelines and workflows to automate data integration and transformation processes.

Assembling large, complex sets of data.Identifying, implementing internal process improvements including optimizing data delivery and automating manual processes
SQL Skills:

Strong command of SQL for querying and manipulating data in relational databases.

Knowledge of advanced SQL concepts, such as subqueries, joins, aggregates with joins.

Experience in optimizing SQL queries for performance and efficiency.
Data Structure Understanding:

Strong grasp of data modeling concepts and principles.

Understanding and working with complex data structures.

Ability to analyze and optimize data structures to meet performance and scalability requirements.
Data Visualization:

Experience in working on Visualization tools such as Power BI

Ability to develop insightful data visualization using the available data

Create and manage data models in Power BI

Use advanced visualization features of Power BI & proficient with DAX

Problem-Solving and Analytical Skills:

Ability to tackle complex data problems and develop innovative solutions.

Strong analytical and critical thinking skills to identify patterns, trends, and insights in large datasets.

Capacity to troubleshoot data issues and perform root cause analysis.

Soft Skills:

Understanding requirements, excellent communication skills and stakeholder management are crucial skills.


What you need to have:


Bachelors degree in any discipline

Experience of working with end to end tool development and delivery.

At least 4-6 years experience in data engineering working on large datasets and databases using SQL/Oracle, Alteryx and exposure to APIs..

Advanced Excel skills - highly proficient in using formulae, advanced pivot tables, selecting and creating charts etc. to enable analysis of data

Strong verbal and written communication skills to communicate and partner with stakeholders

Ability to work with International stakeholders across all levels, understand business objectives and make sure any analysis and findings are aligned to those business objectives

Keenness and urgency to learn about the Marsh and the business units business, and insurance industry in general


What makes you stand out?


Understanding of insurance industry terminology, data models, and business processes.

Knowledge of insurance-specific data requirements, such as policy information, claims data, underwriting data, etc.

Ability to examine data critically and identify analyses and synthesize trends out of them

Ability to take initiatives to strive for improvement in analytics techniques, process and output.


Disclaimer


Please note that the relocation assistance shall not be provided for the said position

Candidates who wish to apply for inter-location positions are required to check with the Transport Help Desk (THD) to confirm if their place of residence is within the served transport service zone

Mention your employee id and official email address in the resume


MARSH


Marsh is the worlds leading insurance broker and risk adviser. With more than 45,000 colleagues operating in more than 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 leading global professional services firm in the areas of risk, strategy and people. With annual revenue of over $20 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 (link removed), follow us on LinkedIn and Twitter.
Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people regardless of their sex/gender, marital or parental status, ethnic origin, nationality, age, background, disability, sexual orientation, caste, gender identity or any other characteristic protected by applicable law.