Marketing Data Engineer

Cypress HCM is seeking an expert-level Marketing Data Engineer to execute a comprehensive Data Quality Optimization strategy within their marketing ecosystem. The role focuses on optimizing data integrity and ensuring the effectiveness of data to meet evolving business needs, while proactively improving data quality and monitoring system health.

Responsibilities:

• Produce specific, measurable outcomes focused on stability and reliability within the marketing ecosystem
• Serve as the primary technical owner for the following areas:
• Data Quality Optimization & Operational Ownership
• The contractor will be directly responsible for executing the strategy to maintain long-term data stability:
• 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
• 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
• 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
• Specialized Technical Support
• 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
• 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

Requirements:

• 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
• Minimum 5 years of hands-on experience working directly with Marketo and Salesforce, including deep knowledge of their integration points
• High level proficiency in Snowflake, Alteryx, AccelData (or similar tools) for complex data analysis and automation
• Strong working knowledge of SQL, database structures, APIs (specifically for troubleshooting streaming errors), and data modeling concepts
• Minimum 7+ years of progressive experience in marketing database management, data analytics, and operational reporting