University of Chicago Financial Analyst Interview Questions
The questions to prepare for a University of Chicago Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.
Use joins and LAG to isolate departments driving a large month-over-month spending variance.
University of ChicagoExplain how to build a monthly variance report using joins, aggregations, CTEs, CASE logic, and month-based date handling.
University of ChicagoCalculate year-over-year awarded grant growth by department using yearly aggregation and a self-join.
University of ChicagoRank University of Chicago departments by year-over-year external research grant growth using CTEs and window functions.
University of ChicagoTests your self-assessment and understanding of university finance responsibilities and demands.
University of ChicagoTests your ability to connect your motivation to the mission and values of an academic institution.
University of ChicagoSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests analytical rigor in separating noise from structural issues in departmental spend.
University of ChicagoTests scenario modeling and your ability to quantify tradeoffs under changing assumptions.
University of ChicagoTests your understanding of core financial planning concepts and how they show up in variance analysis.
University of ChicagoTests variance analysis skills and clear communication of drivers behind budget overruns.
University of Chicago