Morningstar Data Analyst Mock Interview

Practice 40 Morningstar Data Analyst interview questions covering financial data, SQL proficiency, and investment research fundamentals.

Question 1 of 40

Think of a project where you worked with a relatively large data set. Describe the process you took to gather and prepare the data for analysis.

Why the Interviewer Asks This Question
Example Answer
How to Answer
Community Answers

Helen Lee

Helen Lee is a freelance data analyst and writer. She has over 15 years of marketing experience working for companies and clients in financial services, quick-service restaurants (QSR), consumer packaged goods (CPG), and education technology.

Working with large data sets can present challenges, so the Morningstar hiring managers want to know that you have the experience to handle them if they arise. They want to ensure you have encountered challenges in your previous work and learn about the steps you took to overcome them. They are also interested in whether the project you worked on and the impediments you encountered are similar to the ones the Morningstar data analyst team handles.

Helen Lee

"I have had experience working with large data sets delivered to us from outside vendors. These data sets were often survey responses for marketing research projects with large sample sizes. Upon receiving the data set, I checked the validity of the data by running predetermined frequencies and queries. Doing so would often reveal issues, such as missing data, data type issues, and errors in skip patterns within the survey. I would work with the vendor to correct these issues before beginning further analyses of the data. Once we resolved the data issues, I would load the data into a data analysis tool to begin my analysis. Sometimes I would work with a data engineer to load it into an appropriate tool that could handle the size of the data set."

William Swansen

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.

Walk the interviewer through the project you plan to present step-by-step. Share any challenges you might have faced and how you successfully overcame them. If you have been fortunate enough not to face any challenges, stick to the details of your project and the steps you took while working with the data.

Write Your Answer

0 - Character Count

Previous Question Next Question

40Morningstar Interview Questions & Answers

Data Analyst

1.Think of a project where you worked with a relatively large data set. Describe the process you took to gather and prepare the data for analysis.

Data Analyst

2.Can you describe the largest data set you had to work with from a past project? How many rows/entries and columns/variables did the data set include, and what kind of data was included—financial, marketing, operational, etc.?

Data Analyst

3.What tools/software do you have experience using in each phase of a data analysis project—from cleaning/preparing data to data exploration to the final presentation?

Data Analyst

4.Considering all the phases of data analysis, what tools/software work the best for you or do you feel the most comfortable using, and why?

Data Analyst

5.It is likely you will work with Morningstar stakeholders who may have little knowledge of data and databases. Describe a time you found yourself working in a situation such as this—what specific challenges did you face, and how did you deal with them?

Data Analyst

6.Describe an analysis project you worked on where the results were surprising to you and others involved in the project.

Data Analyst

7.Do you have any experience working with statistical models? If so, please describe in as much detail as possible the statistical model you worked on and your role in creating it or using it to answer a business question.

Data Analyst

8.Morningstar, like most large companies, houses its data in multiple data warehouses. In one of your more complex analytical projects, how many data warehouses did you have to query to gather all the required data?

Data Analyst

9.Querying, cleaning/preparing, analyzing, presenting, and communicating findings are some of the main steps in a data analysis project. Of those, which ONE step do you enjoy most?

Data Analyst

10.Describe a project where the stakeholders' questions couldn't be answered due to data limitations. What advice, if any, did you give the stakeholders?

Data Analyst

11.Working as a data analyst gives you a unique perspective on the data and the tools used while working with that data. Have you ever recommended a change to any of the data processes or tools used? Did anything result from your recommendation?

Data Analyst

12.Talk about your knowledge of statistics and how you used this knowledge in your analytical projects.

Data Analyst

13.What scripting language have you used in your past projects as a data analyst? Which are you most confident using?

Data Analyst

14.How many years of SQL programming do you have? In your most recent position as a data analyst, for what percentage of your analytical projects did you utilize your SQL skills?

Data Analyst

15.There are many analytical tools data analysts can include in their toolbox. Excel continues to be a common tool for many. Which Excel functions do you have experience using? Describe in detail how you used Excel for one of your analytical projects.

Data Analyst

16.Do you think creativity is a good skill for a Morningstar data analyst, and if so, how have you used it in your career?

Data Analyst

17.What experience, if any, do you have with web analytics? If you have experience, what tools have you used?

Data Analyst

18.As a data analyst, what skills do you believe are important for working on a Morningstar team with people with different backgrounds and varying roles and responsibilities?

Data Analyst

19.How would you rate your writing skills? How do you use this form of communication as a data analyst?

Data Analyst

20.In your opinion, what soft skills do you believe will be most important in your role as a Morningstar data analyst, and why?

Data Analyst

21.Describe a project in which quantitative and qualitative data were used to conduct your analysis.

Data Analyst

22.Tell me about the audiences to whom you've presented. Were these presentations done in person or remotely?

Data Analyst

23.Of the industries you have worked in, from a data perspective, which industry is most similar to the one in which Morningstar competes?

Data Analyst

24.Describe your experience creating dashboards. If you have experience, what tools have you used to create them?

Data Analyst

25.Which, if any, certifications have you earned related to your career as a data analyst?

Data Analyst

26.Can you explain the difference between data mining and data profiling?

Data Analyst

27.And how do you deal with inconsistencies in your data?

Data Analyst

28.How would you remove the data in a single cell without affecting the formatting when working with an Excel spreadsheet?

Data Analyst

29.Can you briefly explain your primary responsibilities as a data analyst?

Data Analyst

30.What are the steps you take when beginning a new data analysis project?

Data Analyst

31.Can you recall a time you were assigned a task that wasn't part of your job description? How did you handle this, and what was the outcome?

Data Analyst

32.Tell me about an aspect of your profession that makes you the most satisfied, energized, and productive at work.

Data Analyst

33.Can you give me an example of when you had to work with someone difficult to get along with? How did you handle the situation?

Data Analyst

34.Please tell me about a time something major didn't go according to plan at work.

Data Analyst

35.Describe a situation where you needed to persuade someone about an idea or process.

Data Analyst

36.Give me an example of a time you led by example. Describe what you did and how your team reacted.

Data Analyst

37.Tell me about a difficult decision you had to make in one of your previous roles.

Data Analyst

38.Can you recall a time your manager was unavailable when a situation arose that demanded an immediate resolution? How did you react?

Data Analyst

39.When was the last occasion you asked for direct feedback from your manager?

Data Analyst

Morningstar Data Analyst Mock Interview

Think of a project where you worked with a relatively large data set. Describe the process you took to gather and prepare the data for analysis.

40Morningstar Interview Questions & Answers

1.Think of a project where you worked with a relatively large data set. Describe the process you took to gather and prepare the data for analysis.

2.Can you describe the largest data set you had to work with from a past project? How many rows/entries and columns/variables did the data set include, and what kind of data was included—financial, marketing, operational, etc.?

3.What tools/software do you have experience using in each phase of a data analysis project—from cleaning/preparing data to data exploration to the final presentation?

4.Considering all the phases of data analysis, what tools/software work the best for you or do you feel the most comfortable using, and why?

5.It is likely you will work with Morningstar stakeholders who may have little knowledge of data and databases. Describe a time you found yourself working in a situation such as this—what specific challenges did you face, and how did you deal with them?

6.Describe an analysis project you worked on where the results were surprising to you and others involved in the project.

7.Do you have any experience working with statistical models? If so, please describe in as much detail as possible the statistical model you worked on and your role in creating it or using it to answer a business question.

8.Morningstar, like most large companies, houses its data in multiple data warehouses. In one of your more complex analytical projects, how many data warehouses did you have to query to gather all the required data?

9.Querying, cleaning/preparing, analyzing, presenting, and communicating findings are some of the main steps in a data analysis project. Of those, which ONE step do you enjoy most?

10.Describe a project where the stakeholders' questions couldn't be answered due to data limitations. What advice, if any, did you give the stakeholders?

11.Working as a data analyst gives you a unique perspective on the data and the tools used while working with that data. Have you ever recommended a change to any of the data processes or tools used? Did anything result from your recommendation?

12.Talk about your knowledge of statistics and how you used this knowledge in your analytical projects.

13.What scripting language have you used in your past projects as a data analyst? Which are you most confident using?

14.How many years of SQL programming do you have? In your most recent position as a data analyst, for what percentage of your analytical projects did you utilize your SQL skills?

15.There are many analytical tools data analysts can include in their toolbox. Excel continues to be a common tool for many. Which Excel functions do you have experience using? Describe in detail how you used Excel for one of your analytical projects.

16.Do you think creativity is a good skill for a Morningstar data analyst, and if so, how have you used it in your career?

17.What experience, if any, do you have with web analytics? If you have experience, what tools have you used?

18.As a data analyst, what skills do you believe are important for working on a Morningstar team with people with different backgrounds and varying roles and responsibilities?

19.How would you rate your writing skills? How do you use this form of communication as a data analyst?

20.In your opinion, what soft skills do you believe will be most important in your role as a Morningstar data analyst, and why?

21.Describe a project in which quantitative and qualitative data were used to conduct your analysis.

22.Tell me about the audiences to whom you've presented. Were these presentations done in person or remotely?

23.Of the industries you have worked in, from a data perspective, which industry is most similar to the one in which Morningstar competes?

24.Describe your experience creating dashboards. If you have experience, what tools have you used to create them?

25.Which, if any, certifications have you earned related to your career as a data analyst?

26.Can you explain the difference between data mining and data profiling?

27.And how do you deal with inconsistencies in your data?

28.How would you remove the data in a single cell without affecting the formatting when working with an Excel spreadsheet?

29.Can you briefly explain your primary responsibilities as a data analyst?

30.What are the steps you take when beginning a new data analysis project?

31.Can you recall a time you were assigned a task that wasn't part of your job description? How did you handle this, and what was the outcome?

32.Tell me about an aspect of your profession that makes you the most satisfied, energized, and productive at work.

33.Can you give me an example of when you had to work with someone difficult to get along with? How did you handle the situation?

34.Please tell me about a time something major didn't go according to plan at work.

35.Describe a situation where you needed to persuade someone about an idea or process.

36.Give me an example of a time you led by example. Describe what you did and how your team reacted.

37.Tell me about a difficult decision you had to make in one of your previous roles.

38.Can you recall a time your manager was unavailable when a situation arose that demanded an immediate resolution? How did you react?

39.When was the last occasion you asked for direct feedback from your manager?

40.Why did you choose to interview with Morningstar rather than with others in our industry?