RESPONSIBILITIESData Engineering & Platform DevelopmentSupport and manage data pipelines feeding Snowflake, Data Cloud, MCA, and CRM systemsCollaborate with Data Engineering on integrations for vendor behavior data, customer product insights data, vendor programs, UTM parameters, and prospect scoring inputs - with direction from the Principal Marketing ArchitectImplement transformations required for Data Cloud ingestion (DMO/DLO mappings, identity stitching, behavioral tables) with support of Data EngineeringMarketing Cloud Advanced (MCA) EngineeringSupport MCA data activations (in Data Cloud), entry criteria, segmentation inputs, and schema alignmentWork with external implementation partners, marketing firms, and internal teams to configure MCA objects, fields, mappings, and activation flowsTroubleshoot MCA CRM sync, consent flows, reporting gaps, and data discrepanciesData Cloud EnablementBuild and maintain Data Cloud datasets, calculated attributes, data bundles, and ingestion rulesMonitor data consumption and trend analysisEnsure data quality, completeness, and refresh reliability for vendor‑facing systemsSupport the Principal Architect in standing up new data sources or schema extensionsVendor Data EnablementBuild and maintain vendor data tables and logic feeding into insights for Sales, RevOps, and MarketingSupport ingestion of awards data, web behavioral data, vendor lifecycle signals, and customer performance metricsEnsure data integrity for insights powering vendor communications and revenue enablementCross‑Functional CollaborationManage the Enterprise Marketing Technology roadmap and backlogPartner with Martech Ops, Marketing, Sales, Data Science, Enterprise Engineering, and Product teamsParticipate in technical discovery, solution design, and requirements gatheringProvide engineering support for Salesforce integrations (MCA, Pardot/MCAE, CRM)Reliability, QA & DocumentationTroubleshoot data failures, ingestion errors, identity mismatches, and field mapping issuesWrite documentation, SOPs, and runbooks for data flows and platform componentsMonitor performance, ensure SLA adherence for data refresh and pipeline uptimeSupport sandbox production deployment cycles, QA validation, and release workflowsSKILLS & EXPERIENCERequired4–6+ years of data engineering, marketing technology engineering, or CRM platform engineeringStrong SQL experience across Snowflake, Redshift, or similar cloud data warehousesExperience building data pipelines (Airflow, Fivetran, custom ingestion jobs, APIs, etc.)Experience with Salesforce ecosystem integrations: MCA, MC, Pardot, Data Cloud, or CRMStrong understanding of marketing data models, lead routing, segmentation, or attributionAbility to work across multiple systems with complex dependenciesExcellent communication skills and ability to work with technical & non‑technical partnersExperience with API development, REST integrations, or ETL/ELT frameworksPreferredExperience with Salesforce Data Cloud (DLO/DMO, identity resolution, ingestion rules)Experience with Marketing Cloud Advanced (MCAE/MCA)Experience with UTM attribution pipelines or web/app behavioral event ingestionExperience working with scoring engines or marketing analytics datasetsExperience with Sercante or Salesforce SI partnersFamiliarity with Snowflake tasks, streams, or DBTExperience supporting CRM/MarTech platforms in enterprise environmentsCOMPENSATIONStarting pay is determined based on a combination of factors which may include location/market, education, experience, skills, and other qualifications of the successful candidate. As part of a high-performing, cross-functional team, you will work closely with our Principal Architect, Martech Operations, Data Engineering, and Enterprise Engineering to build and maintain the technical backbone behind The Knot Worldwide's marketing platforms—including Marketing Cloud Advanced (MCA), Salesforce Data Cloud, Snowflake, UTM attribution, behavioral data ingestion, and vendor product insights and lifecycle data.