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

Nice-to-Have Skills & Pluses

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.

Soft Skills

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

About the Candidate

The idóneo 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.

Why This Role Matters

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.

📌 Capital Markets Analyst (Financial Modeling & Structured Finance Analyst) - 62044632684 (Buenos Aires)
🏢 Somewhere
📍 Buenos Aires