Overview
You're the technical architect connecting Data Cloud and Marketing Cloud to turn unified customer data into revenue-driving personalization. Configure data streams, tune identity resolution, write SQL for calculated insights, then build the execution layer with advanced AMPscript/SSJS and Journey Builder automations.
Role Snapshot
| Aspect | Details |
|---|---|
| Role Type | Marketing Solution Architect / Technical Specialist |
| Sales Motion | N/A - Technical implementation |
| Deal Complexity | Strategic |
| Sales Cycle | N/A - Internal hire |
| Deal Size | N/A |
| Quota (est.) | N/A - Measured on technical delivery and system performance |
Company Context
Stage: Established company investing in Marketing Cloud + Data Cloud integration
Size: Large enough to justify dedicated Marketing Cloud architect role
Growth: Making strategic bets on unified data and personalization
Market Position: Mature enough to move beyond basic email marketing into sophisticated data-driven campaigns
What You'll Actually Do
Time Breakdown
Data Architecture (35%) | SFMC Development (35%) | Testing/QA (15%) | Meetings/Planning (15%)
Key Activities
- Data Cloud Configuration: Set up and manage data streams from S3, CRM, Web SDK. Map Data Lake Objects into the Cloud Information Model. Tune identity resolution rules so you're actually matching the right customer records across sources.
- SQL Development: Write calculated insights using SQL to derive behavioral attributes, segments, and metrics from unified data. This isn't basic SELECT statements - you're doing window functions, CTEs, and performance optimization.
- AMPscript/SSJS Development: Build advanced email templates and landing pages with dynamic content. Write server-side JavaScript for complex logic. Debug rendering issues across email clients.
- Journey Builder Automation: Design and build multi-step customer journeys with decision splits, wait periods, API calls. Manage Automation Studio workflows for batch processing and data imports.
- Marketing Cloud Connect Strategy: Own the integration between Sales Cloud/Service Cloud and Marketing Cloud. Manage synchronized objects, triggered sends, and data flow between systems.
The Honest Reality
What's Hard
- Data Quality Nightmares: Identity resolution only works if incoming data is clean. You'll spend time troubleshooting why customer records aren't matching when source systems have inconsistent formats.
- Performance Tuning: SQL queries that run fine on 10K records break at 10M records. Lots of optimization work on calculated insights and data extensions.
- SFMC Quirks: Marketing Cloud has weird limitations and undocumented behaviors. Things that should work don't. You spend time in support cases and community forums finding workarounds.
- Stakeholder Education: Marketing team wants things that aren't technically possible or would break deliverability. You're constantly explaining why their idea won't work and proposing alternatives.
- Hybrid Coordination: You're in Chicago 2-3 days per week. Some collaboration needs to happen in person, some remote. Calendar tetris.
What Success Looks Like
- Campaigns launch on time with correct personalization rendering for the right audience segments
- Data Cloud identity resolution accuracy above 90%
- Journey Builder automations run without errors or stuck contacts
- Marketing team can self-serve on content changes without breaking your technical architecture
- Email deliverability stays healthy even as send volumes scale
Who You're Working With
Primary Stakeholders:
- Marketing operations manager (your main partner, day-to-day collaboration)
- Demand gen/lifecycle marketing managers (they request campaigns, you build the technical execution)
- Data engineering team (you integrate their data streams into Data Cloud)
What They Need From You:
- Technical expertise they don't have in-house on Data Cloud and SFMC
- Reliable campaign execution without constant hand-holding
- Strategic guidance on what's possible vs what marketing read in a blog post
- Fast turnaround on urgent campaign requests during quarter-end pushes
Requirements
- Deep technical expertise in Marketing Cloud (Email Studio, Journey Builder, Automation Studio)
- Strong SQL skills - can write complex queries for calculated insights
- Advanced AMPscript and Server-Side JavaScript development experience
- Hands-on experience with Data Cloud (data streams, identity resolution, Cloud Information Model)
- Marketing Cloud Connect implementation experience
- Located in or willing to relocate to Chicago area (hybrid role)
- Can translate business requirements into technical architecture
- Experience debugging data integration issues across multiple systems