Sr. Data consultant
General Position Requirements / Scope
We are looking for a Senior Data Operations Consultant (SME) to join our Lifecycle Marketing team. In this role, you will serve as the go-to authority for end-to-end campaign execution, owning the operational standards, tooling practices, and quality frameworks that power our customer communications. You bring strong data fluency — including hands-on SQL expertise — that allows you to move fluidly between campaign platforms and the underlying data that drives them. You will work at the intersection of marketing strategy, data engineering, and technology, translating business goals into scalable, high-performing campaigns across channels.
Campaign Execution & Orchestration
Own the build, QA, and deployment of complex multi-channel campaigns using Adobe Journey Optimizer (AJO), including real-time and batch journeys across email, push, SMS, and in-app.
Design and manage audience segmentation and activation workflows in Adobe Experience Platform (AEP), leveraging the Real-Time Customer Data Platform (RT-CDP) for exact,
data-driven targeting.
Write and validate SQL queries to verify audience counts, segment logic accuracy, and campaign eligibility criteria before deployment — serving as the last line of defense for data quality.
Partner with Marketing, Product, and Data teams to translate campaign briefs into technically sound execution plans.
Monitor journey performance, proactively identify failures or data anomalies using SQL-based investigation, and own resolution end-to-end.
Data Validation & SQL Proficiency
Use SQL extensively to query BigQuery, Snowflake, or equivalent data warehouses to validate audience composition, confirm segment membership, and troubleshoot data pipeline inconsistencies.
Build and maintain reusable SQL scripts for recurring QA checks — including suppression validation, deduplication, frequency cap verification, and eligibility logic audits.
Partner with Data Engineering to review u
📌 Data Consultant (India)
🏢 eClerx
📍 India