Senior Data Analyst — Menlo Park, CA

Hybrid, SF, NYC or MPK

Senior Marketing Analyst, Audience Strategy & Insights

Client’s Business Messaging Marketing team is seeking a Senior Marketing Analyst who is both technically deep and business-minded. This role uses expert SQL and large, complex datasets to drive audience segmentation, audience strategy, and revenue opportunity sizing, and translates that analysis into recommendations that shape business, product, and investment decisions. The ideal candidate is comfortable partnering with Data Scientists and Data Engineers to define the data logic and pipelines behind audience and reporting systems, and has a track record of influencing senior leadership with clear, quantified insights.

This is a growth role on the Business Messaging Marketing Analytics team. The primary deliverable is building audience segments within Salesforce Data Cloud, working inside the CRM infrastructure that supports enterprise marketing. Alongside segmentation, the analyst owns audience strategy analysis and revenue opportunity sizing that informs which audiences the business prioritizes. Reporting work will be prominent — largely in Hive and Unidash — and the analyst will partner closely with Data Scientists and Data Engineers on business logic, data models, and pipeline automation so that data no longer needs to be pulled manually.

Responsibilities

• Deliver deep audience analysis, including segmentation, audience, lifecycle and funnel analysis, growth and churn signals, and revenue and adoption attribution. Size revenue opportunities and build the business case for which audiences to prioritize

• Define how a business question should be answered, including what to measure, the methodology to use, and which assumptions apply

• Pull, clean, and analyze large datasets (millions of records) using advanced SQL. Reconcile data across sources and root-cause discrepancies before they reach reporting

• Partner with Data Scientists and Data Engineers to define business logic, data models, and pipelines, and validate what is built

• Build automated reporting and self-service dashboards for recurring business needs

• Translate audience definitions into campaign-ready segments and signals in partnership with campaign and lifecycle owners

• Present findings and recommendations to senior leadership and cross-functional partners

Split roughly 30% hands-on coding/technical work and 70% cross-functional communication.a

Experience: 8+ years in marketing analytics, data science, or business analytics,

Required Education- Bachelor's degree in a quantitative, technical, or business field, or equivalent

Top 3 Must-have HARD skills:

• Expert SQL on large datasets — complex queries, CTEs, window functions, and query optimization against millions of records, including reconciling multi-source data and root-causing discrepancies

• End-to-end audience/customer analysis — segmentation, lifecycle and funnel analysis, revenue opportunity sizing, and quantitative business cases with assumptions clearly stated; hands-on with a CDP (preferably Salesforce Data Cloud) to build and activate segments

• Stakeholder communication and influence — translating complex data into clear direction and recommendations for XFN Marketing, Sales, and partner teams, and presenting to senior leadership

Good to have skills:

• Pipeline building with dbt, Airflow, or equivalent orchestration, plus reporting/BI in a environment (Hive, Unidash) or equivalent

• Salesforce Marketing Cloud and marketing automation workflows; fluency with CRM and account-level data models

• Statistical modeling (propensity, LTV, attribution, forecasting, experiment design) and basic Python for automation and API work

How will performance be measured?

• Ships audience segments on schedule against stated goals

• Delivers a durable logic tree, segment library, and supporting infrastructure

• Produces reports and insights on a monthly cadence, with quantified recommendations leadership can act on

• Eliminates manual data pulls through automation and self-service dashboards

Disqualifiers: Profiles that are purely dashboard/reporting execution without ownership of analysis methodology, or purely consumer/ads-side analytics with no B2B or CRM data exposure, are likely not the right fit. Candidates who cannot write advanced SQL independently should be screened out

Interview Process: 2 Rounds

1. Intro + Technical (30 min) – 15min intro – 15min SQL coding interview

2. Case Interview (30 min) – business case to test their analytics ability – 30 min