Marketing Data Scientist

SGS Consulting; Sacramento (CA); On-site; USD 120,000 - 170,000; Full time

Job summary

SGS Consulting in California seeks a senior marketing analytics professional to lead audience strategy using Salesforce Data Cloud and SQL. You will collaborate with Data Engineers to design data pipelines that feed marketing reporting and audience systems.

Role emphasizes data quality, automated reporting, and scalable dashboards for campaign performance and revenue sizing. Requires 7+ years of experience and strong communication to translate complex ideas for non-technical stakeholders.

Qualifications

• 7+ years in marketing analytics or related data roles.
• Expert-level SQL with complex queries and large datasets.
• Hands-on experience with Data Cloud or similar CDPs.
• Experience building audience signals and campaign-ready segments.
• Proven ability to partner with Data Engineers on pipelines.
• Strong reporting automation and self-service dashboards.
• Excellent communication to translate technical concepts to non-technical stakeholders.

Responsibilities

• Build and maintain audience segments in Salesforce Data Cloud, including signal identification, Calculated Insights (SQL), and activation to SFMC.
• Partner with Data Engineers to design and build data pipelines that feed marketing reporting and audience systems.
• Develop automated reporting solutions and self-service dashboards to track campaign performance and KPIs.
• Pull, clean, and analyze large datasets (millions of records) to deliver audience strategy and revenue sizing.
• Ensure data quality and troubleshoot discrepancies across audience and reporting systems.
• Translate business requirements into technical audience definitions and collaborate with campaign managers on complex builds.

Skills

SQL

Python

Data visualization

Communication

CDP experience

Market analytics

Tools

Salesforce Data Cloud

Tableau

Hive

Excel/Google Sheets

Job description

Job Responsibilities:

Build and maintain audience segments in Salesforce Data Cloud, including signal identification, Calculated Insights (SQL), and activation to SFMCPartner with Data Engineers to design and build data pipelines that feed marketing reporting and audience systemsDevelop automated reporting solutions and self-service dashboards to track campaign performance and marketing KPIsPull, clean, and analyze large datasets (millions of records) to deliver audience strategy, segmentation, and revenue opportunity sizingEnsure data quality and troubleshoot data discrepancies across audience and reporting systemsTranslate business requirements into technical audience definitions and partner with campaign managers on complex builds

Skills:

Marketing team - leveraging internal customer dataLarge data set piece - experienceNeed Analyst to help group/map audiences to inform decisions - SQL and pythonMapping logicBuild audience segments within data cloudTranslating super complex ideas - working with XFN and communicatingMarketing And Analytics (HIVE, unidash or something similar)

Education/Experience:

7+ years of experience in marketing analytics, data engineering, data science, or a related analytics roleExpert-level SQL skills: complex queries, CTEs, window functions, query optimization, and working with large datasets (millions of records)Hands-on experience with Salesforce Data Cloud (or similar CDPs) including segment creation, Calculated Insights, and activation workflowsExperience building audience signals and audience segments for marketing campaignsProven experience partnering with Data Engineers to build and maintain data pipelinesStrong experience with report automation: scheduled reports, automated data refreshes, and self-service dashboardsProficiency in data visualization tools such as Tableau, Hive, or similarAdvanced Google Sheets/Excel skillsBasic Python skills for automation and API utilizationExcellent communication skills with the ability to translate technical concepts for non-technical stakeholders