Business Analyst

About the Role

This hybrid day shift role requires an experienced Business Analyst with expertise in Salesforce Marketing Cloud platforms, Salesforce Data Cloud, and data integration. The analyst will translate marketing and data requirements into scalable solutions, optimize data governance and reporting, and drive actionable insights using SFMC, Datorama, SQL, and related tools to improve customer engagement and business outcomes across the organization.

Key Responsibilities

• Analyze complex marketing and customer data requirements and translate them into clear solution specifications that optimize how Salesforce Marketing Cloud and Salesforce Data Cloud are used to support business objectives and measurable campaign outcomes.
• Collaborate with cross-functional stakeholders to gather detailed business requirements for data integration and reporting, and convert them into precise user stories and acceptance criteria that guide technical implementation and testing.
• Design and validate end-to-end data flows between Salesforce Marketing Cloud, Salesforce Data Cloud, and other enterprise systems, ensuring that data integration processes are accurate, efficient, and aligned with data governance policies.
• Develop and refine dashboards and performance reports in Datorama that provide stakeholders with actionable insights into campaign effectiveness, data quality trends, and customer behavior metrics.
• Document current and future state data processes and marketing workflows, highlighting gaps, dependencies, and improvement opportunities that enable continuous enhancement of the overall data and analytics ecosystem.
• Coordinate and support system testing, user acceptance testing, and defect resolution for enhancements across SFMC, Datorama, and Salesforce Data Cloud, ensuring that solutions meet required functionality and performance standards.
• Provide clear guidance on data governance practices, including data ownership, data quality rules, access controls, and retention standards, to ensure compliance and trustworthy analytics across marketing initiatives.
• Partner with data engineering and integration teams to refine mapping rules, transformation logic, and scheduling of data loads so that marketing and customer data remains consistent, timely, and ready for analysis.
• Prepare and deliver concise, business-focused analysis summaries that explain complex technical findings from SQL queries, Datorama dashboards, and data cloud models in language that is understandable and actionable for non-technical stakeholders.
• Monitor and evaluate key performance indicators for campaigns and data processes, recommending specific adjustments to segmentation, journeys, and data pipelines that enhance customer engagement and business impact.
• Support continuous improvement by identifying process bottlenecks in marketing operations and data integration, and proposing pragmatic solutions that reduce manual work and increase overall productivity.
• Provide structured training and guidance for business users on how to interpret dashboards, reports, and data definitions so that teams can self-serve insights and make informed decisions more confidently.
• Maintain comprehensive documentation of requirements, solution designs, testing outcomes, and data dictionaries, ensuring that knowledge about Salesforce Marketing Cloud and data integrations is preserved and reusable across future projects.

Requirements & Tech Stack

• Expertise in Salesforce Marketing Cloud platforms.
• Expertise in Salesforce Data Cloud.
• Expertise in data integration.
• Hands-on experience with SFMC.
• Hands-on experience with Datorama (configuration, managing data streams, interpreting analytical results).
• Strong proficiency in SQL (extract, join, validate data, root cause analysis, create robust datasets).
• Solid understanding of Salesforce Data Cloud capabilities (data modeling, identity resolution, audience creation).
• Practical experience with Salesforce Data Integration and broader data integration techniques.
• Familiarity with data governance principles (data quality management, metadata documentation, compliance considerations).

Qualifications

• Proven experience as a Business Analyst working with Salesforce Marketing Cloud and Marketing Cloud SFMC, delivering requirements analysis, process documentation, and outcome-focused recommendations.