Logo
job logo

Marketing Data Analyst

SGS Consulting, Menlo Park, California, United States, 94029

Save Job

Senior Marketing Analyst, Business Messaging We are seeking a Senior Marketing Analyst with deep expertise in Salesforce and advanced SQL skills to join our Marketing Operations team within Business Messaging Marketing. This role is critical to building and scaling our audience segmentation capabilities, enabling data-driven marketing campaigns that reach millions of customers.

The ideal candidate acts as a bridge between data and marketing strategy. You will be hands‑on in building audience signals and robust data pipelines, but equally focused on analyzing the "why" behind campaign performance, driving experimentation, and providing actionable recommendations to leadership.

Key Responsibilities

Audience Architecture:

Build and maintain audience segments in Salesforce Data Cloud, including signal identification, Calculated Insights (SQL), and activation to SFMC.

Strategic Analysis:

Pull, clean, and analyze large datasets to deliver audience strategy, segmentation, and revenue opportunity sizing. Move beyond descriptive reporting to provide prescriptive recommendations on who to target and when.

Experimentation:

Design, execute, and analyze A/B and multivariate tests (lift studies, holdout groups) to optimize segmentation logic and improve campaign engagement.

Pipeline Development:

Partner with Data Engineers to design and build data pipelines that feed marketing reporting and audience systems.

Performance Measurement:

Develop automated reporting solutions and self‑service dashboards to track campaign performance, focusing on full‑funnel conversion metrics, lead velocity, and attribution.

Data Integrity:

Ensure data quality and troubleshoot data discrepancies across audience and reporting systems.

Stakeholder Collaboration:

Translate business requirements into technical audience definitions and partner with campaign managers on complex builds.

Required Qualifications

7+ years of experience in marketing analytics, data engineering, data science, or a related analytics role.

Expert‑level SQL skills: complex queries, CTEs, window functions, query optimization, and working with large datasets (millions of records).

Strong understanding of

marketing analytics methodologies , including

A/B testing ,

statistical significance , and

cohort analysis .

Hands‑on experience with

Salesforce Data Cloud (or similar CDPs)

including

segment creation ,

Calculated Insights , and

activation workflows .

Experience building audience signals and

audience segments for marketing campaigns.

Proven experience

partnering with Data Engineers

to build and maintain data pipelines.

Strong experience with

report automation : scheduled reports, automated data refreshes, and self‑service dashboards.

Proficiency in

data visualization tools such as Tableau, or similar.

Advanced Google Sheets/Excel

skills.

Basic Python skills

for automation and API utilization.

Excellent communication skills with the ability to translate technical concepts for non-technical stakeholders.

Preferred Qualifications

Experience with

Salesforce Marketing Cloud (SFMC)

and marketing automation workflows.

Experience with

Multi‑Touch Attribution (MTA) modeling and ROI analysis.

Familiarity with

CRM data structures

and account-level data models.

Background in

B2B marketing analytics

(specifically around lead lifecycle and opportunity conversion).

#J-18808-Ljbffr