Senior Marketing Data Analyst

Pilot; San Francisco (CA); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Flexible vacation

Holiday pay

Parental leave 100% pay (12 weeks)

401(k) plan

Wellness benefits

Job summary

Pilot is seeking a Senior Marketing Data Analyst to lead our marketing analytics and enable data-driven decision-making as the company scales. You will own attribution, channel economics, experiments, and incrementality across multiple platforms and products.

The role requires deep SQL skills and experience building dashboards in Looker and dbt-driven data models. Collaborating with marketing leadership and executives, you will guide spend optimization, cross-channel insights, and lifecycle

Qualifications

• 5+ years in analytics with ownership of business domain.
• Experience in marketing analytics and channel performance.
• Strong SQL and data modeling capabilities.
• Experience with dbt and Python or R is a plus.

Responsibilities

• Own attribution modeling and channel efficiency at the funnel top.
• Design, run and report incrementality tests (geo/holdout).
• Measure and optimize marketing unit economics (LTV, CAC).
• Build GTM analytics for product line and enable data-driven decisions.

Skills

SQL

Experimentation

Incrementality testing

Data storytelling

Tools

dbt

Looker

Snowflake

Marketo

Marketo Measure

Salesforce

Job description

• Pilot is hiring a Senior Marketing Data Analyst to own our marketing analytics and uplevel our data-driven decision-making as we embark on the fastest-growing and quickest-evolving time in our company’s history
• Pilot has spent years providing reliable back office services to over 3,000 businesses so they can focus on running their business
• This year we announced our AI accounting platform, Meridian, and it has quickly become an industry leader because it was built with the nearly a decade of experience Pilot has building a platform for accountants and providing high quality accounting services
• While this new product is exciting, it comes with a plethora of new complexity as we strive to grow our current back office services while also rapidly growing our AI platform clientele
• Marketing is the biggest single driver of our revenue and is our largest spend line. With Meridian, our marketing motion is rapidly changing: more events, more brand investment, and more channels. With this, attribution, tracking, and reporting get harder and harder but more and more important. We need someone experienced and knowledgeable in the domain to lead our analytics to where it needs to go
• As a Senior Marketing Data Analyst, you will work closely with the marketing team and company leadership to own marketing analytics across attribution, channel economics, experimentation, and incrementality. You will identify which channel dollars are paying off and how we should reallocate our budget to maximize revenue efficiency. Most importantly, you will own closing the gap between us being data-informed and having a data-driven marketing engine
• Pilot’s data stack is Snowflake, dbt, and Looker, with Marketo, Marketo Measure, and Salesforce on the marketing side. We are active users of Claude Code to make our processes more efficient and our output more prolific
• 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

Benefits

• Flexible vacation/time-off policy
• All federal holidays are observed
• Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks
• 401(k) plan
• Development opportunities & employee happiness initiatives
• Seasoned founding team that has led companies through two prior successful startups and acquisitions (by Oracle and Dropbox)
• Wellness benefits such as Modern Health, Headscape, One Medical, Aaptiv and Rightway

This is a strong fit for someone who strives to turn data and analytics into actionable insights and tangible impact, and who works with high-level leaders not just as a consumer of their data asks, but as a partner in finding the right data solutionsExperience designing and reading out incrementality tests, whether geo, holdout, or comparable, including the statistical work in Python or RDeep marketing analytics experience: channel performance across paid and organic, the funnel from lead through closed-won, and the unit economics on top of itStrong 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 quicklyEven if you don’t have experience with the specific technologies in our stack, we’d love to talk to you!Has built or replaced an attribution model, and can explain where it breaks down5+ years in analytics, including owning a business domain and the stakeholder relationships in itDesigns the comparisons and controls a finding needs, and states plainly what the data does and does not supportWorks directly with executives, including reframing a request that will not answer the underlying questionTakes pride in end-to-end ownership. Cares that the numbers are trusted and used, with a point of view about where the domain should goPartners with the teams they support on what the right question is, rather than taking the request as givenValues diversity and fosters inclusion on a team with a wide range of identities and experiencesDrives to find new tools and ways of working, and spreads them to uplevel the team and the partners they work withAd platform APIs, PartnerStack, GA, or other spend and engagement sourcesProduction dbt experienceMedia mix modeling or other top-down measurement experienceMarketo and Marketo Measure, or comparable marketing automation and attribution toolsBrand or offline measurement experienceSalesforce, including campaign influence reportingABM account funnel workB2B SaaS with both sales-led and self-serve motionsFintech, accounting software, or professional services background