Data Analyst

Original Post

**Company:** ------------ Mercer **Description:** ---------------- Mercer is seeking candidates for the following position based in the Bangalore office. **Senior Analyst – Survey Administration (B2\)** This role is for the Analyst in the compensation consulting team. The position offers good career advancement opportunities, supported by training and professional development as well as access to the firm’s global network. **We will count on you to:** Client\-related activities – contact clients during the survey cycle, respond to client ad\-hoc queries * Support to the market consultants – supports participation solicitation, data collection material distribution \& follow\-up on data submissions, data validation and closure of client queries with support from mentor, resolving results access related issues and respond to ad\-hoc queries * Internal administrative tasks \- update client participation database, ensure that all the documentation and record keeping are complete * Help in creating / preparing client decks and reports, dashboards with necessary 1st level insights * To work on Large Data set on Excel. Cleaning and Structuring datasets (within HR \- salary / benefits / attrition / structures / etc.) * Help standardize data across multiple clients / regions \- under the supervision of the project managers **What you need to have:** well versed with working on O365 and automation tools like SQL / Python / Power BI / Tableau is preferred * Good and quick Data Analysis \- calculating percentiles, understand pay\-gaps, job / level mapping (under project manager supervision) and help in necessary workforce segmentation / analysis as deemed and agreed for the project (People / Data Analysis). * Able to multi\-task between different projects * Basic understanding of Rewards is an added advantage * Able to communicate with the external clients o'er calls \- when need be; under the supervision of Sr Project Managers is an added advantage * Ensures accuracy in data / reporting **What makes you stand out?** * Adaptable communicator, facilitator, influencer and problem solver * High attention to detail * Good relationship skills, Proven ability to work on own initiative as well as in a team * Adaptable communicator, facilitator and problem solver * High attention to detail * Ability to multi\-task and prioritize time effectively **Why join our team:** * We help you be your best through professional development opportunities, interesting work and supportive leaders. * 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 communities. * Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well\-being. **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 $24 billion and more than 90,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 and 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. 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 95,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 and 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.**