Sr. Marketing Data Analyst
Pilot is hiring a Senior Marketing Data Analyst to own its marketing analytics day to day — attribution, channel economics, incrementality testing, and unit economics — partnering with marketing leadership on budget allocation. Stack: Snowflake, dbt, Looker, Marketo, Marketo Measure, Salesforce; hybrid role in San Francisco.
- Compensation
- $126K–$170K / yr
- Location
- San Francisco, CA
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Part time
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- 5+ years in analytics, including owning a business domain and its stakeholder relationships
- Deep marketing analytics experience: channel performance across paid and organic, funnel from lead through closed-won, and unit economics
- Has built or replaced an attribution model and can explain where it breaks down
- Experience designing and reading out incrementality tests (geo, holdout, or comparable), including 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
- Values diversity and fosters inclusion on a team with a wide range of identities and experiences
- Partners with supported teams on the right question rather than taking the request as given
- Drives to find new tools and ways of working and spreads them to uplevel the team and partners
- Takes pride in end-to-end ownership and cares that the numbers are trusted and used
Nice to have
- 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
Full description
The Role
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.
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 solutions.
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.
Location: San Francisco, CA (3 days/week in office—Mondays, Tuesdays, and Thursdays). #LI-Hybrid
Key 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