Candidates describe a Morningstar Data Analyst process that often starts with an aptitude test, followed by two or three technical, manager or HR conversations. Expect finance fundamentals, SQL and Python basics, and behavioral questions.
$78K
Avg. Base Comp
$95K
Avg. Total Comp
3-4 rounds
Typical Rounds
3-4 weeks
Process Length
Most Morningstar Data Analyst candidates describe a screening test followed by two or three conversations. Several report that the aptitude or written test leaned toward finance, with a cut-off score in one case. One candidate was asked to walk through the four financial statements, DCF, bonds, fixed income instruments and derivatives. Others who interviewed for related research-analyst roles were asked about ratios, depreciation, leverage, EPS, and how debt flows through the income statement, balance sheet and cash flow.
The technical content varies across reports. One candidate reported Python and SQL fundamentals: sorting, exception handling, OOP, easy-to-medium DSA, DML queries and finding the second highest value. Another reported a couple of SQL and Python problems in the final round that they called not overly complex. The bar described in these reports is solid fundamentals rather than advanced material.
Behavioral questions appear alongside the technical ones. Candidates mention biggest accomplishments, how colleagues would describe their work style, a time they made a data mistake and fixed it, and navigating cultural differences. One candidate who got an offer was also asked why they wanted Morningstar and what they knew about its lines of business, so prepare a specific answer.
Two practical points stand out. One offer-stage candidate said the interviewers were upfront that the role involves rotational shifts across several time zones, so confirm that works for you. Another candidate who declined said the advertised Data Analyst title turned out to be an operations data-entry role, so ask about day-to-day duties early. Feedback timing was slow in some reports, including nearly three weeks after a final round, so plan for a wait.
Synthesized from 6 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Morningstar process.
I applied for a Data Analyst role and went through what turned out to be a pretty straightforward process, though the outcome depended heavily on how well I'd prepared. The first hurdle was an online aptitude test sent via email—nothing too demanding, mostly testing basic reasoning skills. Once I cleared that, I moved into the actual interview rounds.
The in-person round came next, and this is where things got real. I sat down with the team lead and an associate, and they jumped straight into technical questions. On the Python side, they asked about sorting, exception handling, and some easy-to-medium level DSA problems. I also got questions on OOP concepts and error handling—nothing exotic, but you definitely need to know your fundamentals. The SQL portion covered DML queries and a problem like finding the second highest value, which is a classic for a reason. They also threw in conceptual questions like the difference between tuples and sets, testing whether I actually understood what I was using. Then there were resume and background questions—walk me through your experience, tell me about yourself, that kind of thing.
Honestly, the questions themselves weren't particularly hard. The bar wasn't set at some impossible level. But I realized pretty quickly that the difficulty wasn't the point—it all came down to preparation and confidence. If you know your fundamentals cold, if you can talk through your thinking clearly, and if you've actually reviewed your own resume before sitting down, you're in good shape. I didn't nail it the way I should have, and that's on me for not drilling these basics hard enough beforehand. The staff was genuinely nice and put me at ease, but that only matters if you're ready to perform.
Prep tip from this candidate
Focus on Python fundamentals (exception handling, OOP concepts, sorting logic) and SQL basics (DML queries, window functions like finding nth highest values). These aren't trick questions—they're checking whether you know the basics deeply. Review your resume thoroughly before the in-person round and be ready to explain your background clearly; the technical questions are just the start.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Morningstar
How would you find out if an increase in user conversion rates after a new email journey is casual or just part of a wider trend?
| Question | |
|---|---|
| Digital Marketing Metrics | |
| Why Do We Need Time Series Models? | |
| SageMaker Deployment Architecture | |
| Search Timeout | |
| Your Strengths and Weaknesses | |
| Linear vs Logistic Regression | |
| Empty Neighborhoods | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Comments Histogram | |
| Closest SAT Scores | |
| Employee Salaries | |
| Top Three Salaries | |
| Monthly Customer Report | |
| Button AB Test | |
| Experiment Validity | |
| Last Transaction | |
| Like Tracker | |
| Bagging vs Boosting | |
| Subscription Overlap | |
| Total Spent on Products | |
| P-value to a Layman | |
| Prime to N | |
| Maximum Profit | |
| Cumulative Distribution | |
| Bank Fraud Model | |
| Paired Products | |
| Top 3 Users | |
| Swipe Precision |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report starting with an aptitude or written test. In some reports it was finance-focused, and one described math, English and reasoning sections with a cut-off score. Another candidate called it basic reasoning. Brush up on financial statements, ratios and timed reasoning questions.
Candidates describe a technical and behavioral conversation with a team lead or associate. Topics reported include financial statements, DCF, bonds, derivatives, Python fundamentals, SQL queries, and questions about accomplishments or a data mistake. The mix likely depends on the team and the version of the role.
Several candidates report a manager conversation covering background, teamwork across groups and role-specific finance concepts such as credit ratings or parent and subsidiary companies. One candidate described it as relaxed. Another reported a later round with questions that strayed outside data analysis, so be ready to refocus politely.
Candidates mention an HR discussion about motivation and fit, including why Morningstar and what you know about its business. One candidate said interviewers were upfront about rotational shift requirements. Waits for feedback vary, and one candidate reported nearly three weeks after the final round.
