Marketing Systems Analyst

Responsibilities Partner with CRM developers, analysts, and marketing stakeholders to capture and document functional requirements for new and enhanced customer marketing capabilities, including loyalty enrollment and engagement, personalized content delivery across email, SMS, web, mobile app, in‑store, and transactional experiences. Collaborate with IT product owners, engineers, and external vendors to support the delivery and activation of marketing experiences across platforms including Salesforce Marketing Engagement and Personalization, Salesforce Service Cloud, Salesforce Commerce Cloud, Salesforce Loyalty, mobile app/Airship, and Salesforce Data 360. Create user stories, acceptance criteria, and functional specifications for marketing system enhancements, and support test case development and execution to validate expected outcomes and enable release sign‑off. Develop, execute, and validate SQL queries against Salesforce Marketing Cloud Data Extensions and Salesforce Data 360 objects to support segmentation, data validation, bulk processing, and data movement. Assist with the configuration, testing, and maintenance of promotional and triggered email and SMS interactions, following established technical patterns and architectural guidance. Support troubleshooting and incident resolution related to marketing automations, journeys, data loads, integrations, and message execution, including validation of counts and expected outcomes. Requirements 1–3 years of experience gathering and documenting business and functional requirements for marketing, CRM, or customer engagement systems. Ability to understand and follow technical standards, data models, and solution patterns defined by senior engineers or architects. Strong attention to detail with a demonstrated ability to reconcile data counts, validate logic, and identify gaps or anomalies. Working knowledge of relational database concepts and hands‑on experience writing SQL for research, testing, validation, and troubleshooting. Clear written and verbal communication skills, with the ability to translate business needs into technical requirements and validation steps. Familiarity with SFMC concepts such as Data Extensions, contact models, subscriber attributes, and Automation Studio activities (imports, queries, exports, SFTP). Experience supporting or testing journeys in Salesforce Journey Builder, including CRM‑based journeys and triggered entry sources. Exposure to REST or SOAP APIs used for marketing or CRM integrations. Basic familiarity with Salesforce Service Cloud or CRM‑based customer and case data. General awareness of marketing and data‑privacy compliance concepts (e.g., unsubscribe handling, consent management, CCPA). #J-18808-Ljbffr