Data Architect - AEP Competency

Job Title : Data Architect – AEP Competency

Years of Experience : 10-12

Location : Remote

Position Summary:

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 do

• Interface with customer 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.

Requirements:

• 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.

Special Consideration given for:

• 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, Pigetc.)

• Experience as an enterprise technical or engineer consultant.