Financial Data Scientist - Capital Markets

Palmetto

• $110K — $130K *
Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a quantitative field (Computer Science, Statistics, Data Science, etc.) with finance exposure
  • 2-4+ years in data analytics, data science, or a similar role in finance or fintech
  • Strong proficiency in Python and SQL, with experience converting Excel models to code
  • Experience with building models and dashboards from complex datasets
  • Familiarity with financial modeling concepts like debt and equity structures
  • Excellent analytical skills and attention to detail
  • Ability to manage multiple projects in a fast-paced environment
  • Strong communication skills for conveying technical insights to non-technical audiences

Responsibilities

  • Mine and analyze diverse data sets to support capital structure decisions
  • Build Python-based analytical tools and dashboards for data interpretation
  • Translate and enhance existing Excel models for scalability in Python
  • Conduct market and competitor analyses using coding techniques
  • Prepare board-level materials connecting data analysis to company strategy
  • Evaluate and structure new capital opportunities based on data-driven insights
  • Support execution of structured finance transactions and due diligence processes

Benefits

  • Collaborative team environment fostering continuous improvement
  • Access to cutting-edge data tools and technologies
  • Opportunity to shape capital decision-making at a growing firm
  • Exposure to executive leadership and strategic discussions
  • Support for professional development in analytics and finance
Full Job Description
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

Similar Jobs

More Jobs at Palmetto

More Finance & Insurance Jobs

Find similar Financial Data Scientist - Capital Markets jobs: