27 Allan Gray Interview Questions & Answers
1. List the top 3 skills that you have acquired in your last role.
How to Answer
You have likely gained many valuable skills in your career. Share with the interviewer which skills you value the most. Be sure to include skills that will potentially benefit this potential new employer.
1st Answer Example
"In the past few years I was able to upgrade my education while still working full time. The biggest skill that I gained was my ability to multi-task as I worked the dual role of employee and student. I also have strong skills in a variety of Microsoft programs such as PowerPoint and Excel."
2nd Answer Example
"There are many skills I gained in my most recent position as I had a great training program and my boss was a strong mentor. If I had to choose three top skills I would say that the biggest ones were effective multitasking, solid closing skills, and cold calling abilities."
2. What is the most attractive thing in your eyes about this role with Allan Gray?
How to Answer
For this question, your interviewer is looking to gain insight into what you know and like about Allan Gray and how they will be able to help you meet your career goals. In your answer, try and stay focused on the alignment of your values with the organization's values and demonstrate that you've done your research on Allan Gray and the job you are interviewing for. To try and maintain positivity in your answer, try not to talk bad about a previous employer as that can make you sound like a difficult employee and raise a red flag for your interviewer.
1st Answer Example
"Over the past couple of years, I've had an eye on pursuing a career with Allan Gray because of your reputation as a forward moving financial institution and your commitment to the communities that you do business in. As a person that believes in togetherness and helping others out where possible, these are values that I hold very high and would bring to the team here."
2nd Answer Example
"As I enter the midway point of my career, my job search has been focused on finding an employer that I can spend the rest of my career with and someday retire from. Looking at the history, culture and growth of Allan Gray, this is definitely a place that I'd love to be a part of as you continue to grow and prosper into the future."
3. Give an example of a time that you had to resolve a difficult situation with a client or customer. What were the keys to coming to a successful solution?
How to Answer
In a front facing role with Allan Gray where you will be interacting with clients on a daily basis, your interviewer wants to be ensured that you have the skills to resolve client issues with ease and they'll look to do so with this question. In your answer, let your interviewer know that you can take ownership of any situation by talking about a specific time where you did what was necessary to alleviate a difficult situation with a client. Talk about the resources that you used and your interpersonal skills that helped turn a potentially bad situation into a successful one.
1st Answer Example
"Having worked in customer service for one of the areas largest auto dealership for the last six years, handling difficult customers was a situation I had to learn to handle pretty quickly. Just a few weeks ago, I was covering our front desk on a Saturday afternoon when our sales staff was still open for business. I recognized the person approaching the door as a customer that had recently purchased a new vehicle. He stormed through the door, placed his keys on the counter in front of me and said that he demanded a refund on his new purchase because the check engine light had already come on inside of the car. Knowing off the top of my head that his new vehicle was under a full warranty, I calmly let him know that his car was under warranty and that I'd have a member of our sales staff come out and take a quick look. I also let him know that our service department was not working that afternoon and, if needed, we could schedule him for a diagnostic test at his earliest convenience. After our salesman went out to take a quick look and not seeing anything obvious, we ended up giving him a loaner vehicle so his new car could be taken care of on Monday morning. He ended up leaving pretty happy that day and I know that my patience in hearing him out really helped."
2nd Answer Example
"A couple of years ago, I was asked to work with a very high profile client for his financial advising services when he came to our firm because my CEO trusted I could handle what he felt would be a difficult task. From my first meeting with the client, he demanded that we provide more returns than the previous firm that he worked with and he was rather rude with our front desk staff. I took the approach of taking the time to listen to his needs and speak to him more about what my firm could provide. I laid out my experience and track record for him to help him build his trust in me. I knew that with him, I would need to take time to walk through my decision making processes for his investments and he really appreciated that. As of today, we are still working strong together and his wealth is growing."
4. At Allan Gray, our clients are the lifeblood of our business and we do everything in our power to make them happy. What does the term customer service mean to you in your work?
How to Answer
No matter what position you are interviewing for at Allan Gray, your interviewer is looking to hear what customer service means to you in your work and how you apply that philosophy in your everyday work life. In essence, they want to hear your story as to why solid customer service is important to you. Prior to your interviewer, be sure to really think about this question to apply what is important to you in how you go about your work. Whether you talk about problem solving or making people happy, this should be reflected in the work that you do.
1st Answer Example
"A pursuit of a career in the financial field really suited my two passions in life of mathematics and problem solving. In this role, helping clients solve problems in an efficient manner and with a smile on my face would be the drive to succeed that I need. At the end of the day, if I see that my work helped a client grow their wealth and achieve their financial goals, I know that it was a job well done."
2nd Answer Example
"As a people person by nature, I have an innate ability to do what is needed to give customers the best experience possible when I'm working with them. This means that I reflectively listen to their needs and concerns and do what is necessary to help them based on what I heard. In my interactions with customers, I am positive, pleasant and nurturing by nature and I've found that customers are very receptive to my style off communication with them. If hired for this role at Allan Gray, you'll quickly find that dedicated customer service is one of top qualities that I will bring to you team."
5. Do you have any experience in financial modeling? What skills in financial modeling could you bring to the clients here at Allan Gray?
How to Answer
In the corporate finance world at Allan Gray, clients may look to you to be the expert to help them build forecasting models for the future. For this question, your interview is looking to hear that you have experience in financial modeling. Talk about your experience, what industry it was in and what tools you needed to help build as detailed of a model as possible. To seal the deal for this question, make sure to explain that your experience could be used across many businesses and industries with the clients you would be working with.
1st Answer Example
"As you can see from my resume, my corporate finance experience has mostly fallen in the manufacturing industry and financial modeling for forecasting purposes has been a skill that I've been developing over the past ten years. To start, I consider myself a master in Microsoft Excel to build great financial modeling tools that utilize all necessary data from an organization's financial statements. Though my experience is in manufacturing, my skills in financial modeling are ready to be applied to healthcare, banking or any other industry with your clients."
2nd Answer Example
"I have experience creating financial forecasting models in a few different areas of business. I consider my most unique talent to be my experience in M&A modeling for organizations that are looking to grow their business. In my current role, I've worked with leaders of organizations to strategically plan new acquisitions and modeling M&A for them was an integral part of the process. On top of M&A, I have experience in the standard three statement model and discounted cash flow analysis."
6. This position at Allan Gray has generated a lot of interest from applicants. What do you feel is the one quality that sets you apart from others we are speaking with about this position?
How to Answer
This question is the perfect opportunity for you to highlight the one key quality that makes you the best person for this position, so be sure to really think about what this one quality is ahead of your interview. While there are many ways that you can take you answer to impress your interviewer and seal the deal for you in getting the job, be sure to avoid making assumptions about the other candidates in your answer. As well, be sure to avoid anything in your answer that points to this job being convenient for you personally or the fact that you'll be getting compensated for this work. Those are quick ways for you to go to the bottom of the candidate ranking list.
1st Answer Example
"As I've talked about during this interview process and from what you can see on my resume, I have all of the technical skills needed to grow your financial advising practice here at Allan Gray. What sets me apart from my competition is my drive to succeed in this industry and I'd love to bring that drive to Allan Gray to help working with your highest profile clients possible. Growing up and continuing to this point in my life, I've always been a very competitive person. I've played many team and individual sports my whole life and my drive to win in those has definitely carried over to and been a huge benefit in my work as a Financial Advisor. I'd love to bring this competitive spirit to your team."
2nd Answer Example
"From what I understand about this role in Client Services with Allan Gray, my day to day work will include a lot of client interaction and I really feel like the job description was written with my skills and abilities in mind. But the thing that will really set me apart for being the perfect fit for this role is my experience on the sales side of things where I spent five years of my working career in the retail sales industry. In sales, I have developed key skills like product knowledge and selling skills that would be very beneficial to this role."
7. We want our advising team at Allan Gray to be happy and healthy. How do you manage the day to day stress of being a financial advisor?
How to Answer
The daily stressors of a career in financial advising can be burdensome, overwhelming and lead to burnout on the job. To get a sense that you can handle stress in a safe and healthy manner and be able to come to work each day with a clean slate, your interviewer is looking to delve into your personal life a bit to see how you manage stress. When answering, you can certainly talk about the things you do on the job to keep as stress free as possible, but also be sure to talk about the things that you do outside of work to avoid burnout. Point out that you have the resources and ability to care for yourself to keep you at the top of your game on the job.
1st Answer Example
"To begin with on the job, I consider myself very excellent at handling stress. Being a goal oriented person, I find happiness in obtaining goals and consider any necessary stresses in pursuit of a goal healthy. Outside of work, I am a very active person that trains for marathons and spends a lot of time outdoors with my family. I find that these activities help cleanse my mind and heal my body to prepare for a new week on the job."
2nd Answer Example
"When I maintain a healthy diet, exercise regularly and spend as much time as possible outside of work with my children, any unnecessary work stresses are put on the back burner and often relieved immediately. I'm a firm believer in a healthy work-life balance, even though it can be very tough to do in our field. Having the ability to answer a client email or phone call during off hours while unwinding has made our work lives better as well."
8. Accuracy is important to us at Allan Gray. Do you always double check or proofread your work?
How to Answer
Double checking and proofreading are essential parts of a job well done. Assure the interviewer that you are diligent when it comes to submitting good, clean, work.
1st Answer Example
"Spelling and grammatical errors are a pet peeve of mine. I will triple check my work if there is time! I feel that it is imperative to submit error-free work."
2nd Answer Example
"I do my best to put great work out, at all times. I believe in double checking my work although I must admit that I have fallen victim to the odd mistake like the best of us!"
9. What would you do in a situation where you just didn't have all of the information you needed from a client? What would be the steps that you took in ensuring you had all of the information possible in creating a financial analysis for a client?
How to Answer
Consulting with clients at Allan Gray will likely put you in a situation where you need to put on your investigative detective hat and do some extra digging to be able to provide great results to a client. For this question, talk about your interpersonal skills with your ability to work with others when needed. As well, talk about your ability to research and understand different financial statements and software programs to get the information that you need to solve a problem.
Answer Example
"Through my experience in working in corporate finance across many industries during my career, I am confident in my ability to troubleshoot issues I may have along the way when working with new clients. If I ever came across this situation when on a project with a client, I would start be using my best judgement and analytical skills to search for the information on my own in financial statements and accounting software of the client. If I was still left scratching my head, I wouldn't hesitate to sit down with employees in the finance department or leaders of the organization to pull the information that I would need."
10. Allan Gray strives for client loyalty to keep us running strong into the future. What do you feel are the keys to retaining clients for the long haul?
How to Answer
Businesses in financial advising are constantly pushing the limits to ensure that they retain clients and Allan Gray doesn't take client retention lightly. One slip up and a high profile client will be taking their business to a competitor. For this question, your interviewer will be looking to hear that you understand your role in the customer retention equation and how you take pride in that in your everyday work. Make sure to hit on the point that doing the small things, like prompt communication and follow up, go a long way towards keeping clients happy.
1st Answer Example
"I learned a few very important things from a senior mentor early in my career that I still hold near and dear to my heart to this day. First, clients expect me to be responsive to their needs to ensure that they keep their business with me. Because of this, I return phone calls and emails as soon as I can, even if that means in the evening, the early morning or on a Sunday afternoon. These small actions go a long way in showing my clients that I care. Another key to the success of my long-term clients is my ability to set and manage expectations for them. Clients desire to have a plan and know what that plan entails and I pride myself on my ability to work with them to set goals and a plan to achieve those goals."
2nd Answer Example
"Having lost clients in the past that went to another firm, I take that pain personally and do everything I can do to ensure long lasting relationships with my clients. For me, the first key to long term success with my clients is a proactive approach. I don't wait for clients to get in touch with me to make changes to their portfolio, I reach out to them. This action alone shows my clients that I am working for their best interest. Another action I take that shows my worth to my clients are goal tracking and quarterly progress reports that I send out to them. This is particularly helpful for clients that are working with me in their first two years."
11. We pride ourselves on teamwork here at Allan Gray and this role in Client Services relies on teamwork. What are the top qualities you would bring to a team based atmosphere here?
How to Answer
At the heart of this question falls your interviewers need to determine how well you will work with others on the team at Allan Gray. You will be working with high level advisors and managers that are under a lot of pressure to perform in their jobs and your communications with them will either alleviate some of that stress or add to it. To ensure that your interviewer walks away from your conversation knowing that you are a team player that keeps the end goals of the company in mind, focus your answer on your effective communication skills, your knowledge of everyone's role on the team and your knowledge of what your role on the team will be.
1st Answer Example
"As with any team that I have worked on in the past, my priority is knowing that everyone has an important piece in the overall success of the team. In customer service, this is knowing who to contact with the right questions and who to guide customers to when needed. This ensures that our work is done efficiently on our end of things and that our customers are handled efficiently and effectively. If hired here at Allan Gray, my first goal would be to get to know everyone on the team that I would work with, what their roles are and how to best communicate with them."
2nd Answer Example
"My top quality is my ability to communicate, both verbally and through writing. I have excellent interpersonal speaking and listening skills and my past colleagues have always appreciated this. Here at Allan Gray, your clients would appreciate this in my work as well. I am a very efficient and effective written communicator as well and this would be very beneficial at a company like Allan Gray, where your offices are spread throughout the country and I can imagine that email communication is vitally important."
12. Talk to me about a challenging situation you had to handle on the job that involved another colleague. How did you handle that situation?
How to Answer
At the heart of this question, your interviewer is looking to hear how you use solid interpersonal and relationship building skills to diffuse a difficult situation with a coworker when on the job. No matter what situation that you talk about, make sure to focus your answer on a positive mindset and the steps that you walked through to turn a potentially hazardous situation into a good one. As well, talk about lessons learned from that situation that you keep with you to this day on the job.
1st Answer Example
"A couple of years ago, we had hired a new Junior Advisor on to our team and I was tasked with being his mentor. Having mentored several other thriving Junior Advisors prior to him starting, I was excited for the opportunity. Within the first week of him being on the job, I overheard a colleague of mine talking very openly about his disdain for the hire of this new Advisor and witnessing him personally criticizing him in a face-to-face encounter. Immediately, I spoke to my colleague in a private office about my concern over his actions and words towards the new Advisor. Having been a part of the interview process and his early mentorship, I knew that he had the skills to succeed and I reiterated that to my colleague. After agreeing to back off on any private criticizing of the new Advisor and a promise to help mentor him, I learned that direct conversations are the best way to handle workplace conflicts."
2nd Answer Example
"f"A couple of years ago, I approached a colleague that had missed a deadline or a big audit we were conducting and she completely blew up at my during our conversation. At first, I was very taken aback by her response because I had never witnessed that from her in many years of working together. While remaining calm, I allowed her the opportunity to vent to me and it turns out that she was going through a lot of things in her personal life that were impacting her work. While keeping our project deadlines in mind, I also took a personal approach in letting her know that she could bring these issues to me as both a colleague and a friend and we could work through them together in the future. This approach is vital to any conflicts that can arise with colleagues and one I don't hesitate to take when needed."
13. If hired for this role at Allan Gray, I want to be sure that I'm hiring a motivated individual. What motivates you in your daily work and your career?
How to Answer
In the financial services field, you should have strong personal motivation to succeed in your work and your interviewer is asking this question to see what it is that make you tick while on the job. While being open and honest in how you stay motivated on the job, make sure that your answer doesn't include collecting a paycheck every week or two. While money is certainly a motivator in this field, make sure that you use it in an appropriate context if you decide to talk about the financial piece of this business as being a motivator. In the end, your interviewer is looking to get a sense of how he or she will be able to keep you hungry for more if you are hired for this role.
1st Answer Example
"I find myself the most motivated on the job when I am being challenged and when I can continue learning new things. From what I've learned in talking to others that currently work here at Allan Gray, the fast paced environment and continuous changes in the industry would keep me very motivated in my work and you'd never have to question if I were truly enjoying and being motivated in my work."
2nd Answer Example
"At a young age, my father taught me to do what I love and love what I do and I know that as I approach the middle years of my career that I made the right career choice. The personal finance field has really blended my love of helping others succeed and my passion for statistics and computers. In this role with Allan Gray, I'll be working with your clients everyday on helping them achieve financial success and that alone is all of the reason I need to get out of bed every morning."
14. How can Allan Gray motivate you on the job?
How to Answer
Every employer should know how each of their employees is best motivated. Talk to the interviewer about the variety of ways in which you are best motivated on the job.
1st Answer Example
"I am best motivated through words of praise and recognition for a job well done. I do like to know that my efforts are noticed. In my current position, we have a leaderboard, and I do like that concept because it creates a healthy bit of personal competition for me as well."
2nd Answer Example
"I am a natural salesperson, so the best way to motivate me is through performance incentives. In my current position, I have been in the president's club for the past three consecutive years. I am highly motivated by the vacation that I am awarded annually."
15. What statistical analysis tools do you have experience working with?
How to Answer
As a successful and resourceful Data Analyst, your interviewer at Allan Gray is expecting you to be knowledgeable and well-versed in the many tools available to you. In your answer, be sure to show diversity within particular programs like SAS and SPSS while also explaining that you are very proficient in Microsoft Excel. On top of the programs, talk about any experience you have with programming and database language like SQL and Python.
1st Answer Example
"In my current role, most of my analysis is handled in SAS and I've really grown to appreciate the program's ability to to manage large data sets and create predictive modeling in the financial field. From a past job, I have experience on SPSS and also with the SQL programming language to build robust databases. Of course, I have received expert level training in Microsoft Excel and consider myself a master of the program."
2nd Answer Example
"Having been in the field for over 15 years, looking back at the technological advancements in the tools that we use is very amazing. I consider myself very fluent in both the Sisense and KISSmetrics programs. I also have a good amount of experience in Crystal Reports."
16. At Allan Gray, we expect our advisors to be available to speak with clients in person, over the phone and through email. What are your experiences in working with clients through different communication methods?
How to Answer
Customer interaction is the name of the game at Allan Gray as they rely on excellent customer to service to retain and grow their client base in a cutthroat market. For this question, your interviewer is looking to get a sense of how you use your communication skills to your advantage in your work and how those skills will benefit Allan Gray. As you answer and talk about your experiences in communication methods, try to show that you thrive on client interactions and have the ability to be both persuasive and trusted with those interactions.
1st Answer Example
"Looking back on my career, I can honestly say that success as an Advisor is really due to my passion for finance and my desire for interactions with other people. Being a people person at heart, I love working with clients in any way possible. My communication style with clients is to get to personally know them so I can relate my advising to them personally. While I definitely prefer to interact with my clients face-to-face, I do have a lot of experience communicating both over the phone and email as well. If hired for this position, you'll see very quickly that I have excellent writing skills."
2nd Answer Example
"As you can see from my resume, I have taken advanced training courses in public speaking and written communication to help further me in this career field. In my early days in finance and making the move to financial advising, communication skills were my area that needed the most professional development. Today, I am confident in my abilities to work one on one with clients directly in person, over the phone or through email and have experience handling clients in all three ways. In my current role, I'd estimate that over 50% of my interactions are through email with the remaining interactions split between face-to-face meetings and phone calls."
17. The clients of a financial firm like Allan Gray can display an arrange of emotions when they work with our Client Services team. How would you handle a situation where a client was very angry?
How to Answer
Whether due to a large amount of money lost on the market or a client feels they were ill-advised by an Advisor, your job as a Client Services Representative will at some point or another deal with a very angry client. For this answer, your interviewer will be looking to hear that you do what is necessary to stay calm and stay focused on finding a resolution. If possible, use a specific example of a time you had to do exactly this and explain how effective communication was critical in making the situation right for the client.
1st Answer Example
"As you can see from my resume, I've spent the last three years in customer service relations for a large insurance company. As you can imagine, a large majority of my customer interactions were with upset customers. I've been called names that I can't repeat here in this interview and my key to working through these situations was to remain calm and not take things personally. Like the financial world, the insurance business is a very life altering experience and a loss or damage to an item is very stressful. I tried to put myself in the customers shoes, see things from their perspective and do my best to ease their situation. In this role with Allan Gray, these same skills would be vital for me to find solutions or the right person to talk to if needed."
2nd Answer Example
"First and foremost, an active listening approach is the first step to lowering the tension from an angry customer. A couple of months ago, we had a very angry customer come onsite to complain about a defective product that cut his hand pretty badly. The customer came onsite to complain even before receiving emergency care, which was apparent that he needed. First, I let him release his anger and it was not a pretty sight. Then I calmly repeated back what he had said and then explained what our policy allowed me to do at that time. Looking back, my sincere approach and calm demeanor helped calm him down and later that day, my manager had a formal complaint sent to the manufacturer and we were assured that they'd be in contact with the customer."
18. Here at Allan Gray, we strive for continuous delivery and continuous deployment with our software. Are you familiar with these processes in your current work?
How to Answer
In the industries that Allan Gray works in, updates to software are vital to end users for them to stay at the forefront of their business. To ensure that updates happen as quick and smoothly as possible, Allan Gray utilizes continuous delivery and continuous deployment for their customers. For this question, talk about what you know about these processes as a software architect, why they are important and what experience you have with them.
1st Answer Example
"In my current role, we utilize a 100% continuous deployment process with our end users when we role out new changes to existing software. We use automated testing in our process to validate that code changes are correct and able to be deployed without issue. Once validated, changes are automatically rolled out to our end users. Having once utilized a continuous delivery system, I am very appreciative of working in an environment utilizing continuous deployment as it negates any need for human intervention in the roll out."
2nd Answer Example
"In my current position, we've slowly grown from a continuous integration process to a continuous delivery process. I love the automated testing process when we are looking at rolling out new changes to existing software and my role as the architect for our projects puts me in the drivers seat for sending out these changes. If hired for this role here at Allan Gray, I'd be very intrigued at learning and working with continuous deployment practices as well."
19. Give me an example of a time that you had to solve a problem without having all of the necessary information at hand to do so. How did you handle that situation?
How to Answer
For this question, your interviewer is looking to test your ability to be analytical and resourceful in a specific situation where you had to dig further to solve a problem. Prior to your interview, try to think of a time in the past where you encountered this specific situation and talk through it by laying out the problem and walking through the step-by-step approach you took to solve the problem. Try to be as detailed you can as you explain how you thought the problem out and worked hard to use the resources you could to help solve the problem. Your interviewer will be relying on these fine details to truly see how you will perform on the job with Allan Gray.
1st Answer Example
"Back when I first joined my current organization, I was taking a role that had been vacant for many months and I had to start with a backlog of work along with the regular daily activities. This customer service role included logging daily visitors and calls and the interim rep only kept brief notes. After taking the time to walk through training and getting running on my own, I realized that the current workload wouldn't allow me to catch up on the backlog of work that had been missed. While I had ideas of how to play catch up on the work, I approached my supervisor with a few ideas and we settled on having me log hours from home on our system as overtime to get caught up. I worked with our IT staff on getting set up on our network from home and was more that willing to help out with some extra hours."
2nd Answer Example
"Working for a large financial institution, our advisory staff help cover for each other when we are on vacation, sick or simply out of office for the day. We typically team up in group of three to help provide coverage for each other. A couple of months ago, I fielded a call from a colleague's client while she was away on vacation and completely out of phone coverage. The client had several questions about their personal finances that I couldn't help resolve off the top of my head. I let them know that their advisor was away on vacation but I would take the next hour to research their questions and get back to them shortly. This was a very acceptable path of action to the client and I took the time to get their questions answered quickly."
20. What do you feel are the primary features and benefits of the Java programming language?
How to Answer
As a company that utilizes Java, Allan Gray and your interviewer want to make sure that you have an understanding of the Java programming language and they do so by asking this question. Obviously a language packed with unique features, talk about the features that you can speak the most knowledgeably about and tie your direct experience to.
Answer Example
"When I started working with Java three years ago, the first huge benefit was the fact that the Java syntax was based on C++. At that time, I had a great working knowledge of C++ and my transition to Java was absolutely seamless. The other amazing feature that I've come to appreciate with Java is how robust the memory management is in exception handling and automatic garbage collection."
21. Why would our clients here at Allan Gray want you to be their financial advisor?
How to Answer
As a professional in financial advising, you know that relationships are built on trust and integrity and for the business at Allan Gray, this is equally important. For your answer, your interviewer will be looking how to hear how you build trust with your clients to ensure that they are customers for life. In your answer, make sure that trust and integrity are common themes as you discuss how you work with each client's individual needs to build their portfolio.
1st Answer Example
"Looking back on my career to this point, I can say with confidence that my success, and the success of my clients, has been due to my ability to build trusting relationships. My path for building a trusting relationship consists of education, communication and action. I educate each client on a personal level, I set expectations for them and deliver on what I say I'm going to do. If hired for this position here at Allan Gray, you'll be hiring a Financial Advisor that will be great at bringing aboard new clients as I have many current clients that I am confident will follow me here."
2nd Answer Example
"Like in any financial advising relationship, confidentiality and integrity are of utmost importance to clients and these are pieces of the relationships with my clients that I hold in the highest regard. My clients know that I can be trusted to safeguard their personal information and use the best resources possible to help make the best decisions for them based on their personal information and situation. I pride myself on the fact that my clients trust me with their personal information and your clients will have this trust in me as well if I'm hired for this position."
22. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
How to Answer
Allan Gray uses indexes to improve query performances within their software and for this question, your interviewer is looking to hear that you have a basic understanding of both clustered and non-clustered indexes. Explain the differences between the two types of indexes and be sure you can either speak to relevant times that you've used each or when would be the appropriate application to use each.
1st Answer Example
"In the simplest of terms, a clustered index order records in a table the way that they are physically stored. There can only be one clustered index per table. Non-clustered indexes do not store data to match the physical order that it is stored. Rather, it can hold up to 249 indexes per table. Both types come with their own benefits over the other. In my experience, clustered indexes are suited best for programs that use primary key as an identity integer column. On the other hand, non-clustered make the most sense for programs that need JOIN and WHERE clauses within them."
2nd Answer Example
"In my experience, clustered indexes are faster to read but very slow when it comes to update data within. Non-clustered indexes are just the opposite in that they are slower to read but much fast to insert new data into them. In my current role, I mostly use clustered indexes when large numbers of rows need to be retreived and when insert operations are important. Most other times, I will use non-clustered as the standard."
23. Our clients here at Allan Gray expect top-tier service and products and we will expect you to do just that in this role. Have you ever went the extra mile for a client when it wasn't expected? Why did you do so?
How to Answer
Allan Gray looks to set themselves apart from their competition by delivering the best service possible in the industry. You, as a customer service professional, are likely used to doing this so in your example, be sure to think about a time where your going above and beyond the call of duty really impacted the overall customer experience. No matter what example you use, be sure to explain why you felt it was important to take that action and what outcomes you are aware that it produced.
1st Answer Example
"A couple of years ago when I was working customer service in retail, a customer was looking for what happened to be a discontinued item of clothing for her sick mother. The easy route would have been to simply look it up, tell her it was discontinued and have her be on her way. What I did was take down the customers contact information and let her know that I could contact our person that handled archived products. If we could track it down, I would be in touch. With a simple phone call, my colleague was able to track the item down from the supplier and have it coordinated to ship directly. We put the customer in direct contact with the supplier and she was as happy as could be. Looking back on that situation, I felt that it was the right thing to do given the situation that the customer was in and knowing she was a loyal customer of ours."
2nd Answer Example
"My current role in hospitality often has me working with very high profile customers that come to our hotel. Last year, a touring manager for a musician contacted me regarding and upcoming stay for the musician. I proactively asked for their dining and entertainment preferences and with that list, I was able to work with our catering staff to ensure we had preferred items on the menus for the nights that he stayed and that we had a customized video game package in the musician's room for the his extended stay. Prior to him leaving, his manager reached out to thank me for the great service!"
24. Among the common issues that are faced by Data Analysts in their work, which one or two problems do you feel really challenge analysts in the financial industry?
How to Answer
While the challenges faced by general data analysts makes for a pretty long generalized list, this question is allowing your interviewer the chance to see your critical thinking skills by having you talk about which challenges you feel will be critical in the financial field. While there isn't necessarily a right or wrong answer in this question, make sure that you are able to speak intelligently about your answer and provide ways with how you can meet the challenges in your work with Allan Gray.
1st Answer Example
"From my two years of experience as a Data Analyst in the financial industry, of course the common issues of overlapping data and duplicate entries did come up. But I've found the biggest issue to be the collection and implementation of real-time data to be the biggest hurdle. With markets continually changing on a daily basis, I've had to be diligent about updating reports for my advisors that I work closely with because what may be valid and real one day may be out of date the next."
2nd Answer Example
"Having some very close contacts that are already working in the financial field in data analysis, I understand that manual data tracking can be a pain point due solely to the time needed to complete. Being highly educated in automated processes and utilizing machine learning in other industries, I think the knowledge I could bring to the team here at Allan Gray would really help advance your data analysis practices within my first six months on the job."
25. If you were having an interaction with a client here at Allan Gray and you weren't able to answer their question or solve their problem on your own, how would you handle that situation?
How to Answer
As the forward facing client services representative with Allan Gray, you may be asked serious financial or market related questions that either don't know or aren't qualified to answer. In those situations, you will be expected to explain to the customer how that question will be answered and then deliver a timeline on when it can be answered. In the end, the customer wants to know the clear path to ease their mind and it will be your job to do just that.
1st Answer Example
"In my current role in Customer Service with Metropolis' largest automotive dealership, I frequently get asked questions that our sales, finance and service staff have to give the final stamp of approval on in answering customers questions. In these situations, I have a great amount of knowledge where I can prepare the customer for speaking with the right person while also ensuring them that the sales, finance or service staff will provide the final answer. Then, I work quickly to get them to the right person."
2nd Answer Example
"In a situation where I didn't know an answer, I would ensure the client that we have the right staff in place that would be able to help them quickly and efficiently. I would communicate to the customer what the next step would be and if that would be me putting them directly in contact with someone or me taking their contact information and having someone get back to them. In the end, setting the right course and timeline would be important for every customer when I faced this situation."
26. If a client you were working with here at Allan Gray purchased a large asset, how would you explain to them the impact of that purchase on their financial statements?
How to Answer
When an organization purchases a large scale asset, like new equipment or property, it has an impact on their financial statement. As part of your role working with clients of Allan Gray, your job will be to explain the impact of that purchase on cash flow, income statement and the overall balance sheet. For this question, walk your interviewer through how you would educated clients on large asset purchases to show you have a solid understanding of their impact on the finances of the company.
Answer Example
"I have a great example of this just happening recently with my current organization that purchased a $1,250,000 piece of manufacturing equipment. With our leaders, I explained that since the equipment was purchased in cash without financing, it would directly impact our cash flow statement immediately. On the balance sheet, it ended up being a wash with the cash side going down by $1.25 million and the asset side going up by that same amount with new equipment. The biggest thing that I had to reiterate to leaders was the impact of depreciation on the overall income statement in the coming years."
27. We are looking for the most motivated individuals to join the team here at Allan Gray. Where would you like your career to take you in the next five to ten years?
How to Answer
This common interview question put you in a tough spot where you should talk about your ultimate career goals while also balancing the needs of the position that you are interviewing for and the needs of Allan Gray. Prior to your interviewer, try to research the job and Allan Gray to the point where you can match your career goals with they Allan Gray offers. While your interviewer is looking for a long-term fit for the position they are interviewing you for, it is okay to set your sights higher as long as your goals meet that of the organization's goals. If at all possible during your answer, point out that long-term success with Allan Gray is vitally important to you.
1st Answer Example
"Now that I am to the midway point of my career, I am looking for my next move to be my final move in finding my work home until I retire. As a successful Financial Advisor today, I want to focus on continuing to grow my skills in advising clients on retirement and private wealth management and it sounds like I'll have that opportunity here at Allan Gray. As I continue to grow in my skills and prove my worth to you, a long-term career goal is to be in management where I could oversee the work of Junior Advisors and mentor them towards success."
2nd Answer Example
"A career in risk analysis has been a dream for some time and this opportunity with Allan Gray is really my dream job. If hired here, my goal for the next five to ten years would be to continue to hone my skills and help the work of the department to a point where it is growing and becoming more effective. Down the road, I'm really in a position to be an open book when it comes to where my career with Allan Gray would go from there."