28 Institutional Shareholder Services Interview Questions & Answers
Below is a list of our Institutional Shareholder Services, Inc. interview questions. Click on any interview question to view our answer advice and answer examples. You may view 5 answer examples before our paywall loads. Afterwards, you'll be asked to upgrade to view the rest of our answers.
1. If you joined the team here at Institutional Shareholder Services, how would you build relationships with those that you would be working closely with?
How to Answer
For this question, your interviewer will be looking to get the sense that you would be proactive about getting to know your colleagues and fitting into the culture of the organization. Use a personal approach to talk about ways that you have done this in the past and how you would do it if hired for this position. Talk about the importance of relationship building in your line of work and how it helps the overall good of the organization if you take the initiative to do this.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"From my first day on the job, I would take the time to break the ice with my colleagues by introducing myself and setting up an individual meeting with each person. In the past, I've done these meetings over lunch or in an office where I've had questions prepared for me to get to know the person both personally and professionally. I want to ask my colleagues what they expect from me and what I can expect from them. I've found that these conversations really help to open up doors for working with each other moving forward."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"Being the new person on the job can be a very high anxiety time for some people, but I love the opportunity to break the ice with my coworkers by making that first contact. I think it's important to get to know each other on a personal level because we spend so much of our lives together in the workplace and I am a caring person that wants to know how last night's soccer game went for the kids. Beyond that first ice breaking conversation, my work relationships are then bonded through my work ethic and helping others on my team to show that I am a true team player."
2. Think back over your career up to today and tell me about the most difficult day on the job you encountered. What made the day difficult and how did you handle that situation?
How to Answer
We've all had our share of difficult days on the job and how we handle those days in particular can really make or break where our careers go in that position or with that company. Think of a particular day ahead of your interview that really outlines your ability to handle adversity and proves that you were able to handle it with grace rather than turning your uniform in and heading home for the day. Another important piece of your answer should be discussing what lessons you learned from that particular day moving forward that you still carry with you to this day.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"It's funny that you ask this question because I can honestly say that my worst day on the job happened just a few short weeks ago. Upon arriving to work in the morning, I quickly learned that our entire network was down and we wouldn't be able to work within our CRM or other programs that day. Many of my coworkers were visibly upset and questioning how we would be able to do our jobs that day. Rather than joining the crowd and freaking out about the situation, I huddled our group together to talk about solutions to the workday after we found out that the network likely wouldn't be fully up and running until late afternoon. While some colleagues carelessly went home for the day, I helped brainstorm how we could keep our phone lines open and my boss was very grateful for my efforts that day. Looking back, what made this the most difficult for me was seeing how others responded so negatively over an issue that we had no control over."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"Early in my career, I had a day where my entire office came down with the flu and I was left alone with the receptionist for the day. Being trained and working Financial Advisor, my colleagues also handled market analysis, retirement plans and insurance plans. At first, the receptionist and I went about our business. After being flooded with calls and in-person visits into our office, we connected again to talk about a plan moving forward. We discussed what types of calls she could handle and which ones I would handle and she triaged from there. I made contacted with my personal clients I had scheduled that day to reschedule and we worked well from there. If I couldn't answer a question for a client of one my colleagues, I ensured they knew that my colleague would follow up as soon as possible. Looking back, I learned that on days where you have to break routine like we did then that it was important to make a plan as early in the day as possible."
3. What programming languages would you consider yourself fluent in?
How to Answer
While this question gives your interviewer insight into the diversity of your programming language experience, they most importantly want to know that you are adaptable and able to learn on the fly if needed. Talk about the different languages that you consider yourself fluent in and, if possible, do as much research into Institutional Shareholder Services as you can prior to your interview and try to speak to the specific languages that they work with.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"From the start of college, where software engineering grew into a passion for me, I've become very fluent in Java, JavaScript and C++. My current role has me working primarily with C++, but I pride myself on my ability and passion to learn new programming languages and would be able to do so if hired for this role with Institutional Shareholder Services."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"During my training to be an engineer and then in my current role since graduating, a majority of my experience falls within Python. My current role delves deeply into artificial intelligence and Python is awesome with this advanced technology. As I understand it from talking to another engineer here at Institutional Shareholder Services, a requirement would be for me to learn Scala. Though I haven't worked directly with Scala, I believe my experience and willingness to learn would have me up and running in no time if hired for this role."
4. What software programs do you use in your current work and how adaptable would you say that you are in learning and using new programs?
How to Answer
Overall, your interviewer is simply looking to hear that you have a good grasp on programs to use to make you more efficient in your work and to do this, talk open and honestly about the programs that you currently use and talk about in what context that you use them. If at all possible with this role, try to research what additional programs you may have to learn if given this opportunity to join Institutional Shareholder Services and reassure your interviewer that your computer skills are fluent enough to pickup quickly if needed.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"In my current role, I currently use a program called Zendesk that is an interactive customer support tool. When we started to use this tool a little over a year ago, I was very quick to learn and utilize all of the great functions of the program and have since become a trainer for new staff that join our team. As well, I'm very fluent in the entire Microsoft suite of products and would consider myself an expert on the Outlook, Excel and Word programs."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"I consider myself very agile when it comes to using and appreciating the vast amount of software that is available to Financial Advisors today. In my current role, I solely use RightCapital as a financial advising tool with my clients. I really love its ability to help in the budgeting and comprehensive planning processes with my clients. I'm also very familiar with the MoneyGuidePro tool and have used it successfully in the past. If hired for this role, you can consider me an open book when it comes to learning and effectively utilizing any programs needed."
5. What do you feel are the primary features and benefits of the Java programming language?
How to Answer
As a company that utilizes Java, Institutional Shareholder Services 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.
Written by Ryan Brunner on July 17th, 2020
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."
Written by Ryan Brunner on July 17th, 2020
6. Here at Institutional Shareholder Services, we are expecting someone with strong leadership skills to take this role. How would you describe your management style?
How to Answer
Prior to your interview, try to take a long, hard look inside your skills and styles as a leader of others and prepare to present the best management style possible to your interviewer that fits the role that you are interviewing for with Institutional Shareholder Services. Your answer should also involve solid research into the culture of Institutional Shareholder Services and the details of the role you are interviewing for. Some important things to touch on are your ability to promote a team atmosphere and your ability to delegate responsibilities when necessary.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"My overall management style is the belief in building a positive team atmosphere. I'm a firm believer that each person and role brings a specific skill set to the ocverall goals and purpose of a team and I promote a team based atmosphere by larifying everyone's role on the team, keeping every person's objectives clear, rewarding great performers on the team and holding people accountable for their actions. If hired for this role at Institutional Shareholder Services, you can be assured that my promotion of a team based atmosphere would help achieve even higher goals than you have set right now."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"I think that it is crucial for a leader of others to be flexible in their style rather than relying on just one of the canned management styles. I'd like to highlight my abilities to lead as being a manager that works to grow and develop my staff to help them achieve their career goals and a leader who is able to provide direction and authority when the time for it arises. By knowing my team well and promoting our goals, I have the ability to assign work to the right people and follow through with my team on meeting all objective necessary."
7. The day-to-day life at Institutional Shareholder Services can be hectic and stressful at times. If hired for this role, how would you keep yourself motivated when working with stressed colleagues and pushy clients?
How to Answer
The daily life at Institutional Shareholder Services is naturally very fast paced and because of that, both the colleagues and the clients that you may be working with have potential to be stressed, needy and downright mean at times. For this question, your interviewer is looking to get a sense that you would be able to work in this type of environment. In your answer, talk about the fact that you are cognizant of what this job entails as far as personal interactions go and talk about times where you have worked successfully through situations like this in the past. As well, don't hesitate to talk about your own personality traits that help you thrive in these types of situations.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"Being a person that thrives in a fast paced work environment, I have the ability to handle stressed colleagues with a grain of salt. As you can see from my resume, I've spent the last five years in the manufacturing industry where my department worked under tight deadlines all of the time. If I noticed that a colleague was under stress, I offered my help if I was able to and down the road that was usually reciprocated back to me. This unselfish attitude and realizing that someone else's stress wasn't directed at me was the key to maintaining personal health and balance on the job."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"In my current role in client services with a large hospitality group, some days can go off the rails and it feels like I'm working with enraged customers all day long. I have the attitude that their anger isn't directed towards me, but I'm the face of the company that they are currently working with and I need to do my job in helping solve their issue. While I do have great resources at my hand to help solve customer issues, I think that taking the time to get to know all of our management team and how they solve problems is key as well so I know who to put customers in touch with if needed."
8. If hired for this position at Institutional Shareholder Services, what factors would you consider part as part of an organization's long-term liability?
How to Answer
To begin for this question, make sure that you can define a long-term liability as obligations that are due beyond one year and into the future. Then, consider major factors like bonds, mortgages, leases and other items that factor in to an organization's long-term liability. Last, try to explain why the measurement of long-term liabilities are important is an important factor in considering the overall financial health of an organiation.
Written by Ryan Brunner on July 17th, 2020
Answer Example
"While long-term liabilities aren't an immediate issue on a companies working capital, the can become an issue if long-term liabilities pile up too high for some organizations. While often overlooked, items like mortgages, fleet vehicle loans and annuities can add up over time and are always items that I consider when looking at the overall health of an organization."
Written by Ryan Brunner on July 17th, 2020
9. In working with financial data here at Institutional Shareholder Services, what are the steps you would take in the data validation process as part of your work?
How to Answer
Your job as a detailed and proficient Data Analyst requires you to take proper steps in the data validation process to ensure that data used is accurate and clean. Bad data in the financial industry can have a costly impact and your job will be to ensure that doesn't happen. For your answer to this question, discuss the importance and your method for both data screening and data verification as part of the validation process. Also, be sure to talk about any programs that you utilize during the validation process.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"With any large analysis project and performing data validation, my first step is to create a detailed plan for the data needed. This plan will define the required data to be validated and set the way for the remaining steps. The next steps are to validate the information in the database and then the formatting of the data. Finally, prior to validating the data, sampling needs to be done to ensure that a small sample meets the requirements of the project. Being very proficient with many validation programs, I consider myself very proficient in both QuerySurge and Datameer but remain open to learning any new programs here at Institutional Shareholder Services."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"Here at Institutional Shareholder Services, your Financial Advisors rely on the most accurate and up to date data to present to clients and I would take great pride in my job as a Data Analyst to provide the best data possible. To validate data, the two important steps I would take are data screening and data verification. I am very confident in my ability to work with algorithms that screens large sets of data for their accuracy. On top of that, I have worked with a few of the different data verification programs like Experian and Sage Intacct."
10. How long will it take you to make a meaningful contribution to our team at Institutional Shareholder Services?
How to Answer
If you were to be the successful candidate with Institutional Shareholder Services, when do you expect to make a viable contribution to the organization? Talk to the interviewer about your plan to make a fast impact.
1st Answer Example
"I am interested in making an impact on your organization right away and have already crafted a plan to make that happen. I am a very strong business development professional and I plan to take the territory and expand it to include additional rural areas. This should amount to a strong increase in revenue within the first 9 months of my on boarding."
2nd Answer Example
"My plan, if hired by Institutional Shareholder Services, is to make an impact as soon as possible. I have researched this position and am very eager so I have created a 90 day impact plan that I would like to share with you."
11. If hired to this role here at Institutional Shareholder Services, what do you see as one initial hurdle you will have to overcome in your first weeks on the job?
How to Answer
At the heart of this question, your interviewer is asking you to take an honest look inside of yourself to discuss what you feel is the biggest learning curve you will have if offered this position. This will give your interviewer a sense of how to handle your onboarding process if hired for the position and give them a sense that you have the ability to see what your biggest need would be. Similar to the what is your greatest weakness question, the key to answering this question is humbly pointing out a flaw that you may see and making a plan for how you will overcome that flaw.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"Having put a lot of thought into this even before submitting my resume for this position, I realize that my greatest hurdle would be making the leap as an Auditor into the financial focused industry. My five years of experience out of college have been focused on management and technical consulting services, but I feel that I've built a very good knowledge base and experience for this role here at Institutional Shareholder Services. If given the opportunity to join your team, my initial focus would be to get enthralled in auditing in the financial industry and I'd do this by being attached at the hip to my colleagues and taking the time to talk one on one with a lot of other staff to help better understand what they'll expect of me in this role."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"Understanding that my role here at Institutional Shareholder Services would have me working with the entire advisory staff, the first hurdle would be getting to know everyone on that team and showcasing the skills that I could bring to their work. If hired for the job, I would hope to be invited to team meetings where I could introduce myself and my role with the team and I'd invite an open conversation with the entire team."
12. What SDLC models are you familiar in working with?
How to Answer
As a software engineer, you are very familiar with the software development life cycle. For this question, your interviewer is looking to hear what models you have worked on in the past. While there isn't necessarily a right or wrong answer to this question, try to show your flexibility to working with different SDLC models by bringing up your past experiences. Then, show you have knowledge of different models like the waterfall model or agile model. It is also a good idea to use this question as an opportunity for you to learn more about Institutional Shareholder Services by asking your interviewer which model they work off of.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"During my training in software engineering and in my early career, the waterfall model was the standard. In this model, each phase of the development process happens in a set order and projects using this model are easily managed. But over time, as the development projects that I have led have become more complicated and intricate, I have implemented the spiral model. This model has allowed the ability of end users to give feedback early on and often during development and helps to build a more customized product to our customers."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"In my current position with XYZ Company, my department utilizes the agile model in development life cycle. Since our products are so tailored to the needs of our customers, we get a working product very early on in the process and then I work hand in hand with customers to fine tune the software moving forward. It is a very effective model that has built a great reputation for our software among customers. I also have familiarity working with the iterative model and it has similar advantages to the agile model. If I were hired here at Institutional Shareholder Services, can you expand on what models you use here in your software development life cycle?"
13. Data Scientist is a fairly new role here at Institutional Shareholder Services. Why do you feel that you can make the jump into the financial industry as a data scientist?
How to Answer
As finance becomes more heavily reliant on data, the need for well educated Data Scientists is becoming a need at Institutional Shareholder Services. And while your background may not be filled with experience in the financial field, it will be your job to convince your interviewer that you have the skills necessary to be strong Data Scientist while also having some great knowledge of the financial industry. Be open and honest of where your strong point fall and where you feel you have the most to learn while being open to making that progress in the field with Institutional Shareholder Services.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"As you can see from my resume, I have a very strong educational and work background in data science. My work experience in the tech industry has helped me grow in many areas that can be beneficial to the team here at Institutional Shareholder Services. I think that my experience in mining and cleaning raw data, paired with my experience in machine learning, could significantly benefit your clients that are seeking new and improved market data."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"My passion and skills for mathematics and computer science drove me to a career in data science and analysis. Up to today, these skills have driven me to create a brilliant start up company that I sold almost ten years ago and then to a career with a large online retailer. Knowing that the financial industry is growing in data analytics, now is the time to strike when the iron is hot. As I've set out on a career search in the field, I have been greatly impressed by what I have learned about Institutional Shareholder Services and would look forward to help growing the data side of your business."
14. What statistical models are you familiar with and which do you feel would best apply to the financial field here at Institutional Shareholder Services?
How to Answer
Financial Engineers and Quantitative Analysts are relied upon in the financial industry to utilize complex algorithms and math to predict the trading market's immediate future. For this question, your interviewer will be looking to get the sense that you have the skills to apply statistical model in finance by having you talk about the models that are familiar with and have worked with in the past. While being honest about your experiences, be sure to point out that you are aware that some apply more to finance and the market to set yourself apart during this question.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"As a data nerd, I love the realm of statistics and I am very familiar with all of the unique statistical models and how to best apply them to different situations. I've applied linear regression when predicting the outcome based on two historically known data points. I've also applied multivariate models when looking at the distribution of multiple data points. Having dabbled a bit in the market myself and now looking to bring my quantitative analysis skills to the financial field, I am very familiar with the Gaussian model for predicting market changes and would love to bring the knowledge that I have of this model to your team here at Institutional Shareholder Services."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"As you can see from my prior experience in data engineering and financial analysis, I have extensive experience in time series modelling that utilized both univariate and multivariate models. Multivariate time series modelling has proven to be very effective when looking at and predicting the S&P 500 performance and I think my skills in this arena would greatly benefit your team."
15. If you were asked to review a colleague's code that they had written, what key things would you look for?
How to Answer
For this question, your interviewer will obviously be looking to hear that you have adequate knowledge when it comes to coding processes. But most importantly, your interviewer will be looking to gauge your ability to be a team player and focus on the bigger picture when working on a project. In your answer, focus on your attention to detail and your ability to help others when needed.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"As an experienced software engineer, I fully expect my colleagues to reach out to me for my insight and I never hesitate to provide open and honest feedback. When asked to do this, my main focus is ensuring that the code is readable and functional. If there are lines of code that need to be removed, I don't hesitate to let my colleague know that while also giving them feedback on why I feel it is unnecessary."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"When I'm asked to do this in my current position, my main focus is on regulatory requirements that were put in place for the project and security issues. I work with a team of great engineers that are very efficient coders and these two areas are most often overlooked."
16. How would you define what working capital is for a company and what does its measurement mean?
How to Answer
As a Financial Analyst with Institutional Shareholder Services, you will be asked to help measure working capital of organizations. In your definition that you provide to your interviewer, ensure that you give them at least the basic definition of the calculation being current assets minus current liabilities. Then, talk about real situations that you've used the measurement to make critical decisions in the work that you've done in the past. This will confirm with your interviewer that you have the ability to use the measurement in this job.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"In my current role, we measure working capital to gauge the ability of a company to pay off its debts quickly. In working with many industries, from retails to the public sector, the determination of a company's ability to do so based on calculation can differ greatly from industry to industry. To calculate, a range of line items from the company are used to take their current assets minus their current liabilities. In the retail industry, seasonal spikes in business create the need for a much higher working capital and if hired for this role, I have a great understanding of each industries specific needs."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"In a very broad sense, working capital is found by subtracting an organization's current liabilities from their current assets. In my current role, I utilize a more focused calculation of adding accounts receivable plus inventory and then subtracting accounts payable. The more focused calculation give a better idea of total working capital for organizations when trying to get a better overall picture of their health and efficiency when projecting out towards the future."
17. What do you feel is one of the top issues that is faced by data engineers today?
How to Answer
Being in the midst of the greatest technological revolution in the history of man, data engineers face many difficult issues in the work that they perform on a daily basis. While there are many directions that you can go with this question, be sure to focus your answer on something that you can speak passionately about. If you can research a common issue in the industry that Institutional Shareholder Services works in, you may likely score some bonus points with your interviewer.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"Over the past couple of years, I've come to realize that one of the largest issues we face as data engineers is the large amounts of data that are needed to store and then draw information from. Here at Institutional Shareholder Services, I can only imagine how big of an issue that is in the healthcare industry. I have a lot of experience with cloud based data storage and also server based storage."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"In my recent experiences, continuous, real-time integration is an issue that we will face each and every day moving forward. The need for fast paced information is certainly to blame for this. To stay on top of the continuous integration landscape, I am happy to hear that new and improved systems are being created to stay more real-time and up to the minute. Here at Institutional Shareholder Services and working in the financial industry, how have you seen this need for real-time data impact your products?"
18. 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 Institutional Shareholder Services.
Written by Ryan Brunner on July 17th, 2020
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."
Written by Ryan Brunner on July 17th, 2020
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 Institutional Shareholder Services would really help advance your data analysis practices within my first six months on the job."
19. Can you think of a situation where raising debt over equity would be beneficial?
How to Answer
Debt and equity have a very closely bonded relationship with each other in relation to a company's finances. In most situations, raising debt can create too high of an amount of pressure to meet payments versus raising equity. But, there are a few key situations where there is a distinct advantage in raising debt over equity and your interviewer will be looking to hear that you understand at least one of those advantages to be tax shielding, reducing cost of capital and not diluting the stake for investors.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"In the situations where I've advised an organization to increase debt, they've received a distinct advantage in a lower cost form of financing versus equity financing. In the end, this reduced the organization's WACC and came out to be a win for them."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"Last year, I advised a manufacturer to take the debt over equity route when adding a new line of products that was guaranteed to be very profitable. This fact allowed the company to simply and quickly repay the loan plus interest while being able to reap the rewards of the extra profits. In that same case using equity, final profit would've been less."
20. One huge philosophy that we believe in at Institutional Shareholder Services is professional development. How have you worked to develop yourself professionally throughout your career?
How to Answer
In an ever-changing field like financial services, Institutional Shareholder Services knows that professional growth and development is vital to them staying at the forefront of their industry. For this question, your interviewer is looking to ensure that your values surrounding professional development match the values of the company. Use this question as an opportunity for you to highlight the many ways that you grow and develop yourself to be the best that you can be in your career. Highlight any continuing education you have completed, any societies or groups that you belong to and any publications that you read on a regular basis that will prove to your interviewer that you aren't comfortable being stagnant in your career.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"I am a firm believer in being a life long learner in my work as a Data Analyst. As technology and times have changed over the course of time, I see it as very important to be learning and changing along with the times. Just over the past two years, the Data Fest and Data Summit national conferences and participation in these events on a yearly basis is super important to me to help me grow and develop."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"In the financial field, I have to stay at the top of my game to compete with other advisors and keep clients happy and flourishing. To do this, I subscribe to and read many of the great publications that are out there. Some of my favorites include the Wall Street Journal, Money magazine and Forbes. I also subscribe to many others. As well, I am a member of NAIFA and I have attended the organization's Congressional Conference on a few occasions."
21. In your current work, what are the important steps you take in the data validation process?
How to Answer
Depending on your training and your past roles prior to interviewing at Institutional Shareholder Services, you may be familiar with one or two of the many trains of though regarding the steps of a data validation. Whatever formal process you are familiar with, be sure to check the boxes of discussing data screening and data verification as part of your process. Your interviewer will be looking to hear that you check those boxes as they are imperative in the software field.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"As I embark on a data validation process in my current role, my first step is to roadmap a detailed plan to keep on task. I utilize benchmarks and the expectations of key stakeholders as my guide. Once underway, I validate the database and the data formatting to ensure that data is properly screened for its overall health. Then, by finishing with sampling, tests are performed to hopefully show that the data is useful within the system."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"The most important steps in a data validation process are determining the data to sample, scouring the existing database and validating the final data format. My first step is to use my best judgment to determine if I will validate a sample or the entire data set. This determination is based on overall size of the set and the timeframe that I have to work on the project. Then, I take the time to screen data in the existing database to calculate the number of unique ID's and records to come into the system. Last, I have to verify that the source data matches the schema within the targe"
22. How many boxes of macaroni n' cheese were eaten in the United States last year?
How to Answer
er Questions like this during your interview are meant to test your ability to deduce an answer from a very limited set of information and assumptions. You and your interviewer both know that it would be impossible for you to know or even calculate the correct answer, so your interviewer is solely looking for the factors that you use in extrapolating the answer that you give. In your answer, be as detailed as possible in why you are making the assumptions that you are when coming to a final answer.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"In knowing that the population in the United States is around 325 million people, my biggest factors in determining my answer will be that children between the ages of two and ten consume 75% of the mac n' cheese each year and that the other 25% is consumed by ages ten and above. The other factor is that the kids eat one box per week and the ages over ten eat two per month. So, I'll determine that there are 80 millions children between two and ten and figure that they'll eat 4.2 billion boxes. Then I'll determine that there ere 240 million people over ten that eat two per month to get 5.7 billion boxes of mac n' cheese. When added together, I'd say the final answer is right around 10 billion boxes of man n' cheese are eaten in the US each year."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"My estimate of this number would factor in the total US population over three years old, the people that eat macaroni n' cheese to be around 280 million people. Then, I'd factor that in the summer, each person eats one box per week and in other seasons they eat one per month. During the summer, the population would consume 3.4 billion boxes and during the other three seasons, they would consume 2.5 billion between all people. This would add up to right around 6 billion boxes eaten in the United States last year."
23. What qualities do you feel a successful manager should have?
How to Answer
Some great qualities of a manager are:
- Being someone who people naturally want to follow
- Exceptional interpersonal skills
- Strong relationship building skills
- Taking ownership for the team's errors and mistakes
- Excelling at motivating others
- Providing kudos/recognition to your team
- Knowing how to select and hire the right people to join the team
- Having a vision for the future
These are just a few to get started!
Answer Example
"I feel that a successful manager should be patient, strive to be a mentor, and be willing to receive constructive feedback from their team. As a manager, I want to have a team that trusts me and comes to me for professional development and coaching."
24. Have you ever run into a situation where a company had a positive cash flow but was still in critical financial trouble?
How to Answer
At the heart of this question, your interviewer is looking to dive in and take a look at your critical thinking skills. While positive cash flow is usually a very good sign of a company's overall ability to settle its debts and handle future financial challenges, there are some situations where all isn't as it seems when looking at a company with a positive cash flow. Whether you have run into this situation or not, it is important for you to point out that you are aware of situations where a positive cash flow can be misleading.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"If hired for this position, you can rest assured that I know all considerations necessary when looking at cash flow for an organization when determining their overall financial health. A cash flow statement can often show positive cash flow when they take on new cash from loans or long-term debt. While these items do show up as positive on the cash flow, they don't accurately reflect the profitability of the organization."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"I have come across this situation with a company that was selling off a large chunk of inventory. At the same time, the company was delaying their payables. This showed a very skewed positive cash flow but the real story behind the curtains showed a company that was in serious trouble of keeping its doors open."
25. What statistical analysis tools do you have experience working with?
How to Answer
As a successful and resourceful Data Analyst, your interviewer at Institutional Shareholder Services 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.
Written by Ryan Brunner on July 17th, 2020
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."
Written by Ryan Brunner on July 17th, 2020
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."
26. 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
Institutional Shareholder Services 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.
Written by Ryan Brunner on July 17th, 2020
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."
Written by Ryan Brunner on July 17th, 2020
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."
27. Describe to me a time when you made an error in your current or former position, and the impact your mistake made? How did you correct the error, what did you learn from it?
How to Answer
Everyone makes mistakes, and no one is perfect. The interviewer knows that too and is asking this question to see how you handle situations when you make mistakes. Give an example that demonstrates how you took responsibility for your error and fixed it. Also, what you learned from the experience as a result. Sometimes learning from our mistakes allows us to gain some valuable tools.
1st Answer Example
"When I worked as a financial services rep, I accidentally double booked two clients for an appointment in one of the time slots. I realized the mistake after I was double checking my calendar and called the clients right away and apologized for my mistake. As a result of this experience, I always made sure to check the time slots on my calendar twice."
2nd Answer Example
"When starting my current position, I had some struggles with learning Salesforce and let the frustrations get the best of me. I felt like a failure and was ready to give up. Once my boss pulled me aside and reminded me that everyone struggles with brand new technology, I was able to relax. I ended up taking an online course on the program so that I could fast-track my learning and avoid further frustration. What I learned was that only I am responsible for my learning and there are always ways to overcome challenges, if you look for the answers and are prepared to work for them."
28. We pride ourselves on our interdepartmental teamwork here at Institutional Shareholder Services. If hired for this role, what kind of team player could we expect you to be?
How to Answer
In the financial world, teamwork at an organization is the key to success and life at Institutional Shareholder Services is no different. As you talk about your abilities and experiences in being a great team player, try to highlight certain themes like building trust, gaining respect and being a subject matter expert as part of a larger team. Don't hesitate to show flexibility in your ability to both lead others and be lead by others and use examples of times that you've done both. To seal your answer for this question, talk about your desire to work as part of a team and do your research on this position to find out what types of colleagues you will be working with.
Written by Ryan Brunner on July 17th, 2020
1st Answer Example
"My colleagues that I work closely with would tell you that I'm knowledgeable in my area of expertise to contribute to the much larger team and do so without hesitation. As well, I'm able to communicate effectively, take direction and run with when needed and always willing to help out other areas if I have free time. I understand that I would be working very closely with the Advising staff here at Institutional Shareholder Services and know that they would have high expectations out of my work."
Written by Ryan Brunner on July 17th, 2020
2nd Answer Example
"I prefer to work in an environment that promotes teamwork and collegiality. If I were fortunate enough to join the team here, I want you to know that I love being in a leadership type role on a team where I can delegate work and help train others to better the organization. As well, I also thrive in a role where I am the minion and taking direction from others. I'd say that my key skills in working as a team are my ability to friendly, honest and trustworthy with my team."