Business Analyst

Job Summary

This hybrid day shift role is for 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.

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.

• Demonstrate proven experience as a Business Analyst working with Salesforce Marketing Cloud and Marketing Cloud SFMC delivering requirements analysis process documentation and outcome focused recommendations.
• Show hands on expertise with SFMC Datorama and Datorama configuration creating dashboards managing data streams and interpreting analytical results in ways that drive marketing performance improvements.
• Apply strong proficiency in SQL to extract join and validate data across multiple sources supporting root cause analysis of data issues and creation of robust datasets for reporting and insights.
• Bring solid understanding of Salesforce Data Cloud capabilities including data modeling identity resolution and audience creation to enable precise targeting and measurement of customer interactions.
• Exhibit practical experience with Salesforce Data Integration and broader data integration techniques ensuring that information flows between systems reliably and supports high quality analytics.
• Demonstrate familiarity with data governance principles including data quality management metadata documentation and compliance considerations to maintain trusted and well managed data assets.