AEP Data Architect

The role

This person will design new data schemas and data ingestion for Adobe Experience Platform customers. They will interface with enterprise customers and collaborate with internal teams.

What you will do

• 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 360 degree view of customer
• Leverage scripting languages to automate data movement, cleansing, and processing activities
• Bill and forecast time toward customer projects
• Innovate on new ideas to solve customer needs

Required qualifications

• 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 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
• Exceptional organizational skills and ability to multi-task simultaneous different customer projects
• Strong verbal and written communication skills
• Degree in Computer Science, Information Systems, Data Science, or related field

Nice to have

• Experience and knowledge with Adobe Experience Cloud solutions
• Experience and 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

Benefits

• Career development
• Help to grow your skills

About the company

WPP Enterprise Solutions designs, builds, and operates growth systems for competitive businesses. VML, part of WPP, supports WPP Enterprise Solutions by helping brands activate transformation through creativity and experience.