Quantitative Capital Markets Analyst

ArcTern Ventures; New York (NY); On-site; USD 110,000 - 170,000; Full time

Job summary

Palmetto, based in New York City, seeks a Quantitative Associate, Capital Markets to transform data backlog into strategic financing insights. The role centers on building Python-based models and dashboards, translating Excel models, and supporting capital-structure decisions.

You will mine data, analyze macro trends, and contribute to executive materials, while automating reporting and collaborating with FP&A, Treasury, and Accounting.

Qualifications

• Bachelor's degree in a quantitative field; finance exposure preferred.
• 2–4+ years in data analytics, data science, quantitative research, or software engineering with finance exposure.
• Strong Python (pandas, numpy) and SQL; translating Excel-based models into code is preferred.
• Experience building models, dashboards, or automated reporting from large datasets.
• Knowledge of financial modeling concepts (debt, equity, tax equity, ABS) a plus.
• Strong analytical and quantitative skills with attention to detail.
• Ability to manage multiple workstreams in a fast-paced environment.
• Excellent communication skills to translate technical analysis for senior audiences.

Responsibilities

• Mine Palmetto's data backlog to surface insights for capital structure and financing decisions.
• Build Python-based tools, models, and dashboards translating data into decision-ready outputs for leadership.
• Translate Excel-based models into Python to improve speed and repeatability of analysis.
• Analyze market, competitor, and macro trends to inform financing decisions.
• Contribute to board-level materials linking data-driven analysis to growth strategy.
• Automate recurring financial and operational reporting with technology teams.

Skills

Python

SQL

Data analysis

Communication

Education

Bachelor's degree in quantitative field

Tools

Excel

Python

SQL

Job description

Palmetto, based in New York City, seeks a Quantitative Associate, Capital Markets to transform data backlog into strategic financing insights. The role centers on building Python-based models and dashboards, translating Excel models, and supporting capital-structure decisions.

You will mine data, analyze macro trends, and contribute to executive materials, while automating reporting and collaborating with FP&A, Treasury, and Accounting.