Manager - Metrics, Analytics and Reporting

We are seeking a highly skilled SQL Expert to join our Metrics Reporting and Analytics team at Mercer. This role will be based out of Mumbai, India. This is a hybrid role requiring at least three days a week in the office.

A Lead Specialist - SQL & Data Analytics will be instrumental in driving data-driven decision-making through advanced SQL expertise. This position is responsible for designing, developing, and optimising complex SQL queries, data pipelines, and data models to support reporting, analytics, and insights.

We will count on you to:

• Develop, optimise, and maintain complex SQL queries, stored procedures, functions, and scripts to support reporting and analytics needs.
• Design and implement scalable data pipelines and ETL processes to ensure high data quality and performance.
• Support the development of management dashboards and reports using BI tools, integrating data from multiple sources.
• Conduct in-depth analysis of large, complex datasets to identify trends, anomalies, and insights.
• Ensure data accuracy, consistency, and integrity through rigorous validation and data governance practices.
• Automate report generation and data workflows to improve efficiency and timeliness.
• Collaborate with business stakeholders to understand data requirements and translate them into efficient SQL solutions.
• Document SQL code, data processes, and data governance standards.
• Act as the point of contact for SQL-related queries and process updates.

What you need to have:

• Bachelors / MBA / Masters Degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of hands-on experience in SQL development, data warehousing, and analytics.
• Proven expertise in writing high-performance SQL queries for large datasets.
• Experience with ETL tools and processes, data modelling, and data architecture.
• Familiarity with BI tools such as Power BI, Tableau, or Qlik Sense, optional
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication skills, with the ability to explain complex data concepts clearly.

What makes you stand out?

• Ability to think in terms of business frameworks and connect the dots to arrive at insights
• Strong Communication and ability to collaborate across teams
• Strong analytical, research and problem-solving skills, attention to details
• Ability to work independently and how you approach complex requirements

Why join our team:

• Your expertise will directly impact strategic decision-making and business performance.
• We support your growth through professional development, challenging projects, and leadership.
• Join a vibrant, inclusive culture where innovation and collaboration thrive.

Mercer, a business of Marsh McLennan (NYSE: MMC), is a global leader in helping clients realize their investment objectives, shape the future of work and enhance health and retirement outcomes for their people. 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 mercer.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.