Capital Markets Analyst (Financial Modeling & Structured Finance Analyst)

Capital Markets Analyst (Financial Modeling & Structured Finance Analyst)

• Location: Remote (LATAM Preferred)

• Compensation: $2200 - $2800 USD/month (flexible depending on skills)

• Industry: Commercial Real Estate Finance Capital Markets Structured Finance

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

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.

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 modelingand enjoy leveraging tech and automation to optimize workflowsthis role offers the opportunity to work on high-impact transactions that directly support the companys long-term growth.

• 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.

• 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.

• 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.

• Education: Bachelors 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 modeling complex real estate cash flows from scratch.

• Excel Mastery: Absolute Excel wizard capable of handling heavy datasets complex logic nested formulas and dynamic financial scenarios.

• Communication: Excellent written and verbal English communication skills to translate complex quantitative findings clearly.

Candidates with one or more of the following will strongly stand out:

• Engineering / Computer Science Background: Strong quantitative or technical background with an aptitude for system design and algorithmic thinking.

• Technical & Database Tools: Hands-on experience or familiarity with SQL and Power BI for data manipulation and visualization.

• Process Automation: Proven interest or experience in automation (e.g. Python VBA or automated reporting workflows).

• Broad Structured Finance Background: Experience in Asset-Backed Securities (ABS) Mortgage-Backed Securities (MBS) or Real Estate Private Equity.

• CRE Platforms: Experience with tools like CoStar Yardi or Bloomberg.

• Highly Analytical: Meticulous attention to detail; nothing slips past your QA process.

• Naturally Curious: Loves digging into complex financial structures and solving intricate quantitative problems.

• Automation-Minded: Always looking for ways to make models cleaner faster and more automated rather than settling for manual repetitive tasks.

• Independent & Dependable: Takes full ownership of deliverables while managing multiple timelines in a remote setting.

• Clear Communicator: Able to explain complex financial and structural concepts confidently to leadership and cross-functional teams.

The ideal candidate is an absolute Excel powerhouse who takes genuine pride in building and perfecting financial models. You are the person others immediately turn to when a model needs to be built from scratch audited or streamlined.

You blend a sharp understanding of Multifamily Real Estate underwriting with strong Bond Math fundamentals and CMBS knowledge. Rather than just reporting historical numbers you are energized by understanding how complex debt structures function testing stress scenarios and leveraging technology or automation to make analytical processes faster and more accurate.

As our client continues expanding its capital markets platform advanced financial modeling and portfolio analytics are core to its growth this role your work will directly drive securitization activities retained bond valuations and strategic financing decisionspositioning you as the core in-house subject matter expert for capital markets analytics.

Required Experience:

IC