Salesforce Marketing Cloud Analyst – Data & Automation

Socket.dev; New York (NY); On-site; USD 65,000 - 110,000; Full time

Job summary

Madison Square Garden Entertainment Corp. (MSG Entertainment) is hiring a Salesforce Marketing Cloud Analyst to administer, optimize, and operate Marketing Cloud across MSG Entertainment, MSG Sports, and Sphere.

You will design data pipelines, manage campaigns, and collaborate with Marketing, Sales, and Data teams to deliver scalable, data-driven marketing solutions. The role emphasizes SQL development, audience segmentation, data governance, and API integrations, with on-site role requirements

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) and Salesforce Sales Cloud with at least 3 years administering SFMC.
• Strong proficiency writing complex SQL queries for audience segmentation, data transformation, automation, and reporting.
• Experience designing and maintaining customer data models, relational data structures, and Marketing Cloud data architecture with CRM data governance and data quality management.
• Experience working with REST APIs, SOAP APIs, SFTP file transfers, ETL processes, and enterprise data warehouse environments.
• Working knowledge of HTML, CSS, AMPscript, SSJS, and JSON/XML for campaign development and personalization.
• Experience supporting email deliverability, SMS messaging, subscriber management, consent management, and customer preference centers.
• Excellent analytical, troubleshooting, and problem-solving skills with ability to identify root causes and implement scalable solutions.
• Strong communication and stakeholder management skills with cross-functional collaboration across Marketing, Technology, Sales, and Data teams.

Responsibilities

• Support the 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 to support campaign execution, audience segmentation, and customer lifecycle initiatives.
• Build and maintain scalable audience segmentation strategies utilizing first-party data, behavioral attributes, transactional data, and CRM insights.
• Configure, monitor, and troubleshoot automated customer journeys, triggered sends, API integrations, synchronized data sources, and scheduled automations.
• Support the maintenance of customer data architecture, including Data Extensions, Attribute Groups, Contact Model relationships, Contact Key governance, and data retention policies.
• Perform campaign QA, validation testing, deliverability monitoring, and troubleshooting to ensure data accuracy and successful deployment of email and SMS communications.
• Develop and maintain reusable SQL frameworks, data extracts, import/export activities, and automation processes to improve operational efficiency.
• Partner with Marketing, CRM, Sales, Ticketing, and Data & Analytics teams to support business requirements through scalable technical solutions and marketing automation workflows.
• Monitor platform health, automation performance, and data quality while proactively identifying anomalies and opportunities for optimization.
• Create and maintain technical documentation, solution architecture diagrams, data flow documentation, naming conventions, and platform governance standards.
• Recommend enhancements leveraging Salesforce Marketing Cloud capabilities, including dynamic content, AMPscript personalization, Einstein features, MobileConnect, and automation best practices.
• Provide exceptional experiences for our guests, partners, and team members, including adherence to appearance and presentation guidelines on-site.

Skills

SFMC admin

SQL queries

Data modeling

APIs

HTML/AMPscript

SSJS/JSON

Education

Bachelor's degree

Tools

REST APIs

SOAP APIs

ETL tools

SFTP

Job description

Madison Square Garden Entertainment Corp. (MSG Entertainment) is hiring a Salesforce Marketing Cloud Analyst to administer, optimize, and operate Marketing Cloud across MSG Entertainment, MSG Sports, and Sphere.

You will design data pipelines, manage campaigns, and collaborate with Marketing, Sales, and Data teams to deliver scalable, data-driven marketing solutions. The role emphasizes SQL development, audience segmentation, data governance, and API integrations, with on-site role requirements