State of California Financial Analyst Interview Questions
The questions to prepare for a State of California 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.
State of CaliforniaTests ability to investigate and reconcile variances between budget and actual expenditures.
State of CaliforniaUse joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.
HarbourVest PartnersBuild a daily series and compute a 30-day trailing moving average of task bookings using window functions.
TaskRabbit
RBCLay out a practical framework for analyzing budget vs actuals and isolating the main drivers of financial variance.
State of CaliforniaTests analytical approach to identifying cost savings from financial or operational data.
State of CaliforniaSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests ability to evaluate operational impact of budget cuts and identify risk to critical services.
State of CaliforniaTests judgment and decision-making under uncertainty for public program or budget decisions.
State of CaliforniaTests ability to assess persistence of cost drivers for budgeting decisions.
State of CaliforniaEvaluates your foundational knowledge of accounting and budgeting timeframes used in public finance.
State of California