AEP Data Architect

VML Enterprise Solutions; Dadri; On-site; INR 400,000 - 700,000; Full time

Job summary

WPP Enterprise Solutions designs, builds, and operates growth systems for enterprise clients, focusing on data transformation and analytics.

The role centers on data modeling, ETL on large data sets, and SQL/NoSQL design, interfacing with customers to gather requirements and deliver technical specifications.

You will work with onshore and offshore engineers, implement data warehouses, and enable reporting with Tableau and Power BI; 10+ years in data engineering are expected.

Qualifications

• 10+ years of data transformation and ETL on large data sets.
• 5+ years of Data Modeling (Relational, Dimensional, Columnar, Big Data).
• 5+ years of complex SQL or NoSQL experience.
• Experience in advanced Data Warehouse concepts.
• Experience with industry ETL tools (Informatica, Unifi).
• Experience with Business Requirements definition and management, structured analysis, process design, use case documentation.
• Experience with Reporting Technologies (Tableau, PowerBI).
• Experience in professional software development.
• Strong organizational and multi-project management skills.
• Excellent verbal and written communication to interface with Sales and customers.

Responsibilities

• Interface with customers to gather requirements, design solutions and make recommendations
• Lead customer project conference calls or interface with a Project Manager
• Deliver Technical Specifications documents for customer review
• Collaborate with team software engineer consultants onshore and offshore
• Leverage data relationships and schemas to structure data for analysis
• Construct processes to build Customer ID mapping files for a 360-degree view
• Use scripting languages to automate data movement, cleansing, and processing
• Bill and forecast time toward customer projects
• Innovate on new ideas to solve customer needs

Skills

ETL

Data Modeling

SQL

NoSQL

Data Warehousing

Data Analysis

Scripting

Project Collaboration

Education

Bachelor's degree in CS/IS/Data Science

Tools

Informatica

Unifi

Tableau

Power BI

Job description

WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where AI is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our experts work within a unified global operating unit across 40+ markets, delivering growth solutions tailored to the needs of our clients’ businesses. The opportunity is for experienced data modelers, SQL, ETL professionals with some development background to define new data schemas and data ingestion for Adobe Experience Platform customers. This role involves interfacing directly with enterprise customers and collaborating with internal teams.

Responsibilities

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

Requirements

• 10+ years of strong experience with data transformation and ETL on large data sets
• Experience with designing customer-centric datasets (i.e., CRM, Call Center, Marketing, Offline, Point of Sale)
• 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 different customer projects
• Strong verbal and written communication skills to interface with Sales team and lead customers to successful outcomes
• Must be self-managed, proactive and customer-focused
• Degree in Computer Science, Information Systems, Data Science, or related field

Preferred

• Preferred: Experience and knowledge with Adobe Experience Cloud solutions
• Preferred: Experience and knowledge with Digital Analytics or Digital Marketing
• Preferred: Experience in programming languages (Python, Java, or Bash scripting)
• Preferred: Experience with Big Data technologies (i.e., Hadoop, Spark, Redshift, Snowflake, Hive, Pig)
• Preferred: Experience as an enterprise technical or engineer consultant