Capital Markets Analyst (Financial Modeling & Structured Finance Analyst) - 62044632684

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

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

• 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: 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 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 strategy. In this role, your work will directly drive securitization activities, retained bond valuations, and strategic financing decisions—positioning you as the core in-house subject matter expert for capital markets analytics.