Sr. Technical Analyst - Fp&a

The Trade Desk The Trade Desk · Media · New York, NY · Financial Planning and Analysis

This role is within FP&A and bridges Finance and technical teams. It focuses on modernizing and automating finance workflows, improving forecast accuracy using statistical and ML approaches, and building tooling for better decision-making. The role involves automating manual processes, developing and operationalizing models for forecasting, creating internal FP&A tools, partnering cross-functionally, designing data pipelines, and using AI tooling responsibly for development acceleration.

What you'd actually do

  1. Automate and industrialize finance workflows: convert manual Excel-based processes into reliable, scalable automated pipelines and self-serve tools.
  2. Forecasting & modeling: develop and operationalize statistical and machine learning models to improve forecast precision, while balancing accuracy and explainability.
  3. Build FP&A tooling: create internal tools that make analyses repeatable, auditable, and easy to consume by Finance leadership and business partners.
  4. Partner cross-functionally: work closely with Finance teams (and technical partners as needed) to identify friction, quantify impact, and implement more efficient ways of operating.
  5. Data pipelines & rules: design and maintain rule-based engines and data pipelines that support forecasting, reporting, and decision workflows.

Skills

Required

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

Nice to have

  • 2 - 4 years working experience as in Analytics, Finance, or AdTech
  • Experience with Python data and visualization tooling such as pandas and plotly.
  • Experience building lightweight applications for analysts and business users (e.g., Streamlit, Dash, or similar).
  • Familiarity with distributed processing and large-scale data (e.g., PySpark).
  • Experience implementing agentic workflows and/or automation in a business context.
  • Comfort using LLM tools (e.g., Claude Code) to speed up development, analysis, documentation, and iteration.
  • Exposure to programmatic advertising / AdTech concepts (forecasting, seasonality, supply dynamics, fees/take rates, identity, etc.).

What the JD emphasized

  • Responsible adoption of AI tooling
  • improve forecast accuracy through statistical and machine learning approaches
  • statistical and machine learning models