Quanititive Associate, Capital Markets

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

Company Description

Palmetto is a consumer energy platform that provides homeowners with a single destination to discover, purchase, finance, install, monitor and manage home energy products and services. By offering one integrated platform across solar, battery storage, HVAC, heat pumps and more, Palmetto helps homeowners make home energy more affordable, reliable and accessible. Today Palmetto serves hundreds of thousands of homeowners, across 30+ states, building the operating infrastructure for the consumer energy transition, one home at a time.

Our employees are our most valuable resource. We foster a promote-from-within culture that prioritizes talent development, career growth, and purpose-driven work. Palmetto offers a comprehensive benefits package—including unlimited PTO, medical, dental, and vision coverage, paid parental leave, retirement plans, and more—so you can have it all both personally and professionally. Palmetto prioritizes people, planet, and profit—backed by a culture that values collaboration, impact, and balance. Join us in building a brighter, cleaner world.

Location

This position will be based in New York City.

Reporting

This position will report to the Manager, Strategy New Opportunities & Analytics

Summary of Role

The Quantitive Associate, Capital Markets sits at the center of Palmetto Capital's corporate strategy and structured finance team, turning Palmetto's data backlog into the insights that shape capital decisions. The primary focus is strategic and analytical: mining internal and external data to inform financing and capital structure decisions, and translating existing Excel-based models into Python to make analysis faster, more scalable, and more repeatable. This person also supports sourcing of new capital opportunities and contributes to select modeling and transaction execution work, with a sharp eye for detail and a comfort moving between code, data, and financial analysis.

Strategic & Tactical

Data Strategy & Analytics (~70%)

• Mine Palmetto's data backlog — portfolio, financing, operational, and market data — to surface insights that inform capital structure and financing decisions
• Build Python-based analytical tools, models, and dashboards that translate large, complex datasets into clear, decision-ready outputs for senior leadership
• Translate existing Excel-based structured finance models into Python to improve speed, scalability, and repeatability of analysis
• Analyze market, competitor, and macroeconomic trends, using code-driven analysis to inform financing and capital structure decisions
• Contribute to board-level and executive materials that connect data-driven analysis to Palmetto's broader growth strategy
• Assess the company's future capital position and financing needs, incorporating relevant legislative and regulatory data
• Automate recurring financial and operational reporting for key stakeholders, partnering with technology teams to reduce manual effort
• Drive pricing analysis across financing structures and capital products using quantitative, data-driven methods

New Opportunities (~20%)

• Support sourcing and evaluation of new capital opportunities and financing products through data-driven structuring and financial analysis
• Build exploratory Python models to size and stress-test capital structures and financing products that haven't been executed in the market, working in parallel with the team to refine and automate assumptions
• Run scenario and sensitivity analyses, using code-based tools, to pressure-test new structures and identify the optimal capital mix
• Support meetings with prospective investors by preparing data and analysis on new capital opportunities and financing facilities

Modeling & Execution (~10%)

• Support execution of select debt, tax equity, or structured finance transactions, working with banks, investors, and legal counsel as needed
• Maintain and query deal-tracking data across live and prospective financings
• Support due diligence and term sheet review with data pulls and analysis as needed

Collaboration & Continuous Improvement (Ongoing)

• Partner closely with FP&A, Treasury, and Accounting
• Identify and implement improvements to data infrastructure, tooling, and modeling processes
• Stay attuned to the needs of internal stakeholders and capital partners, anticipating data and analytical needs

Qualifications

• Bachelor's degree in Computer Science, Statistics, Mathematics, Data Science, Engineering, or a related quantitative field; coursework or hands-on exposure to finance, economics, or accounting required
• 2-4+ years of experience in a data analytics, data science, quantitative research, or software engineering role, with meaningful exposure to finance, fintech, or capital markets
• Strong proficiency in Python (pandas, numpy, or similar) and SQL; experience translating Excel-based financial models into code strongly preferred
• Experience building models, dashboards, or automated reporting and analysis tools from large, complex datasets
• Working knowledge of financial modeling concepts (debt, equity, tax equity, ABS, or similar structures) a plus
• Strong analytical and quantitative skills, with close attention to detail
• Ability to manage multiple workstreams simultaneously in a fast-paced environment
• Excellent communication skills, with the ability to translate technical analysis for non-technical, senior audiences
• Highly motivated, collaborative, and comfortable operating with some ambiguity

Employment is contingent upon the successful completion of a background check.

Equal Employment Opportunity

Palmetto embraces diversity and is an Equal Employment Opportunity employer. Employment is decided on the basis of qualifications, merit, and business need. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or any other status protected under federal, state, or local law.

To ensure a fair evaluation, we may use AI to assist in sorting applications, but all final decisions are made by our hiring team and no candidate dispositions are automated. We will keep your information on file for four years from the date of your application. For detailed information about how we handle your data and our use of AI, please review our full privacy policy.

For more about our Privacy Policy, visit: https://palmetto.com/privacy-policy