Marketing Data Engineer

Marketing Automation Engineer

We are seeking an expert-level specialist to execute a comprehensive "Data Quality Optimization" strategy within our marketing ecosystem. The core mandate of this role is to actively optimize data integrity and ensure the long-term stability and effectiveness of our data to meet evolving business needs, moving beyond rudimentary system monitoring. Under the direction of the Marketing Automation & Data Management leadership, this individual will proactively improve data integrity and execute the long-term data strategy, ensuring our Customer Data Platform (CDP) is actively fueling our marketing objectives with high-quality, business-ready data. The goal is to secure a dedicated specialist who will bridge the gap between technical system health and business-ready data effectiveness by executing a strategy to monitor and continually enhance data quality.

Scope of Work & Deliverables

• Produce specific, measurable outcomes focused on stability and reliability within the marketing ecosystem. Serve as the primary technical owner for the following areas:

1.

Data Quality Optimization & Operational Ownership

• The contractor will be directly responsible for executing the strategy to maintain long-term data stability:
• A. Proactive Data Optimization
• Execute specific directives from the Data Management leadership to ensure data effectiveness for business needs.
• Quality Assurance: proactively identify and resolve data quality degradation before it impacts downstream marketing campaigns.
• Audience Effectiveness: Validate that the data within the CDP is accurate, up-to-date, and structured correctly to meet specific business segmentation requirements.
• B. Daily CDP/AEP System Health & Data Monitoring
• Execute the team’s data monitoring protocols in Adobe Experience Platform (AEP) to ensure early detection of anomalies.
• Ingestion Source Monitoring: Perform daily checks of the AEP Monitoring Dashboard for all data flows (Marketo, S3, etc.).
• Profile & Audience Metrics: Monitor Profile and Audience counts against established benchmarks (e.g., ~35–38M profiles, ~140 audiences) to identify and investigate sudden spikes or drops.
• Failure Investigation: Investigate dataflow failures by analyzing error codes/descriptions and utilizing preview error diagnostics.

2. Incident Response & Troubleshooting

• Serve as the first line of defense for data issues, reducing reliance on external partners for daily fixes.
• Root Cause Analysis: Rapidly identify whether issues stem from source data (Marketo), transformation logic (Data Prep), or destination constraints.
• Resolution: Implement fixes for ingestion failures and mapping errors without requiring escalation to strategic leadership.

3. Specialized Technical Support

• A. Advanced Data Analysis & Automation
• Data Workflows: Build and maintain data workflows in tools such as Snowflake, AccelData, and/or Alteryx to automate data quality checks and complex reporting tasks.
• SQL Analysis: Write complex SQL queries to validate data accuracy within the data warehouse and troubleshoot specific profile attributes.
• B. Vendor & Platform Liaison
• Support Case Management: Act as the primary technical point of contact for opening and managing support tickets with Adobe and data enrichment vendors to resolve complex infrastructure issues.

Required Qualifications & Experience:

• This is an expert-level position requiring demonstrable, hands-on experience. We are seeking a professional who can operate independently and drive results immediately upon entry.
• CDP Expertise (Critical): Proven experience with Adobe Real-Time CDP (AEP). Must have specific experience in monitoring data flows, troubleshooting ingestion errors, and managing destination activations within the AEP environment.
• Core Systems Expertise: Minimum 5 years of hands-on experience working directly with Marketo and Salesforce, including deep knowledge of their integration points.
• Data Tool Mastery: high level proficiency in Snowflake, Alteryx, AccelData (or similar tools) for complex data analysis and automation.
• Technical Foundations: Strong working knowledge of SQL, database structures, APIs (specifically for troubleshooting streaming errors), and data modeling concepts.
• Experience Level: Minimum 7+ years of progressive experience in marketing database management, data analytics, and operational reporting.

Success Metrics:

The Success Of This Engagement Will Be Measured By

• 1) Data Effectiveness: Improvement in data quality metrics that directly support business requirements (e.g., audience accuracy).
• 2) System Stability: Reduction of undetected ingestion failures in the CDP/AEP environment.
• 3) Operational Continuity: Seamless transition of daily tasks from the implementation partner (Deloitte) to this operational role.

Compensation:

• $55.00/hr. - $63.00/hr. (W2)

Req# 2491