Manager– Data Analyst

Marsh; Gurugram District; Hybrid; INR 1,800,000 - 2,800,000; Full time

Job summary

Mercer is seeking a Manager – Data Analytics to join our investments team in Gurgaon. This hybrid role requires in-office work at least three days per week and focuses on transforming complex investment data into actionable insights through leadership dashboards and reports.

You will automate data processing with Excel VBA and Python, collaborate with senior leaders, support bid inquiries and surveys, and ensure data integrity across multiple systems.

Qualifications

• Bachelor’s degree in finance, Data Science, or related field.
• 6+ years of experience in data analysis within institutional investments, asset management, or related financial services environment.
• Strong proficiency in data analysis tools and large financial datasets and market data vendors, experience with BI tools.
• Expertise in data management, data visualization, and analytics to transform complex financial datasets into actionable insights.
• Excellent analytical, problem-solving and communication skills necessary.
• Ability to work independently and collaboratively in a fast-paced, external deadline environment.
• Ability to collaborate with senior leadership and cross-functional teams to gather requirements and deliver impactful data solutions.
• Skilled in ensuring data integrity, consistency, and accuracy across multiple data sources and systems.
• Familiarity with BI tools and techniques to complement dashboard development and data storytelling.

Responsibilities

• Develop and maintain leadership dashboards delivering actionable insights for senior Investments leaders and consultants.
• Manage, analyze, and interpret complex investment and financial data to support bid inquiries, RFPs, and surveys.
• Ensure data integrity, accuracy, and consistency across multiple systems and data sources.
• Automate data processing and reporting using Excel (including VBA) and Python to improve efficiency.
• Collaborate with senior leaders and cross-functional teams to understand requirements and deliver timely reports.
• Stay updated on industry trends, regulatory changes, and best practices in institutional investing and data analytics.
• Conduct peer reviews to ensure accuracy, identify trends, and maintain consistency in outputs.
• Respond quickly to ad hoc data requests from the Strategic Bid Center and internal stakeholders.
• Assist in quarterly and annual survey data compilation and validation from various internal and external sources.

Skills

Data analysis

Data visualization

Excel VBA

Python

Dashboard design

Cross-functional collaboration

Education

Bachelor’s degree in finance, Data Science, or related field

Tools

Excel

Python

BI tools

Job description

We are seeking a talented individual to join our investments team at Mercer. This role will be based in Gurgaon. This is a hybrid role that has a requirement of working at least three days a week in the office

Manager– Data Analys

s.
We will count on you f

• or:Develop and maintain leadership dashboards delivering actionable insights for senior Investments leaders and consultan
• ts.Manage, analyze, and interpret complex investment and financial data to support bid inquiries, RFPs, and surve
• ys.Ensure data integrity, accuracy, and consistency across multiple systems and data sourc
• es.Automate data processing and reporting using Excel (including VBA) and Python to improve efficien
• cy.Collaborate with senior leaders and cross-functional teams to understand requirements and deliver timely repor
• ts.Stay updated on industry trends, regulatory changes, and best practices in institutional investing and data analyti
• cs.Conduct peer reviews to ensure accuracy, identify trends, and maintain consistency in outpu
• ts.Respond quickly to ad hoc data requests from the Strategic Bid Center and internal stakeholde
• rs.Support quarterly and annual survey data compilation and validation from various internal and external sourc

es.What you need to hav

• e: Qualifications: Bachelor’s degree in finance, Data Science, or related fie
• ld.6+ years of experience in data analysis within institutional investments, asset management, or related financial services environme
• nt.Strong proficiency in data analysis tools and large financial datasets and market data vendors, experience with BI tools, and a solid understanding of institutional investment solutions requir
• ed.Expertise in data management, data visualization, and analytics to transform complex financial datasets into actionable insigh
• ts.Excellent analytical, problem-solving and communication skills necessa
• ry.Ability to work independently and collaboratively in a fast past, external deadline environment necessa
• ry.Ability to collaborate with senior leadership and cross-functional teams to gather requirements and deliver impactful data solutio
• ns.Skilled in ensuring data integrity, consistency, and accuracy across multiple data sources and syste
• ms.Familiarity with business intelligence (BI) tools and techniques to complement dashboard development and data storytelli

ng.
What makes you stand

• outComfortable working in a fast-paced, hybrid environment managing multiple priorities and tight deadlines with agil
• ity.Demonstrated ability to translate complex financial and investment data into clear, actionable insights for senior leadership through impactful dashboards and repo
• rts.Strong technical proficiency in Excel (including VBA) and Python, enabling automation and advanced data analysis beyond standard practi
• ces.Proactive problem solver who anticipates challenges and drives continuous improvement in data processes and report
• ing.Track record of critical thinking beyond standard operating procedu
• res.Comfortable in bringing a distinct point of view to discussions; to improve the status
• quo.Excellent communication skills with the ability to convey technical information clearly to non-technical stakehold
• ers.Experience working with US-based clients and cross-cultural teams, demonstrating strong relationship-building ski
• eam:We help you be your best through professional development opportunities, interesting work and supportive lead
• ers.We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communit
• ies.Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-be

ing.Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 92,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn an

d X.
Marsh 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 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 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