Description of the PositionThis is a hands-on build role. You will spend most of the week inside Salesforce Marketing Cloud - building journeys and automations, writing SQL and AMPscript, configuring data extensions, testing and deploying - for fundraising, marketing and the business units across SickKids Foundation.
Think of it as roughly 70% technical build and 30% business-facing. The build is the job. The business time is what keeps the build pointed at the right outcome: enough time with fundraisers and marketers to understand what they are trying to achieve.
We expect you to use AI tools as a normal part of how you work, from writing and reviewing code to building test cases. You stay accountable for everything that ships.
This role reports to the Associate Director, Marketing Technology, and works alongside a business analyst and a second developer on the MarTech team.
What you'll doBuild in Salesforce Marketing Cloud- Design, build, test and deploy journeys, automations and triggered sends in Journey Builder and Automation Studio
- Write and optimize SQL against data extensions, and build and maintain the data extensions themselves
- Develop AMPscript, SSJS and dynamic content for personalization, and build responsive email and SMS templates that render cleanly and meet accessibility standards
- Own deployment end to end: run the QA passes, build automated checks for links, rendering, fallbacks and suppression logic, then schedule, deploy and verify
Integrate and automate- Build and maintain the data flows between SFMC and our CRM, fundraising and web platforms, working with the data and integrations team
- Use the SFMC APIs and file transfer automations to move data in and out of the platform
- Find the manual steps in our deployment process and automate them with APIs and scripting - this role is expected to reduce its own repetitive workload over time
Report on performance- Build reporting and dashboards on campaign, journey and send performance so stakeholders can see results without asking for a data pull
- Define what gets measured on each build, and make sure the tracking is in place before it deploys
Keep us current on the platform- Track new SFMC releases and features, including its AI capabilities, assess what is worth adopting here, and bring recommendations to the team rather than waiting to be asked
- Prototype and pilot new capabilities, and show the business what is now possible
Support and maintain- Troubleshoot send failures, data discrepancies and rendering issues, and fix the root cause rather than the symptom
- Test platform releases and patches, and flag what changes for the team
- Keep build documentation current so another developer can pick up your work
Working with the businessThis is the 30%. You will be in front of the people who request the work (fundraisers, marketers, program leads), not behind a ticket queue.
- Run requirements conversations directly with business stakeholders and our business analyst, and turn what you hear into a technical build
- Explain technical constraints and trade-offs in plain language to people who do not work in the platform
- Support business users through UAT, and train staff on new builds and processes
- Scope and sequence your own work, flag risks to timeline or quality early, and keep stakeholders current without being chased
Data, compliance and security- Protect the integrity and accuracy of donor and constituent data in the marketing platforms
- Run regular audits on data quality, subscriber status and suppression logic
- Build to CASL and CAN-SPAM requirements, including consent capture, express and implied consent handling, and unsubscribe mechanics
- Apply platform security practices: user roles and permissions, data access, and safe handling of personal information
This role is not ideal forThis role is probably not the right fit for:
- Someone who wants to oversee development rather than do it. This is a builder's job - you are in the platform every day, writing the queries and the scripts and running the QA yourself.
- Someone who waits to be told what to do. We need a person who picks up an ambiguous request, works out what is missing, goes and asks, and comes back with a proposal.
- Someone who builds a design exactly as handed over, without questioning it. We want the person who spots that the segment logic double-counts, that the fallback content is missing, or that it will not render on mobile - and raises it before build, not after deployment.
What you bring- 5+ years building in an enterprise marketing automation platform, with significant hands-on Salesforce Marketing Cloud experience across Email Studio, Journey Builder, Automation Studio and Contact Builder
- Strong SQL, including writing and tuning queries against large contact and transaction datasets
- Working knowledge of AMPscript and SSJS for dynamic content and personalization
- Solid HTML and CSS for email, including responsive build and cross-client rendering
- Experience with SFMC data modelling - data extensions, relationships, contact model, subscriber management
- Experience integrating a marketing platform with a CRM or donor database, including ETL, data mapping and schema design
- Experience gathering requirements directly from business stakeholders and translating them into technical specifications
- Able to explain complex technical information concisely to a non-technical audience, in writing and in person
- Hands-on use of AI tools in your development work, and a clear sense of where their output needs checking
- Comfortable managing several streams of work with competing priorities and deadlines
Nice to have- Salesforce Marketing Cloud certification(s)
- Experience in a not-for-profit or fundraising environment, including an understanding of donor journeys and gift processing
- Experience with an enterprise CRM or donor management platform and the systems that feed it
- Experience with Microsoft SQL Server
- Experience with SMS or mobile messaging in SFMC (MobileConnect)
- Scripting experience outside SFMC (Python or JavaScript) for automations and API work
Total Compensation PackageExpected Hiring Salary Range: $82,064 - $102,582; with the ability to progress to a maximum of $117,970 with demonstrated experience and proficiency. To ensure fair and equitable pay at SickKids Foundation, placement on the salary range will be based on your years of experience, skills, and qualifications relevant to the Senior Specialist, Salesforce Developer.
To help you lead in the fight for kids' health and to support your health, wellness, and career growth, in addition to competitive compensation, we offer a comprehensive benefit package (includes a flex benefit plan), tuition reimbursement, flexible work arrangements, pension plan and birth parent/parental top up - to name a few!
Position Status: Permanent Full-Time;
Hours: Hybrid work model: minimum two days per week in-office (Tuesday and Wednesday).
Available To: Internal and External Candidates
Available: Immediately; this posting is for an existing vacancy.
Date Posted: November 18, 2026
Applications will be reviewed on an ongoing basis. We encourage interested candidates to apply early.How to apply: Please apply on-line by visiting our website: https://www.sickkidsfoundation.com/careersandvolunteers
Please note that automated tools, including artificial intelligence, may be used to support the pre-screening of applications as part of our recruitment process.
#LI-LD1