Capital Markets Analyst

Capital Markets Analyst (Financial Modeling & Structured Finance Analyst)

• Location: Remote (LATAM Preferred)

• Compensation: $2,200 - $2,800 USD/month (flexible, depending on skills)

• Industry: Commercial Real Estate Finance | Capital Markets | Structured Finance

• Schedule: Full-Time | US Business Hours (EST)

About Our Client

Our client is a fast-growing U.S.-based commercial real estate lending platform specializing in private lending, bridge financing, and institutional capital markets. As their lending portfolio continues to expand, they are investing heavily in building sophisticated analytical capabilities to support their securitization and capital markets initiatives.

This is an exciting opportunity to join a high-performing finance team where your analytical expertise will directly influence strategic financing decisions and capital markets activities.

Role Overview

Our client is seeking an exceptional Capital Markets Analyst who is an absolute Excel wizard and genuinely enjoys building sophisticated financial models.

This is not a traditional Financial Analyst or FP&A role focused on budgeting or reporting. Instead, you will become the in-house financial modeling expert supporting securitizations, retained bond analysis, portfolio cash flow modeling, and capital markets analytics. The successful candidate is someone who thrives inside Excel, possesses a deep mastery of Multifamily Real Estate fundamentals and Bond Math, and can build, audit, and manipulate complex financial models with speed, precision, and confidence.

If you are passionate about structured finance, quantitative analysis, and institutional-grade financial modeling—and enjoy leveraging tech and automation to optimize workflows—this role offers the opportunity to work on high-impact transactions that directly support the company’s long-term growth.

Key Responsibilities

Capital Markets & Structured Finance

• Build and maintain sophisticated financial models supporting securitization transactions (with a heavy focus on CMBS and structured real estate debt).

• Apply rigorous Bond Math principles to evaluate yields, pricing, and overall investment performance of retained bonds and structured debt tranches.

• Model loan-level and portfolio cash flows across multiple scenarios.

• Evaluate financing structures and recommend optimized capital solutions.

• Perform sensitivity analysis across interest rates, prepayments, defaults, and other market variables.

Financial Modeling, Analytics & Underwriting

• Serve as an Excel wizard , building complex, dynamic models completely from scratch.

• Perform expert-level cash flow modeling and underwriting for Multifamily Real Estate assets and portfolios.

• Audit and validate existing financial models for accuracy, mathematical integrity, and logic.

• Review assumptions, formulas, and outputs to ensure model reliability for executive decision-making.

• Identify opportunities to introduce automation and process improvements to streamline analytical workflows.

Portfolio Analytics & Cross-Functional Collaboration

• Analyze commercial real estate loan portfolios, with emphasis on Multifamily fundamentals and performance drivers.

• Monitor portfolio performance, key risk indicators, and financial metrics.

• Prepare recurring analytical reports and presentations for senior leadership and institutional investors.

• Partner with leadership, underwriting, servicing, and accounting teams to support capital markets initiatives and new funding opportunities.

Required Hard Skills

• Education: Bachelor’s degree in Finance, Economics, Accounting, Mathematics, Engineering, Computer Science, Statistics, or another quantitative discipline.

• Experience: 3+ years in Capital Markets, Structured Finance, Commercial Real Estate Finance, Investment Banking, Private Credit, or Fixed Income Analytics.

• Domain Expertise:

  • CMBS Exposure: Strong working knowledge and functional understanding of Commercial Mortgage-Backed Securities (CMBS).

  • Bond Math: Solid grasp of fixed income analytics, yield calculations, duration, convexity, and structural cash flow waterfall dynamics.

  • Multifamily Real Estate: Deep understanding of Multifamily fundamentals, key operational metrics (NOI, cap rates, DSCR, LTV), and cash flow drivers.

  • Underwriting & Modeling Expertise: Advanced proficiency in