Job Summary

We are seeking a talented individual to join our EMS team at Mercer, a Marsh business. This role will be based in Noida. This is a hybrid role that has a requirement of working at least three days a week in the office.
Role Summary

The Manager - Metrics and Analytics will lead the development, automation, and delivery of metrics-driven insights to support marketing and renewables business initiatives. The role requires robust expertise in metrics design, ETL processes, SQL, VBA, Python, and BI reporting tools to manage data workflows, enable accurate reporting, and provide actionable analytics that support strategic decision-making. Exposure to AI-enabled analytics and advanced reporting platforms will be highly valued.
Key Responsibilities
- Design, develop, and maintain robust metrics frameworks to track marketing performance, campaign effectiveness, lead generation, conversion trends, and renewables project outcomes.
- Lead the development and optimization of ETL processes to extract, transform,



and load data from multiple internal and external sources into reporting and analytics platforms.
- Write and optimize complex SQL queries to support recurring reports, ad hoc analysis, data validation, and business performance tracking.
- Build automation solutions using VBA and Python to streamline reporting, reduce manual effort, and improve operational efficiency.
- Develop and maintain dashboards and interactive reports using Power BI and Qlik to deliver timely, accurate, and user-friendly business insights.
- Use AI-driven tools and analytics techniques to enhance reporting efficiency, identify trends, improve forecasting, and support data-led decision-making.
- Analyze large and complex datasets to generate actionable insights that support marketing strategy, renewables planning, and business growth initiatives.
- Support reporting and analysis using MS Access where required for legacy databases, operational tracking, or departmental reporting needs.

📌 Manager - Metrics, Analytics & Reporting (Noida)
🏢 Oliver Wyman
📍 Noida