Salesforce Marketing Cloud Developer
Puzzle Consulting Services · Brazil
Job Title: Salesforce Marketing Cloud Developer
Type of Employment: Full-Time
Location: Remote - LATAM
About the Role
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.
Beyond technical execution, we are looking for someone who takes ownership of assigned requests, communicates directly with stakeholders, clarifies requirements, and drives tasks through completion. You should be comfortable managing multiple priorities, documenting your work, and independently handling routine requests while collaborating with the Marketing Cloud lead on more complex technical challenges.
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
1. 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 to ensure accurate and reliable customer communications.
Proactively monitor recurring automations, journeys, and data processes to identify failures, unexpected audience changes, and potential communication issues.
Investigate issues involving SQL queries, automations, data flows, audience selection, and campaign execution, escalating complex problems when necessary.
Evaluate the downstream impact of changes to Data Extensions, SQL queries, automations, and journeys within the live production environment.
Assess dependencies, validate changes, and follow established testing and change-management procedures to minimize disruptions to customer communications and existing workflows.
Identify opportunities to improve existing processes, strengthen operational reliability, and make day-to-day marketing activities more efficient.
2. 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 to retrieve, combine, filter, and transform marketing data.
Troubleshoot complex audience selection logic and investigate discrepancies in query results or data processing.
Understand relationships between data sources and how Data Extensions, subscriber records, and other data structures 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 in accordance with established naming conventions and platform standards.
Follow established data management practices to maintain data integrity, consistency, and reliability across marketing workflows.
3. Stakeholder Communication and Task Ownership
Work directly with marketing team members to understand requests, clarify requirements, and determine appropriate technical solutions.
Take ownership of assigned requests from initial intake and requirements clarification through implementation, testing, documentation, and completion.
Manage assigned work through the team’s ticketing and task management system, Azure DevOps, including documenting progress, providing status updates, and recording completed tasks.
Communicate proactively when requirements are unclear, technical issues arise, or additional information is needed.
Keep stakeholders informed of progress, blockers, risks, and expected completion timelines.
Balance multiple requests and priorities while maintaining accuracy, following established processes, and meeting agreed deadlines.
Collaborate with the Marketing Cloud lead on complex technical or data-related questions while independently managing routine platform and campaign requests.
Identify recurring issues, document troubleshooting steps, and recommend process improvements when appropriate.
Required Qualifications
1–3 years of hands-on experience with Salesforce Marketing Cloud, supporting marketing operations, campaign execution, data management, or related activities.
Strong SQL skills, including the ability to write and troubleshoot queries involving joins, aggregations, subqueries, conditional logic, deduplication, date manipulation, and data transformations.
Practical understanding of relational data structures, data management principles, and relationships between marketing data sources.
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, automation failures, and issues affecting campaign execution.
Understanding of data validation, audience exclusion criteria, and the importance of accurate customer communications.
Familiarity with HTML/CSS, AMPscript, JavaScript, Server-Side JavaScript (SSJS), APIs, other scripting languages, or workflow automation technologies.
Awareness of production environment risks, including dependencies between data structures, queries, automations, and customer journeys.
Ability to follow established testing, documentation, and change-management procedures before implementing changes.
Strong written and verbal English communication skills, with the ability to communicate directly with business stakeholders.
Ability to ask clarifying questions, translate business requests into actionable technical tasks, and communicate technical issues clearly.
Strong organizational skills, attention to detail, and the ability to manage multiple priorities without compromising accuracy.
A proactive mindset, a strong sense of accountability, and the ability to manage assigned work with limited day-to-day supervision.
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, maintaining platform standards, and troubleshooting recurring production issues.
Familiarity with HTML email development, personalization, or dynamic content in marketing campaigns.
Experience validating changes in a production environment and identifying dependencies that could affect existing workflows.
What Success Looks Like
First 30 Days — Learning and Initial Execution
Become familiar with the organization’s Salesforce Marketing Cloud environment, data structures, folder organization, naming conventions, and existing workflows.
Understand the team’s campaign processes, operational requirements, testing procedures, and task management practices.
Learn how existing Data Extensions, SQL queries, automations, and journeys interact within the production environment.
Begin handling straightforward requests and assignments with appropriate guidance.
Demonstrate the ability to ask relevant questions, document work, and communicate effectively with the Marketing Cloud lead and other stakeholders.
Follow established procedures for validating data, testing changes, and escalating potential risks.
Days 31–60 — Increasing Independence
Independently manage a growing number of routine Salesforce Marketing Cloud requests.
Write and troubleshoot SQL queries, maintain data structures, and support automations and campaigns with increasing confidence.
Validate audience selections, exclusion criteria, and query results before changes are implemented.
Monitor recurring automations and journeys, investigate common failures, and escalate issues when necessary.
Communicate directly with marketing stakeholders to clarify requirements and resolve routine questions.
Maintain accurate Azure DevOps ticket updates and proactively communicate progress, blockers, and completed work.
Document technical changes and follow established naming, testing, and change-management standards.
Days 61–90 — Ownership and Consistent Delivery
Take ownership of routine Salesforce Marketing Cloud requests from initial intake through implementation, testing, documentation, and completion.
Work directly with marketing stakeholders without requiring the Marketing Cloud lead to coordinate every step.
Deliver reliable, accurate work while managing competing priorities and meeting agreed timelines.
Independently troubleshoot common SQL, data, automation, and campaign execution issues.
Proactively identify unexpected audience changes, recurring failures, and potential risks to existing customer communications.
Understand the downstream impact of proposed changes and consistently follow established production safeguards.
Maintain clear documentation of queries, Data Extensions, automations, journeys, and audience logic.
Demonstrate consistent communication, accountability, and sound judgment when resolving issues or escalating complex technical problems.
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.