Lead Specialist - Data Analytics & Insight

Company:

Description:

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 you’ll 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: 

• Bachelor’s 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 API’s..

• 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 unit’s 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 world’s 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 marshmclennan.com, 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.