MarshBerry Financial Analyst interview questions & guide 2026

The following questions reflect patterns observed in previous interview cycles. While the interview process is often described as conversational, you should be prepared to pivot quickly from discussing your background to demonstrating your analytical mindset.

Behavioral & Situational

These questions test your communication style, cultural alignment, and how you handle professional challenges.

• Can you walk us through your resume and your interest in MarshBerry?
• Tell us about a time you had to manage a difficult project or deadline.

Success at MarshBerry requires a blend of technical mastery and clear, professional articulation. You should approach your preparation by focusing on the "why" behind your technical work, not just the "how."

Role-related knowledge – You must be comfortable with core financial concepts, specifically those related to valuation and performance analysis. Ensure your understanding of financial statements is rock-solid, as you will be expected to interpret them during discussions.

Problem-solving ability – Interviewers look for how you break down ambiguous problems. When faced with a case or a hypothetical scenario, articulate your logic clearly, state your assumptions, and explain the steps you are taking to reach a conclusion.

Communication & Influence – As a consultant-facing role, your ability to convey insights clearly is paramount. Practice explaining technical findings in a way that is accessible to clients who may not have a finance background.

Culture fit & Values – MarshBerry values responsiveness, teamwork, and a client-first mindset. Demonstrating that you are a collaborative team player who is genuinely curious about the insurance industry will set you apart.

The interview process at MarshBerry is typically structured to assess both your technical competence and your ability to fit into a collaborative consulting culture. You can generally expect an initial screening with HR, followed by multiple rounds involving members of the consulting and investment banking teams. The process is designed to be thorough, often incorporating practical assessments to verify your skills.

This timeline illustrates the progression from initial screening to potential final-stage assessments. Candidates should interpret this as a multi-week journey that requires consistent energy and follow-through. Be prepared for a mix of behavioral interviews and technical assignments, and use the time between rounds to research the firm’s specific service offerings.

Financial Modeling & Excel Proficiency

This is the bedrock of the role. You are evaluated on your ability to build clean, accurate, and scalable models. Strong performance involves not just getting the "right" answer, but demonstrating a logical, error-free process.

Be ready to go over:

• Best practices for model structure and layout.
• Proficiency with lookup functions, pivot tables, and data validation.
• Sensitivity analysis and how to test model assumptions.

Example scenarios:

• "Build a simple model to project revenue growth based on provided historical data."
• "How would you structure a spreadsheet to track multiple client deliverables?"

Analytical Thinking & Problem Solving

You will be tested on your ability to synthesize information. The firm looks for candidates who can identify patterns in data and provide actionable recommendations.

Be ready to go over:

• How to prioritize tasks when faced with multiple client deadlines.
• Approaches to validating data sources and ensuring consistency.
• Techniques for handling missing or incomplete data.

Example scenarios:

• "How would you approach researching a niche insurance market you know nothing about?"
• "Describe a time you found an error in a report; how did you handle it?"

As a Financial Analyst, your primary responsibility is to support the consulting team in delivering high-quality advisory services. You will spend a significant portion of your time building and maintaining financial models, conducting market research on insurance industry trends, and preparing presentations for client meetings.

You will work closely with senior consultants to draft reports that interpret financial performance, identifying opportunities for growth or efficiency. Because MarshBerry operates in a fast-paced advisory environment, you will often juggle multiple projects, requiring you to communicate status updates clearly and manage your time effectively across different client engagements.

A successful Financial Analyst candidate typically possesses a strong academic background in finance, accounting, or economics. You should have a foundational understanding of corporate finance and a genuine interest in the insurance industry.

• Must-have skills: Advanced Excel proficiency, strong analytical and quantitative skills, and the ability to synthesize complex financial data.
• Nice-to-have skills: Prior experience in investment banking, consulting, or an internship within the insurance/financial services sector.
• Soft skills: Exceptional verbal and written communication, a proactive problem-solving attitude, and the ability to work effectively in a team-oriented, client-facing environment.

Q: Is the interview process mostly technical or behavioral? A: It is a balanced mix. While you will be tested on your financial knowledge and technical skills (often through an assessment), the firm places a high premium on your personality, communication style, and cultural alignment.

Q: How long does the process usually take? A: The process can vary, but candidates should expect a multi-week timeline. It is important to maintain regular communication with your recruiter throughout the process to stay informed.

Q: What is the best way to prepare for the Excel assessment? A: Practice building clean, logical models from scratch. Focus on efficiency, keyboard shortcuts, and ensuring your formulas are robust and easy for others to audit.

Q: Does MarshBerry value previous insurance experience? A: While it is not a strict requirement, showing an interest in the insurance industry and an understanding of its unique economic drivers will significantly differentiate you from other candidates.

• Research the firm's recent work: Look into the types of advisory services MarshBerry provides. Being able to discuss their recent industry insights will show you are genuinely interested in the firm.
• Prepare your "Why": Be ready to explain why you want to work in consulting specifically, and why MarshBerry is your firm of choice.
• Clarify your assumptions: If given a case study, always state your assumptions clearly before diving into the math. It shows you think before you act.
• Be responsive: The firm values responsiveness in its consultants. Treat your email communications with your recruiter as a reflection of your professional habits.

The Financial Analyst role at MarshBerry offers a unique opportunity to gain deep exposure to the insurance industry while honing your financial modeling and advisory skills. By focusing on your technical foundations, practicing clear communication, and demonstrating a proactive, team-oriented mindset, you will be well-positioned to succeed.

Preparation is key. Review your financial fundamentals, sharpen your Excel skills, and ensure you can articulate your interest in the firm’s specific service areas. You have the potential to make a meaningful impact at MarshBerry, and with focused effort, you can navigate the interview process with confidence.

The provided compensation data reflects industry standards for this role. Use these figures to gauge the market and ensure your expectations align with the firm’s offer structure, keeping in mind that total compensation may include performance-based components.