Dataford
Top 16
Prep plan
Updated weekly · Last refresh Sep 23

ServiceTitan Financial Analyst Interview Questions

The questions to prepare for a ServiceTitan Financial Analyst interview. Questions from real interview reports rank first. Updated daily.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~54 min
Excel Formatting ExerciseMedium

Tests attention to detail and ability to prepare spreadsheets for financial analysis.

excel skillsServiceTitan
Ensuring Data Integrity Across SystemsHard

Tests data validation, lineage awareness, and reliability practices across systems.

data managementdata integrityServiceTitan
Reconciling Discrepant Data SetsMedium

Tests data reconciliation, root-cause analysis, and controls for consistent reporting.

discrepancy handlingServiceTitan
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Rolling Average with SQL WindowsMedium
Practice
Practice drill

Calculate each active RpmGlobal Enterprise Planning user's 30-day rolling average of daily activity.

TavantRpmglobalTwo Six Technologies
SQL Churn After First MonthMedium
Practice
Practice drill

Use monthly cohort logic to find users with no transaction in the calendar month after their first transaction month.

data relationshipsDate FunctionsCTEsServiceTitan
2
Finance & Accounting4 questions · ~32 min
Modeling Churn Impact on ARRHard

Tests SaaS unit economics modeling, sensitivity analysis, and linking churn to ARR outcomes.

Financial AnalysisServiceTitan
Forecasting Revenue for High-Growth SaaSMedium

Tests forecasting methodology, scenario planning, and understanding of SaaS revenue drivers.

ServiceTitan
Building Financial Models From ScratchMedium

Tests modeling rigor, assumptions management, and ability to build decision-ready outputs.

experienceFinancial ModelingServiceTitan
More Finance & Accounting questions with a free account
3
Behavioral & Leadership7 questions · ~56 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Subscription Health MetricsMedium

Tests understanding of SaaS KPIs and ability to translate metrics into business health signals.

ServiceTitan
Cutting 10% of Marketing BudgetHard

Tests strategic tradeoffs, ROI thinking, and stakeholder-ready decision-making.

Decision MakingServiceTitan

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.