Marketing Automation Engineer

Job Title: Marketing Automation Engineer

Duration: 12 Months (extension will depend on the performance and budgets)

Location: Pleasanton, CA, United States (Hybrid)

Interview Process: 2-3 rounds

Job Description:

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.

Must Haves:

• 5 years of hands-on experience working directly with Marketo
• 5 years of hands-on experience working directly with Salesforce
• 7+ years of progressive experience in marketing database management
• Data Quality Optimization
• Proven experience with Adobe Real-Time CDP (AEP)
• snowflake
• SQL

Nice to Have:

• Alteryx
• Sigma

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.