[Hiring] Salesforce Marketing Cloud Developer @Puzzle Consulting Services

Role Description

We are looking for a detail-oriented and proactive Salesforce Marketing Cloud Developer to support day-to-day marketing operations, campaign execution, data management, and platform maintenance. In this role, you will work closely with the marketing team to manage platform requests, maintain existing workflows, troubleshoot technical issues, and ensure marketing campaigns and customer journeys run accurately and reliably. You will also be responsible for validating audience selections, monitoring automations, maintaining data quality, and following established testing and change-management procedures to protect live production workflows.

This is a hands-on, data-oriented role that combines SQL development, Salesforce Marketing Cloud administration, campaign support, and operational troubleshooting. The ideal candidate is technically capable, organized, proactive, and committed to delivering accurate, well-documented work in a live production environment.

Key Responsibilities

• Salesforce Marketing Cloud Administration and Execution
  • Manage and maintain Salesforce Marketing Cloud data structures, including Data Extensions, subscriber data, and related data models.
  • Support the execution, maintenance, and optimization of marketing campaigns, automations, and existing workflows.
  • Configure, monitor, and troubleshoot automations using Automation Studio.
  • Support customer journey configuration, execution, and maintenance using Journey Builder.
  • Manage audience segmentation, data processing, imports, exports, and related platform activities.
  • Validate audience selection, exclusion criteria, personalization, and workflow logic before campaign or journey activation.
  • Proactively monitor recurring automations, journeys, and data processes.
  • Investigate issues involving SQL queries, automations, data flows, audience selection, and campaign execution.
  • Evaluate the downstream impact of changes to Data Extensions, SQL queries, automations, and journeys.
  • Identify opportunities to improve existing processes and strengthen operational reliability.
• SQL Development and Data Management
  • Write, execute, optimize, and troubleshoot SQL queries to support audience segmentation, data transformation, campaign requirements, and marketing operations.
  • Apply SQL techniques such as joins, aggregations, subqueries, conditional logic, deduplication, and date manipulation.
  • Troubleshoot complex audience selection logic and investigate discrepancies in query results or data processing.
  • Understand relationships between data sources and how Data Extensions support campaign execution.
  • Validate data accuracy, audience counts, exclusion rules, and query results before changes are implemented in production.
  • Maintain organized, accurate, and consistent data structures within Salesforce Marketing Cloud.
  • Document SQL queries, Data Extensions, automations, journeys, and audience selection logic.
  • Follow established data management practices to maintain data integrity.
• Stakeholder Communication and Task Ownership
  • Work directly with marketing team members to understand requests and clarify requirements.
  • Take ownership of assigned requests from initial intake through implementation.
  • Manage assigned work through the team’s ticketing and task management system, Azure DevOps.
  • Communicate proactively when requirements are unclear or technical issues arise.
  • Keep stakeholders informed of progress, blockers, risks, and expected completion timelines.
  • Balance multiple requests and priorities while maintaining accuracy.
  • Collaborate with the Marketing Cloud lead on complex technical or data-related questions.
  • Identify recurring issues, document troubleshooting steps, and recommend process improvements.

Qualifications

• 1–3 years of hands-on experience with Salesforce Marketing Cloud.
• Strong SQL skills, including the ability to write and troubleshoot queries.
• Practical understanding of relational data structures and data management principles.
• Experience working with Salesforce Marketing Cloud Data Extensions and audience segmentation.
• Familiarity with marketing automations, campaign execution, and customer journey workflows.
• Ability to troubleshoot SQL errors, data discrepancies, and automation failures.
• Understanding of data validation and audience exclusion criteria.
• Familiarity with HTML/CSS, AMPscript, JavaScript, SSJS, APIs, or workflow automation technologies.
• Ability to follow established testing, documentation, and change-management procedures.
• Strong written and verbal English communication skills.
• Strong organizational skills, attention to detail, and the ability to manage multiple priorities.
• A proactive mindset and strong sense of accountability.

Preferred Qualifications

• Hands-on experience with Automation Studio and Journey Builder.
• Familiarity with Salesforce Marketing Cloud Email Studio.
• Experience with data imports, exports, file transfers, or API-based data processes.
• Familiarity with Azure DevOps or other ticketing and task management systems.
• Experience supporting marketing teams, CRM operations, or campaign management.
• Understanding of subscriber data, customer data structures, audience segmentation, and marketing exclusion practices.
• Experience documenting technical processes and troubleshooting recurring production issues.
• Familiarity with HTML email development, personalization, or dynamic content in marketing campaigns.

What Success Looks Like

• First 30 Days — Learning and Initial Execution
  • Become familiar with the organization’s Salesforce Marketing Cloud environment.
  • Understand the team’s campaign processes, operational requirements, and task management practices.
  • Learn how existing Data Extensions, SQL queries, automations, and journeys interact.
  • Begin handling straightforward requests and assignments with appropriate guidance.
  • Demonstrate the ability to ask relevant questions and document work.
• Days 31–60 — Increasing Independence
  • Independently manage a growing number of routine Salesforce Marketing Cloud requests.
  • Write and troubleshoot SQL queries and support automations and campaigns with increasing confidence.
  • Validate audience selections and monitor recurring automations.
  • Communicate directly with marketing stakeholders to clarify requirements.
  • Maintain accurate Azure DevOps ticket updates and document technical changes.
• Days 61–90 — Ownership and Consistent Delivery
  • Take ownership of routine Salesforce Marketing Cloud requests from initial intake through completion.
  • Deliver reliable, accurate work while managing competing priorities.
  • Independently troubleshoot common SQL, data, automation, and campaign execution issues.
  • Proactively identify unexpected audience changes and potential risks.
  • Maintain clear documentation of queries, Data Extensions, automations, and journeys.

Benefits

• Competitive Salary: Earn a competitive salary that matches your skills and experience.
• Paid Time Off: Generous time off to support work-life balance.
• Health Insurance: Subsidized private health insurance coverage.
• Annual Salary Reviews: Regular performance-based salary evaluations.
• Training: Paid training and certification opportunities.