Financial Data Scientist - Capital Markets

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 Associate, Strategy, New Opportunities & Analytics 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