Mercer Senior Performance Reporting Analyst Interview Questions and Answers

Q1. Why there are gaps in your experience?
Ans. 
I took breaks to pursue higher education and gain new skills.
• Took breaks to pursue higher education and gain new skills

• Completed a master's degree in Business Administration

• Attended professional development courses in data analysis

• Took time off to travel and gain global perspective
Answered by AI
Add your answer
Q2. Tell us about your experience
Ans. 
I have 5 years of experience as a Senior Analyst in the financial industry.
• Managed and analyzed large datasets to identify trends and patterns

• Developed and implemented data-driven strategies to optimize business processes

• Created comprehensive reports and presentations for senior management

• Collaborated with cross-functional teams to drive data-driven decision-making

• Utilized advanced statistical techniques and tools such
Answered by AI
Add your answer
Q3. Tell us about yourself
Ans. 
I am an experienced Senior Analyst with a strong background in data analysis and problem-solving.
• Experienced Senior Analyst

• Skilled in data analysis and problem-solving

• Strong analytical and critical thinking abilities

• Proficient in using various analytical tools and software

• Excellent communication and presentation skills

• Proven track record of delivering high-quality insights and recommendations

• Ability to work effectively...read more
Answered by AI
Add your answer

PPT on healthcare 10 slides and Word report on healthcare sector

Excel Questions related to Pivot

Q1. Guestimate was asked
Add your answer
Q2. Advanced Excel questions
Add your answer

Excel test
Logical Reasoning test
Quantitative aptitude test

An extensive case study for the corporate tax team that includes knowledge of US GAAP and transfer pricing.

Q1. What are the fundamental accounting concepts, accounting entries, and the applicable tax rates for various services?
Ans. 
Fundamental accounting concepts, entries, and tax rates for various services.
• Fundamental accounting concepts include accrual basis, matching principle, and consistency.

• Accounting entries for services typically involve recognizing revenue and recording expenses.

• Applicable tax rates vary depending on the type of service and the jurisdiction.

• For example, consulting services may be subject to a different tax rate than soft
Answered by AI
Add your answer
Q2. What is your understanding of transfer pricing and its applicability?
Ans. 
Transfer pricing is the setting of prices for goods and services sold between related entities within a company.
• Transfer pricing is used to determine the cost of goods and services transferred between different divisions or subsidiaries of a company.

• It is important for multinational companies to establish transfer pricing to ensure fair pricing and compliance with tax regulations.

• Transfer pricing can impact a company's...read more
Answered by AI
Add your answer

Q1. What is the amount of data you have managed in your previous roles?
Ans. 
I have managed large volumes of data in my previous roles, ranging from terabytes to petabytes.
• Managed terabytes of data in previous roles

• Handled petabytes of data in data analysis projects

• Experience with data storage and retrieval systems

• Utilized data management tools and techniques

• Implemented data governance policies and procedures
Answered by AI
Add your answer
Q2. Which ERP software have you worked with?
Ans. 
I have worked with SAP ERP software extensively in my previous roles.
• Extensive experience with SAP ERP software

• Proficient in modules such as Finance, Supply Chain, and HR

• Implemented custom solutions and integrations with SAP ERP

• Trained team members on using SAP ERP effectively
Answered by AI
Add your answer

Q1. What are your salary expectations and how do you approach negotiations?
Ans. 
I approach negotiations by researching industry standards and emphasizing my value to the company.
• Research industry standards for the position to determine a reasonable salary range.

• Highlight your skills, experience, and achievements that make you a valuable asset to the company.

• Be prepared to discuss and negotiate benefits and other perks in addition to salary.

• Stay professional and respectful during negotiations to ma...read more
Answered by AI
Add your answer
Q2. What is your preferred joining date and the notice period required by your current organization?
Ans. 
My preferred joining date is in one month and my notice period is two weeks.
• Preferred joining date: one month from now

• Notice period required by current organization: two weeks

• Flexible with joining date if needed
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Discuss about Previous experiences
Add your answer

Q1. Background and Exam leave discussion
Add your answer