Welcome to your interview preparation guide. At dv01, a Research Analyst plays a pivotal role in bridging the gap between raw, complex loan-level data and actionable intelligence for the structured finance markets. dv01 operates as the data intelligence hub for the lending ecosystem, bringing unparalleled transparency to markets like consumer unsecured, mortgage, and auto loans. In this role, you are not just crunching numbers; you are uncovering the narratives hidden within billions of dollars of credit data.

The impact of this position is deeply felt across our products, our users, and the broader business. Institutional investors, originators, and banks rely on the insights generated by our research team to make high-stakes investment and risk-management decisions. You will be responsible for identifying macroeconomic trends, analyzing asset performance, and publishing research that establishes dv01 as a thought leader in the structured finance space.

Expect a role that balances deep technical rigor with strategic communication. You will regularly work with massive datasets, write complex queries, and collaborate closely with data engineering and product teams to ensure our platform reflects the most accurate market realities. This is a highly visible, intellectually demanding position designed for candidates who thrive at the intersection of data science, finance, and market research.

The questions below represent the types of inquiries you will face during your interviews. While you should not memorize answers, use these to understand the patterns of what we value: analytical rigor, market intuition, and clear communication.

Technical and Data Manipulation

These questions test your ability to interact with data hands-on. Interviewers want to see that you can write efficient, accurate code to extract the insights you need.

• How would you write a SQL query to find the top 5 originators by total loan volume in the last quarter, excluding loans that defaulted within the first 30 days?
• Explain the difference between a LEFT JOIN and an INNER JOIN, and give an example of when you would use each in the context of loan data.

Preparation is the key to navigating our rigorous evaluation process. To succeed, you should approach your preparation strategically, focusing on both your technical execution and your ability to communicate complex financial concepts clearly.

Our hiring team evaluates candidates against several core criteria:

Technical and Domain Expertise – We look for a strong foundation in data manipulation (SQL, Python, or R) combined with an understanding of structured finance, securitization, and credit markets. You can demonstrate this by fluently navigating complex datasets and applying appropriate financial concepts to your analysis.

Analytical Problem-Solving – This measures how you approach ambiguous, real-world market challenges. Interviewers will assess your ability to break down a high-level research question into testable hypotheses, structure your analysis logically, and draw defensible conclusions from messy data.

Communication and Storytelling – A great Research Analyst must translate quantitative findings into qualitative insights. We evaluate how effectively you can present your research, defend your methodology, and tailor your narrative to both technical and non-technical stakeholders.

Resilience and Execution – Because our work involves deep, complex projects, we look for candidates who can manage their time effectively, handle rigorous peer review, and iterate on feedback. You will need to demonstrate stamina and a strong attention to detail throughout the interview process.

The interview process for a Research Analyst at dv01 is comprehensive, practical, and known to be quite rigorous. You should expect the entire timeline to span several weeks. Our philosophy is rooted in assessing how you actually perform on the job, which means we index heavily on practical, project-based evaluations rather than relying solely on abstract whiteboard questions.

Your journey will typically begin with an initial exploratory conversation with a hiring manager or recruiter to align on your background and mutual expectations. From there, the process quickly transitions into a heavily technical and analytical phase. Candidates consistently report being assigned two distinct, time-consuming take-home projects. These projects are designed to simulate the day-to-day data wrangling and research formulation you will do at dv01.

Following the submission of your projects, you will enter the final onsite (or virtual onsite) stage. This consists of back-to-back interviews with various cross-functional team members you would potentially work with, including data scientists, product managers, and other analysts. During these sessions, you will deeply discuss your project methodology, answer behavioral questions, and explore your alignment with our data-driven culture.

This visual timeline outlines the progression from your initial screening through the intensive project phases and the final back-to-back interview rounds. Use this to plan your preparation schedule, keeping in mind that you will need to block out significant, focused time to complete the two take-home assignments to our standards. Managing your energy across this multi-week process is critical to putting your best foot forward.

To excel in the Research Analyst interviews, you need to understand exactly what our teams are looking for and how they evaluate your skills.

Data Manipulation and Technical Skills

As a Research Analyst at dv01, your ability to extract and manipulate data is foundational. We evaluate your proficiency in writing efficient code to handle large, complex datasets. Strong performance here means writing clean, optimized queries and scripts without needing excessive hand-holding.

Be ready to go over:

• SQL Mastery – Writing complex joins, window functions, and aggregations to extract loan-level metrics.
• Python/R for Data Analysis – Using Pandas, NumPy, or equivalent R libraries to clean, transform, and analyze data.
• Data Visualization – Creating compelling charts and graphs using tools like Matplotlib, Seaborn, or BI platforms to highlight trends.
• Advanced concepts (less common) – Automating data pipelines, interacting with APIs, and basic statistical modeling.

Example questions or scenarios:

• "Write a SQL query to calculate the rolling 3-month default rate for a specific vintage of consumer loans."
• "Walk me through how you would handle missing or anomalous data in a loan tape."
• "How do you optimize a Pandas script that is running too slowly on a dataset of 10 million rows?"

Structured Finance and Market Knowledge

Technical skills alone are not enough; you must understand the context of the data. We evaluate your grasp of credit markets, securitization, and macroeconomic factors. A strong candidate can explain how market events impact loan performance and structured products.

Be ready to go over:

• Securitization Basics – Understanding the lifecycle of a loan, tranches, and asset-backed securities (ABS).
• Credit Risk Metrics – Familiarity with concepts like default rates, prepayments, severities, and loss curves.
• Macroeconomic Indicators – How interest rates, inflation, and employment data affect consumer repayment behavior.
• Advanced concepts (less common) – Specific nuances of mortgage-backed securities (MBS) versus unsecured consumer credit.

Example questions or scenarios:

• "Explain the concept of prepayment risk and how it impacts the yield of an asset-backed security."
• "If the Federal Reserve raises interest rates by 50 basis points, how would you expect our auto loan portfolios to react?"
• "What metrics would you look at to assess the health of a newly issued consumer loan vintage?"

Project Execution and Presentation

Because our interview process features two time-consuming take-home projects, your ability to execute and present your findings is heavily scrutinized. We evaluate your methodology, your attention to detail, and how well you defend your decisions under questioning. Strong performance involves not just getting the "right" answer, but telling a compelling story with the data.

Be ready to go over:

• Hypothesis Generation – How you formulate a research question based on an open-ended prompt.
• Methodology Defense – Explaining why you chose a specific analytical approach or statistical method over another.
• Executive Summaries – Distilling hours of analytical work into a crisp, 5-minute presentation for stakeholders.
• Advanced concepts (less common) – Identifying edge cases or biases in the provided project dataset and proactively addressing them.

Example questions or scenarios:

• "Walk us through the most challenging part of the second take-home project and how you overcame it."
• "Why did you choose to exclude this specific cohort of loans from your final analysis?"
• "If you had an extra week to work on this project, what additional analysis would you conduct?"

As a Research Analyst at dv01, your day-to-day work will be deeply immersive and highly collaborative. Your primary responsibility is to leverage our massive repository of loan-level data to produce actionable research and market commentary. This involves querying databases, cleaning and structuring data, and applying financial models to understand asset performance. You will regularly author reports, whitepapers, and market updates that are distributed to top-tier institutional investors, helping them navigate complex market dynamics.

Beyond independent research, you will act as a critical cross-functional partner. You will work closely with the data engineering team to ensure the integrity of incoming data streams, helping to flag anomalies or shifts in originator reporting. You will also collaborate with the product team, providing subject matter expertise to help design new platform features or analytics tools that better serve our clients.

You will frequently be called upon to support client inquiries and internal strategy. When a major macroeconomic event occurs, you will be on the front lines, quickly analyzing our data to determine the impact on specific asset classes and presenting those findings to both internal leadership and external clients. Your work will directly shape how the market perceives risk and opportunity within the dv01 ecosystem.

To be a competitive candidate for the Research Analyst position at dv01, you must bring a blend of technical capability, financial acumen, and strong communication skills.

• Must-have technical skills – Advanced proficiency in SQL for data extraction; strong programming skills in Python or R (specifically using data manipulation libraries like Pandas/Tidyverse); expert-level Excel skills.
• Must-have domain knowledge – A solid understanding of fixed income, structured finance, or credit risk analytics; familiarity with loan-level data and standard performance metrics (e.g., CPR, CDR, severity).
• Experience level – Typically 2 to 5 years of experience in a quantitative research, data analysis, or structured finance role, often coming from an investment bank, rating agency, or fintech environment.
• Must-have soft skills – Exceptional written and verbal communication skills; the ability to translate complex quantitative findings into clear, concise narratives; a high degree of intellectual curiosity and self-direction.
• Nice-to-have skills – Experience with BI tools (Tableau, Looker); familiarity with version control (Git); prior exposure to specific asset classes like RMBS, auto loans, or consumer unsecured debt.