AdTechTalent
Data Science2 days agoOn-site

The Trade Desk

Sr. Technical Analyst - FP&A

SQLExcelPythonFP&Aforecastingmachine learningautomationdata pipelinesfinancial modelingGitpandasStreamlitDashPySparkLLMClaude CodeprogrammaticAdTechdata science

Key details

Salary

$94K – $172K

Employment type

Full-time

Seniority

Mid-level

Years experience

3-5

Location

New York, New York, United States

Full job description

The Trade Desk seeks a mid-level full-time FP&A Data Scientist 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 rule engines, data storytelling, and using LLM-powered development workflows. Required skills: strong SQL, advanced Excel, Python scripting, Git workflow experience, problem-solving, financial impact awareness, and communication skills. Preferred: 2-4 years in Analytics, Finance, or AdTech; experience with pandas, Streamlit/Dash, PySpark, automation, LLM tools, and programmatic advertising concepts. Location: New York, NY. Salary range: $93,800–$172,000 USD. Benefits include comprehensive healthcare, 401k with match, disability, life insurance, tuition reimbursement, parental leave, sick and vacation time, paid holidays, stock purchase plan, variable incentives, and stock-based compensation.

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 while 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)
  • Preferred: 2 - 4 years working experience in Analytics, Finance, or AdTech
  • Preferred: Experience with Python data and visualization tooling such as pandas
  • 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.)

Tech stack

SQLExcelPythonGitpandasStreamlitDashPySparkLLM 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.