Data Engineer

Job Title: Data Engineer Location: Brentwood, TN Contract duration: 6 month contract with potential for extension or conversion Job Summary We are seeking a Senior Marketing Data & Activation Engineer to support the migration from Adobe Campaign Classic to the Zeta Marketing Platform by owning end-to-end marketing data pipelines, troubleshooting issues, validating data, and enabling reliable audience activation. This role requires strong SQL, Python, and expert Snowflake skills, experience with marketing or customer data engineering, and familiarity with Adobe Campaign, Zeta, or similar ESP platforms, along with the ability to translate business needs into technical solutions. Responsibilities Migration Data Validation & Parity (Phase 1) • Analyze and map ACC schemas to Zeta data structures • Validate audience parity between ACC and Zeta during parallel runs • Investigate and resolve audience count discrepancies • Ensure suppression, eligibility, and preference logic behaves consistently • Partner with IT and vendors to troubleshoot data issues affecting activation Activation & Identity Governance (Post-Migration) • Monitor and maintain customer identity resolution across channels • Ensure opt-in, opt-out, and preference data remains accurate and consistent • Detect and address audience inflation, decay, or duplication • Support compliance and deliverability through clean audience hygiene Personalization & Trigger EnablementPrepare and validate customer attributes and event data for: • Personalization • Triggered journeys • Lifecycle messaging • Build and support clean event modeling and trigger firing logic • Enable scalable use of behavioral and transactional signals Measurement & Reporting ConfidenceReconcile performance data across: • Zeta • Adobe Analytics • Finance / Analytics outputs • Investigate tracking and attribution discrepancies • Support executive-ready explanations of performance changes • Validate event capture and downstream reporting logic • Experimentation & Test-and-Learn Support • Support audience split logic and control group design • • Enable clean test vs control measurement for journeys and triggers • • Assist in defining guardrails to prevent cannibalization or over-messaging Requirements Core Experience • 5+ years of experience in marketing data engineering or ESP data roles • Strong SQL skills (joins, deduplication, window functions) a must; other programming languages expected (Python, Apache Spark, HTML etc.) • Hands-on Adobe Campaign Classic experience: (Custom tables, workflow-based data processing) • Hands-on Zeta experience: (Audience and event modeling, identity resolution concepts, real-time vs batch data ingestion) Integration & Collaboration • Experience working alongside IT teams on APIs and data feeds • Understanding of ESP data dependencies and activation impacts • Ability to translate and resolve technical data issues • Strong understanding of web and app event data concepts • Working knowledge of APIs and JSON payloads (conceptual, not development) • Experience working along side data science and analytics teams to activate AI/ML based campaigns • Experience with event data from clickstream, apps, APIs etc. • Ability to build and automate tracking and health reports Preferred Qualifications: • Familiarity with Movable Ink data feeds and ESP integrations • Experience supporting experimentation or incrementality testing • Strong documentation and data validation practices • Retail or eCommerce marketing experience • Reporting or dashboarding experience • Experience collaborating with data science and analytics teams to productionize AI/ML models and support triggered communications Screening questions: Do you now or in the future require sponsorship (e.g. H-1B)? Y/N EEO and ADA Statement: Consulting Solutions and its family of companies is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at: requests@consultingsolutions.com