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?

"In the larger companies I have worked at as a data analyst, I have had to work with multiple data warehouses to retrieve the appropriate data. For a particular corporate-wide initiative, I queried against four different data warehouses. Once I retrieved the records and variables I needed, I built one large dataset I worked off of to complete my analysis. Does this sound similar to how Morningstar manages its data?"

The Morningstar interviewer uses this question to determine how you perform the duties required by this job. This specific question gives them an idea of the scope of work you've done in your previous roles. Keep your answer brief and to the point when responding to operational questions. The interviewer will ask you a follow-up question if they need additional information.