Sr. Marketing Insights Analyst

San Francisco, CA (Hybrid)

$126K/yr – $170K/yrSenior Level5+ years expFull time

Posted 2 hrs ago

Job Summary

Own attribution and funnel metrics, drive incrementality testing, and build scalable marketing analytics across channels and lifecycle to optimize spend and impact.

  • Own attribution and funnel metrics across channels
  • Lead planning and budget collaboration with marketing leadership
  • Develop the data model, reporting, and dbt-based workflows

Job Description

Responsibilities

  • Own attribution: make campaign-level multi-touch attribution usable and move marketers off Salesforce campaign influence reporting
  • Own channel efficiency at the top of the funnel: cost per lead, per SQL, and per pipeline dollar by channel and campaign group, and recommendations on where to allocate the next dollar
  • Design, run, and report on incrementality tests, including holdout and geo tests
  • Measure brand and event channels: podcast and conference sponsorships, advertorial, webinars, and brand spend. Group channels where a channel-by-channel read is not possible, and use observed lift where a controlled test is not available
  • Own marketing unit economics: LTV, CAC, and CAC payback by segment, cost to serve, and the ideal customer profile for our direct business
  • Build GTM analytics for our new product line as deal volume arrives: lead scoring, closed-lost analysis, and engagement depth
  • Support lifecycle and nurture marketing: measurement for a team that does not source its own leads, and driver analysis on re-engagement
  • Define the marketing data model: the sources, metrics, and models the work depends on. Build them in dbt where you can, and partner with our analytics engineer on ingestion and the heavier platform work
  • Build reporting that marketers can run on their own for campaign and channel performance
  • Partner with marketing leadership in their planning and budget cycles, and take on work outside marketing when the business needs it

Requirements

  • 5+ years in analytics, including owning a business domain and the stakeholder relationships in it
  • Deep marketing analytics experience: channel performance across paid and organic, the funnel from lead through closed-won, and the unit economics on top of it
  • Has built or replaced an attribution model, and can explain where it breaks down
  • Experience designing and reading out incrementality tests, whether geo, holdout, or comparable, including the statistical work in Python or R
  • Designs the comparisons and controls a finding needs, and states plainly what the data does and does not support
  • Strong SQL, and builds reporting in Looker or a comparable BI tool that non-analysts use on their own. Comfortable building and extending models in dbt, or able to pick it up quickly
  • Works directly with executives, including reframing a request that will not answer the underlying question

Preferred

  • Media mix modeling or other top-down measurement experience
  • Marketo and Marketo Measure, or comparable marketing automation and attribution tools
  • Salesforce, including campaign influence reporting
  • Ad platform APIs, PartnerStack, GA, or other spend and engagement sources
  • Brand or offline measurement experience
  • ABM account funnel work
  • Production dbt experience
  • B2B SaaS with both sales-led and self-serve motions
  • Fintech, accounting software, or professional services background

Benefits

  • Flexible vacation/time-off policy
  • All federal holidays are observed
  • Competitive benefits package including additional wellness benefits
  • Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks
  • 401(k) plan
Pilot logo

Pilot

3.4 Glassdoor

Pilot provides the most reliable accounting, CFO, and tax services for startups and small businesses. We partner with thousands of companies to help them grow sustainably and operate more effectively.

Founded in 2016
San Francisco, California, USA
418 employees (21 in marketing)
63% recommend to a friend
69% CEO approval

Salaries

Posted range

$126K/yr – $170K/yr

Taken straight from the job posting.

See all Pilot salaries

Funding

Total Funding
$172.1M
Last Raise
$110.5M
Series Unknown, 4 years ago

Funding History

  • Jan 2022
    Series Unknown
  • Jun 2021
    Secondary Market
  • Jan 2021
    Series C • $110.5M

Traffic Signals

Monthly Visitors
49.2M
Monthly Google Ads Budget
$858.2K
Traffic Source Mix
Search
42.1%
Direct
48.1%
Referral
6.9%
Social
2.7%
Paid
0.3%

Headcount Trend

Current headcount: ~422

Recent News

Pilot logo

Sr. Marketing Insights Analyst

Pilot · San Francisco, CA · Hybrid