Dice is a recruitment company seeking a Salesforce Data & Analytics Consultant to optimize Salesforce and Marketing Cloud Engagement data. The role involves ensuring data integrity, developing advanced analytics solutions, and driving data-informed decision-making to enhance business insights and operational efficiency.
Responsibilities:
- Ensure Data Accuracy: Conduct ongoing audits to validate data integrity in Salesforce CRM and Marketing Cloud
- Resolve Data Issues: Work with integration teams to correct inconsistencies across Salesforce, Marketing Cloud, and external data sources
- 360 Data Model: Unify data from Salesforce, Marketing Cloud Engagement, external CRMs, and enterprise sources to build a 360-degree customer intelligence data model
- Data Governance: Define and enforce best practices for data security, structure, and quality
- Performance Optimization: Optimize dataflows, datasets, and queries to improve reporting efficiency
- Develop Interactive Dashboards: Create CRM Analytics dashboards that provide real-time insights into business performance
- Marketing Campaign Analytics: Analyze Marketing Cloud Engagement Journeys, Email & SMS Campaign Performance, and Subscriber Activity to optimize customer engagement
- Advanced Data Modeling: Use SAQL, SOQL, and JSON to develop custom queries and advanced visualizations
- Automate Reporting: Implement scheduled data refreshes, alerts, and predictive analytics in Salesforce
- Gather Business Requirements: Work with stakeholders to identify KPIs and reporting needs
- User Enablement & Training: Educate teams on self-service reporting, data interpretation, and best practices
- Cross-Department Collaboration: Align Salesforce analytics with development, marketing, sales, communication, and operations teams
- Drive Data-Driven Culture: Champion the use of analytics, automation, and AI-powered recommendations to improve operational efficiency and business outcomes
- Continuous Improvement: Continuously explore new Salesforce AI capabilities (e.g., Einstein GPT, Data Cloud, and predictive modeling) to future-proof analytics strategies
Requirements:
- 5+ years of experience in Salesforce Analytics, Business Intelligence, or Data Consulting
- Salesforce Certified CRM Analytics & Discovery Consultant
- Expertise in Salesforce data models, security models, and governance
- Experience with SAQL, SOQL, JSON, and declarative reporting tools in Salesforce
- Experience working with Salesforce Marketing Cloud Engagement data, including Journey Analytics & Campaign Performance Reporting (a plus)
- Experience with Education Cloud, Data Cloud, Experience Cloud, or Sales & Service Cloud
- Hands-on experience with ETL tools, API integrations, and middleware platforms
- Data-Driven Mindset: Ability to analyze large datasets and translate them into actionable insights
- Visualization & Storytelling: Expertise in designing engaging, easy-to-understand dashboards
- Problem-Solving: Strong analytical skills to troubleshoot data issues and optimize reporting workflows
- Salesforce Expertise: Deep understanding of Salesforce permissions, security, and reporting best practices
- Cross-Team Communication: Ability to work effectively with both technical and non-technical stakeholders
- Automation & Optimization: Experience with dataflow automation, performance tuning, and data transformation
- Agile Methodology: Familiarity with JIRA, Azure DevOps, or similar tools for managing analytics requests
- Experience with Salesforce Marketing Cloud Engagement data, including Journey Analytics & Campaign Performance Reporting (a plus)
- Power BI, Tableau, SQL, and Python experience is a plus