AdTechTalent
finance3 days agoOn-site

The Trade Desk

Sr. Finance Analyst - FP&A

SQLExcelPythonpandasplotlyStreamlitDashPySparkGitLLMmachine learningforecastingfinanceFP&Aautomationdata pipelinesprogrammaticAdTech

Key details

Salary

$94K – $172K

Employment type

Full-time

Seniority

Mid-level

Years experience

3-5

Location

New York, US

Full job description

The Trade Desk seeks a mid-level FP&A professional to bridge Finance and technical teams. Responsibilities include automating finance workflows, developing statistical and machine learning forecasting models, building FP&A tools, partnering cross-functionally, designing data pipelines, and communicating analyses. Required skills include strong SQL, advanced Excel, Python scripting, Git workflow experience, and excellent communication. Preferred experience includes 2-4 years in Analytics, Finance, or AdTech, Python data visualization, lightweight application development, distributed data processing, automation, LLM tools, and programmatic advertising knowledge. Benefits include comprehensive healthcare, retirement plans, disability coverage, life insurance, tuition reimbursement, parental leave, sick and vacation time, paid holidays, stock purchase plans, and variable incentives. Salary range is $93,800 to $172,000 USD. Location: New York, NY.

What you'll do

  • Automate and industrialize finance workflows by converting manual Excel-based processes into reliable, scalable automated pipelines and self-serve tools
  • Develop and operationalize statistical and machine learning models to improve forecast precision, balancing accuracy and explainability
  • Create internal FP&A tools that make analyses repeatable, auditable, and easy to consume by Finance leadership and business partners
  • Partner cross-functionally with Finance teams and technical partners to identify friction, quantify impact, and implement more efficient ways of operating
  • Design and maintain rule-based engines and data pipelines that support forecasting, reporting, and decision workflows
  • Translate analyses and automations into clear narratives and meaningful visuals; communicate recommendations confidently internally
  • Use LLM-powered development workflows (e.g., Claude Code) to accelerate delivery while maintaining quality, security, and auditability

Requirements

  • Strong SQL skills (writing, debugging, and optimizing queries against large datasets)
  • Advanced Excel skills and fluency in common FP&A workflows (structured modeling, reconciliation, scenario analysis)
  • Working Python literacy (ability to write production-quality scripts and notebooks; comfort with packaging, testing, and reproducibility)
  • Experience working in a Git-based workflow (branching, pull requests/code review, version control hygiene)
  • Proven ability to take ambiguous problems and drive them to outcomes, identifying opportunities, scoping work, executing, and iterating
  • Comfort operating in a role with direct financial impact, including attention to controls, data quality, and auditability
  • Excellent communication skills (written and verbal), including the ability to tailor technical detail to the audience
  • 2 - 4 years working experience in Analytics, Finance, or AdTech (preferred)
  • Experience with Python data and visualization tooling such as pandas and plotly (preferred)
  • Experience building lightweight applications for analysts and business users (e.g., Streamlit, Dash, or similar) (preferred)
  • Familiarity with distributed processing and large-scale data (e.g., PySpark) (preferred)
  • Experience implementing agentic workflows and/or automation in a business context (preferred)
  • Comfort using LLM tools (e.g., Claude Code) to speed up development, analysis, documentation, and iteration (preferred)
  • Exposure to programmatic advertising / AdTech concepts (forecasting, seasonality, supply dynamics, fees/take rates, identity, etc.) (preferred)

Tech stack

SQLExcelPythonpandasplotlyStreamlitDashPySparkGitLLM toolsClaude Code

Benefits

Comprehensive healthcare (medical, dental, and vision) with premiums paid in full for employees and dependentsRetirement benefits such as a 401k plan and company matchShort and long-term disability coverageBasic life insuranceWell-being benefitsReimbursement for certain tuition expensesParental leaveSick time of 1 hour per 30 hours workedVacation time for full-time employees up to 120 hours through the first year and 160 hours thereafterAround 13 paid holidays per yearEmployee Stock Purchase Plan allowing purchase of company stock at a discountVariable compensation-based incentives and commissions depending on roleStock-based compensation grants based on company and individual performance

Apply now

This MVP uses a placeholder application flow. In production, this section can connect to an external apply URL or a native application form.

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.