TELUS Health Senior Reporting Analyst Interview Questions and Answers

Maths, English aptitude

Q1. General questions about previous exp. and basic excel related
Add your answer

Q1. Salary expectations and stability check
Add your answer

Q1. What is attribution analysis
Ans. 
Attribution analysis is a method used to evaluate the performance of investment portfolios by attributing returns to different factors or sources.
• Attribution analysis helps identify the drivers of portfolio performance.

• It breaks down returns into components such as asset allocation, stock selection, and market timing.

• By analyzing attribution, investors can assess the impact of their investment decisions.

• For example, if...read more
Answered by AI
Add your answer

It was a computer based test with simple mental maths questions and a bit or logical reasoning aling with English comprehension

Q1. Tell me about yourself.
Ans. 
Experienced Senior Analyst with a background in financial analysis and data interpretation.
• Over 5 years of experience in analyzing financial data and providing strategic recommendations

• Proficient in using various analytical tools and software such as Excel, Tableau, and SQL

• Strong communication skills to effectively present findings to stakeholders

• Proven track record of improving operational efficiency and driving busin...read more
Answered by AI
Add your answer
Q2. Why do you want to join Mercer?
Ans. 
I want to join Mercer because of their reputation for excellence in data analysis and their commitment to employee development.
• Mercer is known for their expertise in data analysis and I am excited to contribute to their projects

• I value the opportunity for professional growth and development that Mercer offers

• I admire Mercer's reputation for excellence in the industry and want to be a part of that team
Answered by AI
Add your answer
Q3. What department/position you want to work in and why?
Ans. 
I want to work in the Marketing department because I enjoy creating strategies to promote products and engage with customers.
• I have a strong background in marketing and have successfully implemented campaigns in the past.

• I am passionate about understanding consumer behavior and using data to drive decision-making.

• I thrive in fast-paced environments and enjoy collaborating with cross-functional teams to achieve goals.
Answered by AI
Add your answer

Q1. Why should we hire you?
Ans. 
I have a proven track record of delivering high-quality analysis and insights, along with strong problem-solving skills.
• Extensive experience in data analysis and interpretation

• Strong analytical skills and attention to detail

• Ability to communicate complex findings in a clear and concise manner

• Proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a seasoned Senior Analyst leading a team of analysts and contributing significantly to the company's growth.
• Leading a team of analysts

• Contributing to company's growth

• Enhancing analytical skills through continuous learning

• Building strong relationships with stakeholders
Answered by AI
Add your answer
Q3. Mercer's hiring rate is really low in the Industry because we look for stability in our environment. How can we trust that you will not leave the organisation?
Add your answer
Q4. What is your goal if you get a chance in this organisation?
Ans. 
My goal is to contribute my expertise and experience to drive strategic decision-making and improve operational efficiency within the organization.
• Drive strategic decision-making

• Improve operational efficiency

• Contribute expertise and experience
Answered by AI
Add your answer

Q1. Tell me about yourself and previous roles and responsibilities. After that they asked about Insurance domain knowledge and technical questions about SQL
Add your answer

Q1. Salary discussion and reason for switching job
Add your answer

Basic grammar, quant, LR and DI

Q1. How do you see a life of a consultant?
Add your answer
Q2. The working hours would be long. how will you cope with that?
Add your answer
Q3. Do you understand data well?
Ans. 
Yes, I have a strong understanding of data and its analysis.
• I have experience in collecting, organizing, and analyzing data from various sources.

• I am proficient in using statistical tools and software to interpret data.

• I have successfully presented data-driven insights to stakeholders in previous roles.
Answered by AI
Add your answer

Finance related questions

Q1. Holding period return
Add your answer
Q2. Sharpe ratio, sortina ratio
Add your answer

Q1. From resume and profile
Add your answer