Sr. Data Analyst, Marketing

Pilot; San Francisco (CA); Hybride; USD 120 000 - 160 000; Plein temps

Résumé du poste

Pilot is seeking a Senior Data Analyst to own marketing analytics and elevate data-driven decision making as we scale our back-office and AI initiatives.

You will work with the marketing team and leadership to drive attribution, channel economics, experimentation, and incrementality, turning data into actionable insights that guide budget allocation and growth strategies.

Qualifications

• 5+ years in marketing analytics or data science.
• Strong SQL and data storytelling skills.
• Experience with marketing tech stack and data pipelines.

Responsabilités

• Own attribution across campaigns and channels.
• Measure channel efficiency and optimize spend.
• Design and run incrementality tests.
• Measure brand and event ROI (sponsorships, webinars).
• Own marketing unit economics (LTV, CAC).
• Build GTM analytics for new product line as deal volume arrives.
• Support lifecycle and nurture marketing analytics.
• Define and evolve the marketing data model and dbt pipelines.
• Create self-serve reporting for marketers.

Connaissances

Marketing analytics

Attribution modeling

Experimentation

Channel economics

Cross-functional collaboration

Outils

Snowflake

dbt

Looker

Marketo

Marketo Measure

Salesforce

Claude Code

Description du poste

Pilot is hiring a Senior 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 clientel

e.
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 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 eng

ine.
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 solut

ions.
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 pro

lific.
Location: San Francisco, CA (3 days/week in office—Mondays, Tuesdays, and Thurs

days).

Key Responsibilities

• bilities
  Own attribution: make campaign-level multi-touch attribution usable and move marketers off Salesforce campaign influence
• reportingOwn 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 ne
• xt dollarDesign, run, and report on incrementality tests, including holdout and
• geo testsMeasure 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
• availableOwn marketing unit economics: LTV, CAC, and CAC payback by segment, cost to serve, and the ideal customer profile for our direct
• businessBuild GTM analytics for our new product line as deal volume arrives: lead scoring, closed-lost analysis, and engagem
• ent depthSupport lifecycle and nurture marketing: measurement for a team that does not source its own leads, and driver analysis on re-e
• ngagementDefine 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 plat
• form workBuild reporting that marketers can run on their own for campaign and channel pe
• rformancePartner with marketing leadership in their planning and budget cycles, and take on work outside marketing when the