Marketing Data Scientist

SGS Consulting; California City (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

SGS Consulting is seeking an experienced analytics professional to lead audience segmentation and data-driven marketing initiatives. The role focuses on building segments in Salesforce Data Cloud, developing automated dashboards, and partnering with data engineers to ensure robust pipelines feeding marketing reporting and KPIs.

The ideal candidate has extensive SQL experience, strong communication, and the ability to translate business needs into technical definitions for cross-functional teams.

Qualifications

• 7+ years in marketing analytics, data engineering, data science, or related analytics role.
• Expert-level SQL skills: complex queries, CTEs, window functions, large datasets.
• Hands-on Salesforce Data Cloud experience 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, Hive, or similar.
• Advanced Google Sheets/Excel skills; Basic Python skills for automation and API use.
• Excellent communication skills to translate technical concepts for 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 marketing KPIs
• Pull, clean, and analyze large datasets (millions of records) to deliver audience strategy, segmentation, and revenue opportunity sizing
• Ensure data quality and troubleshoot data discrepancies across audience and reporting systems
• Translate business requirements into technical audience definitions and partner with campaign managers on complex builds

Skills

SQL

Python

Audience segmentation

Data storytelling

Cross-functional collaboration

Tools

Salesforce Data Cloud

Tableau

Hive

Job description

Job 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 marketing KPIs
• Pull, clean, and analyze large datasets (millions of records) to deliver audience strategy, segmentation, and revenue opportunity sizing
• Ensure data quality and troubleshoot data discrepancies across audience and reporting systems
• Translate business requirements into technical audience definitions and partner with campaign managers on complex builds

Skills:

• Marketing team - leveraging internal customer data
• Large data set piece - experience
• Need Analyst to help group/map audiences to inform decisions - SQL and python
• Mapping logic
• Build audience segments within data cloud
• Translating super complex ideas - working with XFN and communicating
• Marketing And Analytics (HIVE, unidash or something similar)

Education/Experience:

• 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)
• 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, Hive, 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