Dataford
Top 38
Prep plan
Updated weekly · Last refresh Aug 30

Pennymac Loan Services Business Analyst Interview Questions

The questions to prepare for a Pennymac Loan Services Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

38questions
~5htotal time
Track your progressSign up free to work through all 38 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByPennymac Loan Services
Ensuring Data Integrity on ImportsMedium

Tests your controls for validation, reconciliation, and accuracy during data ingestion in a financial context.

financial dataReconciliationdata integrityPennymac Loan Services
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Find Spending Variance Drivers by DepartmentHard
Practice
Practice drill

Use joins and LAG to isolate departments driving a large month-over-month spending variance.

JoinsData WranglingGroup ByState of CaliforniaUniversity of ChicagoThe Church of Jesus Christ of Latter-day Saints
More SQL & Data Manipulation questions with a free account
2
Execution3 questions · ~24 min
Underwriting Bottleneck ApproachMedium

Tests your problem-solving approach to identifying causes, measuring impact, and proposing improvements in underwriting.

process improvementExecutionPennymac Loan Services
Juggling Multiple ProjectsMedium

Tests prioritization, communication, and execution under competing demands.

Project ManagementPennymac Loan Services
More Execution questions with a free account

Sign up to see every question

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

Get my prep plan
3
Finance & Accounting3 questions · ~24 min
Mortgage Market RiskHard

Tests ability to reason about mortgage market risk relevant to Pennymac Loan Services.

Risk AssessmentPennymac Loan Services
DCF WalkthroughHard

Assesses financial modeling fundamentals and input validation for decision-making.

Financial AnalysisPennymac Loan Services
More Finance & Accounting questions with a free account
4
Behavioral & Leadership24 questions · ~192 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~16 min
Mortgage Rate Risk AnalysisMedium

Tests your understanding of mortgage rate risk and how it affects servicing portfolio performance at Pennymac Loan Services.

Market TrendsBusiness AcumenPennymac Loan Services
Burning String MeasurementHard

Evaluates logical reasoning and problem-solving with incomplete information.

critical thinkingProblem SolvingPennymac Loan Services
The finish line: interview-readyComplete all 38 questions plus 3 hands-on drills to finish this plan.