AEP Data Architect

About this job

VML/WPP Enterprise Solutions is hiring an AEP Data Architect in Noida, India. The company builds growth systems, drives business transformation, and executes marketing modernization using advanced technologies. As an AEP Data Architect, your primary focus is to define new data schemas and manage data ingestion for Adobe Experience Platform customers. A normal day in this role involves interacting directly with enterprise clients to gather requirements, leading project calls, delivering technical specifications, and collaborating closely with onshore and offshore software engineering consultants. You will structure data using your knowledge of schemas and relationships to enable dynamic customer-level analysis, build Customer ID mapping files for a complete 360-degree view, and use scripting languages to automate data movement, cleansing, and processing activities. Additionally, you will bill and forecast project time, and innovate creative solutions to meet diverse customer needs while working within a global operating environment.

Responsibilities

• Interface with enterprise customers to gather requirements, design solutions, and offer recommendations.
• Lead customer project conference calls or collaborate directly with project managers.
• Deliver technical specification documents for thorough customer review.
• Collaborate strongly with onshore and offshore software engineer consultants.
• Structure data using relationship and schema insights for dynamic customer analysis.
• Construct processes to build Customer ID mapping files across multiple data sources.
• Automate data movement, cleansing, and processing activities using scripting languages.

Requirements

• 10+ years of strong experience with data transformation and ETL on large datasets.
• Experience designing customer-centric datasets across CRM, Call Center, Marketing, and POS.
• 5+ years of data modeling experience in relational, dimensional, columnar, or big data.
• 5+ years of complex SQL or NoSQL experience.
• Experience in advanced data warehouse concepts and industry ETL tools.
• Experience with business requirements definition, structured analysis, process design, and use case documentation.
• Experience with reporting technologies like Tableau and PowerBI, alongside professional software development.
• Degree in Computer Science, Information Systems, Data Science, or a related field.

Good to have

• Experience and knowledge with Adobe Experience Cloud solutions, digital analytics, or digital marketing.
• Experience in programming languages such as Python, Java, or Bash scripting.
• Experience with big data technologies like Hadoop, Spark, Redshift, Snowflake, Hive, or Pig.
• Experience working as an enterprise technical or engineering consultant.

Who should apply

This role suits experienced data modelers and ETL professionals with a background in development who want to work with enterprise clients at VML/WPP Enterprise Solutions. Applicants must possess substantial industry experience, including over a decade in ETL and multiple years in data modeling and complex SQL. Freshers should not apply as the position requires senior-level expertise. Candidates who are self-managed, proactive, customer-focused, and possess strong communication skills will thrive in this environment.

Frequently asked questions