SFMC CRM Analyst: Campaign Automation & Data

MSG Entertainment Holdings, LLC; New York (NY); On-site; USD 65,000 - 110,000; Full time

Job summary

MSG Entertainment is seeking a Salesforce Marketing Cloud Analyst to optimize CRM operations across MSG Entertainment, MSG Sports, and Sphere. You will manage audience segmentation, data pipelines, and automation workflows to support acquisition, engagement, and retention initiatives.

The role requires deep SFMC expertise, strong SQL skills, and experience with CRM data models, APIs, and data governance. You will partner with Marketing, Sales, Data & Analytics, and Technology teams to drive

Qualifications

• 2-4 years of related experience.
• Bachelor’s degree or equivalent combination of education and experience.
• Strong proficiency in Salesforce Marketing Cloud (Automation Studio, Email Studio, Journey Builder, Mobile Connect, Personalization) with at least 3 years administering SFMC.
• Strong proficiency writing complex SQL queries for audience segmentation and data transformation.
• Experience designing and maintaining customer data models and Marketing Cloud data architecture.
• Experience with REST/SOAP APIs, SFTP transfers, ETL processes, and data warehouse environments.

Responsibilities

• Support administration, maintenance, and optimization of Salesforce Marketing Cloud across MSG Entertainment, MSG Sports, and Sphere.
• Design and develop SQL queries, automation workflows, and data pipelines for campaigns and lifecycle management.
• Build scalable audience segmentation strategies using first‑party data and CRM insights.
• Configure and troubleshoot automated journeys, triggered sends, and API integrations.
• Maintain customer data architecture, including Data Extensions and Contact Model relationships.
• Perform QA, deliverability monitoring, and troubleshooting for email and SMS campaigns.
• Develop reusable SQL frameworks, data extracts, and automation processes to improve efficiency.
• Collaborate with Marketing, CRM, Sales, Ticketing, and Analytics teams on scalable solutions.
• Monitor platform health and data quality; identify anomalies and optimization opportunities.
• Create technical documentation and governance standards for data flows and platform usage.
• Suggest enhancements leveraging SFMC features like AMPscript personalization and Einstein.

Skills

Salesforce Marketing Cloud

SQL

HTML/CSS/AMPscript/SSJS/JSON/XML

APIs (REST/SOAP)

Data governance/quality

CRM data models

Email & SMS marketing

Education

Bachelor's degree

Job description

MSG Entertainment is seeking a Salesforce Marketing Cloud Analyst to optimize CRM operations across MSG Entertainment, MSG Sports, and Sphere. You will manage audience segmentation, data pipelines, and automation workflows to support acquisition, engagement, and retention initiatives.

The role requires deep SFMC expertise, strong SQL skills, and experience with CRM data models, APIs, and data governance. You will partner with Marketing, Sales, Data & Analytics, and Technology teams to drive