AEP Data Architect

Posted 2 Days Ago
Be an Early Applicant
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
In-Office
Expert/Leader
Agency • eCommerce • Information Technology • Consulting
The Role
Designs data schemas, ingestion pipelines, customer ID mapping, and transformation processes for Adobe Experience Platform customers. The role gathers requirements, produces technical specifications, collaborates with engineering teams, leads customer engagements, automates data movement and cleansing, supports customer-level analytics, and manages project forecasting. It requires extensive ETL, data modeling, SQL or NoSQL, data warehouse, reporting, software development, and customer consulting experience.
Summary Generated by Built In
Who We Are

WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our 12,000 experts in engineering and platforms, commerce, consulting, content transformation, CRM, and CX work within a unified global operating unit across 40+ markets. WPP Enterprise Solutions works alongside best-in-class partners including Adobe, AWS, Braze, Google, Microsoft, Salesforce, and Shopify, as well as innovators in AI, to deliver growth solutions tailored to the needs of our clients’ businesses. VML, part of WPP, supports WPP Enterprise Solutions by helping brands activate transformation through creativity and experience.

The opportunity

Experienced data modelers, SQL, ETL, with some development background to provide defining new data schemas, data ingestion for Adobe Experience Platform customers. Interface directly with enterprise customers and collaborate with internal teams.


What you’ll be doing
  • Interface with customers to gather requirements, design solutions & make recommendations
  • Lead customer project conference calls or interface with a Project Manager
  • Deliver Technical Specifications documents for customer review
  • Strong collaboration with team software engineer consultants onshore & offshore
  • Leverage understanding of data relationships and schemas to structure data to allow clients to perform dynamic customer-level analysis
  • Construct processes to build Customer ID mapping files for use in building 360 degree view of customer across data sources.
  • Leverage scripting languages to automate key processes governing data movement, cleansing, and processing activities
  • Bill & forecast time toward customer projects
  • Innovate on new ideas to solve customer needs 

What we want from you
  • 10+ years of strong experience with data transformation & ETL on large data sets
  • Experience with designing customer centric datasets (i.e., CRM, Call Center, Marketing, Offline, Point of Sale etc.)
  • 5+ years of Data Modeling experience (i.e., Relational, Dimensional, Columnar, Big Data)
  • 5+ years of complex SQL or NoSQL experience
  • Experience in advanced Data Warehouse concepts
  • Experience in industry ETL tools (i.e., Informatica, Unifi)
  • Experience with Business Requirements definition and management, structured analysis, process design, use case documentation
  • Experience with Reporting Technologies (i.e., Tableau, PowerBI)
  • Experience in professional software development
  • Demonstrate exceptional organizational skills and ability to multi-task simultaneous different customer projects 
  • Strong verbal & written communication skills to interface with Sales team & lead customers to successful outcome
  • Must be self-managed, proactive and customer focused
  • Degree in Computer Science, Information Systems, Data Science, or related field

If you know some of this even better
  • Experience & knowledge with Adobe Experience Cloud solutions
  • Experience & knowledge with Digital Analytics or Digital Marketing
  • Experience in programming languages (Python, Java, or Bash scripting)
  • Experience with Big Data technologies (i.e., Hadoop, Spark, Redshift, Snowflake, Hive, Pig etc.)
  • Experience as an enterprise technical or engineer consultant 

What we can offer you

Alongside the opportunity to work with some of the most exciting brands around the world, we’ll also prioritise your career development and help you grow your skills. We’ll empower you to make a difference, allow you to be yourself, and respect who you are.

Our culture thrives on our core values, designed for impact-driven individuals: Heart, Brains and Courage.

We lead with Heart, fostering empathy and trust where genuine connections and human-centric work flourish.
We empower your Brains for innovation, valuing relentless curiosity and collaborative intelligence to solve complex challenges.
And we champion Courage, inspiring you to speak up, embrace experimentation, and advocate for bold solutions that push our thinking to be better than yesterday.


About WPP

WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence and world-class partnerships – all united by our agentic marketing platform, WPP Open – we help clients navigate change, capture opportunity and deliver transformational growth. For more information, visit WPP.com.

WPP (VML/WPP Enterprise Solutions) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers. 

When you click "Submit Application", this will send any information you add below to WPP (VML/WPP Enterprise Solutions). Before you do this, we think it's a good idea to read through our Recruitment Privacy Policy. California residents should read our California Recruitment Privacy Notice. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.

Skills Required

  • 10+ years of experience with data transformation and ETL on large datasets
  • Experience designing customer-centric datasets across CRM, call center, marketing, offline, and point-of-sale data
  • 5+ years of data modeling experience, including relational, dimensional, columnar, or big data models
  • 5+ years of complex SQL or NoSQL experience
  • Experience with advanced data warehouse concepts
  • Experience with industry ETL tools such as Informatica or Unifi
  • Experience defining and managing business requirements, structured analysis, process design, and use case documentation
  • Experience with reporting technologies such as Tableau or Power BI
  • Experience in professional software development
  • Exceptional organizational skills and ability to manage multiple customer projects simultaneously
  • Strong verbal and written communication skills for interfacing with sales teams and leading customers
  • Self-managed, proactive, and customer-focused approach
  • Degree in Computer Science, Information Systems, Data Science, or a related field
  • Experience with Adobe Experience Cloud solutions
  • Experience with digital analytics or digital marketing
  • Experience with Python, Java, or Bash scripting
  • Experience with Hadoop, Spark, Redshift, Snowflake, Hive, Pig, or similar big data technologies
  • Experience as an enterprise technical or engineering consultant
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
10,000 Employees

What We Do

VML Enterprise Solutions is VML's technology and transformation unit that unites the agency's technology and data groups to deliver consulting, engineering, data, automation and platform services. It supports global brands with AI-enabled solutions, commerce and customer experience transformation, and scalable platform delivery through integrated consulting and technology capabilities.

Similar Jobs

Optum Logo Optum

Data Analyst

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Senior Data Analyst

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Data Analyst

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Manager Data Analytics

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Similar Companies Hiring

Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account