MarTech Data Modeler / Engineer (Adobe Mix Modeler, Salesforce, Azure)
Posted 1 day ago by 1762933281
Negotiable
Outside
Remote
USA
Summary: The MarTech Data Modeler/Engineer is a technical expert tasked with designing and maintaining the data infrastructure that supports marketing measurement and planning. This role involves integrating customer data from Salesforce and other sources into a unified cloud environment using Azure, facilitating analysis through the Adobe Mix Modeler platform. The position aims to deliver accurate ROI insights that inform significant marketing budget decisions.
Key Responsibilities:
- Architect Data Flows: Design, implement, and maintain scalable ETL/ELT data pipelines using tools like Azure Data Factory and Databricks.
- Manage data storage and processing within Azure, ensuring high performance, security, and cost efficiency.
- Write complex SQL and data processing scripts to clean, transform, and harmonize data sets.
- Configure, build, train, and run Marketing Mix Models and Multi-Touch Attribution within Adobe Mix Modeler.
- Define and enforce data schemas and standards within the Adobe Experience Platform to ensure data accuracy.
- Work with marketing and finance teams to interpret model outputs and provide actionable budget allocation recommendations.
- Establish and manage data connection and synchronization between Salesforce and the Azure/Adobe data ecosystem.
- Ensure Salesforce lead, contact, and conversion data are correctly mapped with marketing activity data.
- Implement processes to maintain data quality, integrity, and privacy compliance across platforms.
Key Skills:
- Bachelor's degree in Computer Science, Data Science, Information Technology, or a related technical field.
- 3+ years of hands-on experience in Data Engineering, MarTech Architecture, or a similar role.
- Proven experience with Adobe Mix Modeler and the Adobe Experience Platform.
- Solid professional experience with Microsoft Azure services.
- Strong working knowledge of Salesforce data model and API integration methods.
- Expert proficiency in SQL for data querying and manipulation.
- Experience with scripting/programming languages for data pipeline development.
- Deep understanding of dimensional modeling, data warehousing, and ETL/ELT concepts.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Role: MarTech Data Modeler / Engineer (Adobe Mix Modeler, Salesforce, Azure) Location: Las Vegas (preferred) or remote USA.
Role Summary:
The MarTech Data Modeler/Engineer is a technical expert responsible for designing, building, and maintaining the end-to-end data infrastructure that powers our marketing measurement and planning. This role is central to connecting customer data from our CRM (Salesforce) and other sources into a unified cloud environment (Azure) to be analyzed by the Adobe Mix Modeler platform. The ultimate goal is to provide accurate, incremental ROI insights that drive millions in marketing budget decisions.
Key Responsibilities: 1. Data Engineering & Pipeline Management (Azure)
Architect Data Flows: Design, implement, and maintain scalable ETL/ELT data pipelines (using tools like Azure Data Factory, Databricks, or similar) to ingest large volumes of marketing data (cost, impression, conversion, etc.) into the Azure cloud environment.
Cloud Infrastructure: Manage data storage and processing within Azure (e.g., Azure Data Lake Storage, Azure Synapse) ensuring high performance, security, and cost efficiency.
Data Transformation: Write complex SQL and data processing scripts to clean, transform, and harmonize data sets, preparing them for modeling.
2. Adobe Mix Modeler Implementation & Management
Model Building: Configure, build, train, and run Marketing Mix Models (MMM) and Multi-Touch Attribution (MTA) within Adobe Mix Modeler.
Data Harmonization: Define and enforce data schemas and standards within the Adobe Experience Platform (AEP) to ensure data flowing into Mix Modeler is accurate, consistent, and ready for advanced analysis.
Insight Generation: Work with the marketing and finance teams to interpret model outputs, simulate budget scenarios, and translate complex results into clear, actionable budget allocation recommendations.
3. CRM Integration (Salesforce)
Source Integration: Establish and manage the data connection and synchronization between Salesforce (e.g., Sales Cloud, Marketing Cloud) and the Azure/Adobe data ecosystem.
Customer 360: Ensure that Salesforce lead, contact, and conversion data are correctly mapped and stitched with marketing activity data to create a unified view of the customer for accurate attribution.
Data Governance: Implement processes to maintain data quality, integrity, and privacy compliance across the Salesforce, Azure, and Adobe platforms.
Required Qualifications
Required Qualifications:
Education: Bachelor's degree in Computer Science, Data Science, Information Technology, or a related technical field.
Experience: 3+ years of hands-on experience in a Data Engineering, MarTech Architecture, or similar role.
Platform Expertise:
Adobe: Proven experience with Adobe Mix Modeler (or similar MMM/MTA solution) and the Adobe Experience Platform (AEP).
Cloud: Solid professional experience with Microsoft Azure services (Data Factory, Synapse, Data Lake, etc.).
CRM: Strong working knowledge of Salesforce data model and API integration methods.
Technical Skills:
Expert proficiency in SQL for data querying and manipulation.
Experience with scripting/programming languages (e.g., Python, Scala) for data pipeline development.
Deep understanding of dimensional modeling, data warehousing, and ETL/ELT concepts.