AEP Data Architect

Overview

Remote
$70 - $75
Full Time

Skills

Data Warehouse
Data Modeling
Data Lake
Database
Informatica
Extract
Transform
Load
Adobe
Adobe Marketing Cloud
Amazon Redshift
Analytics
Apache Hadoop
Apache Hive
Apache Pig
Apache Spark
Bash
Big Data
Billing
Business Process
Call Center
Collaboration
Communication
POSTMAN
Python
Snow Flake Schema
NoSQL

Job Details

What Working at Hexaware offers:

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance.

With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware s commitment towards creating smiles.

At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together.

We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion the driving force that makes one smile and innovate, create, and make a difference every day.

The Hexaware Advantage: Your Workplace Benefits

  • Excellent Health benefits with low-cost employee premium.
  • Wide range of voluntary benefits such as Legal, Identity theft and Critical Care Coverage
  • Unlimited training and upskilling opportunities through Udemy and Hexavarsity

Position Summary
Experienced database data modelers! Join team of Data Architects to work closely with enterprise customers & collaborate with Adobe consultants. Gain insights & experience with the new, industry leading Adobe
Experience Platform. Provide data discovery, define new data schemas, support data ingestion, build creative
SQL and sophisticated segments for our Adobe customers.

What you ll do
PROJECT TEAM: Coordinate closely with Adobe project team members & work directly with
customers to document requirements for Adobe platform solution
DATA DISCOVERY: Work closely with Enterprise Architect & Digital Strategist roles to provide data
discovery with systems & business process review
DATA SCHEMA DESIGN: Analyze customer's disparate data sources to design & tailor a data model
that unifies the data (e.g., sales, CRM, analytics data etc.) to meet customer's digital marketing use
cases.
PLATFORM SETUP: Configure Adobe platform data lake & real-time customer profile to prepare for
data ingestion and activation. Create REST API's, POSTMAN and ad hoc basic scripting to automate &
streamline setup to additional environments.
DATA INGESTION: Test schema design loading sample data within platform & coordinate with Data
Engineer consultants for customer data importing.
SEGMENTATION: Build, test & schedule customer segments to activate use cases
QUERY: Develop tailored sophisticated SQL to provide answers to customers business questions with
the combined platform data (e.g., 360-degree view of customer across data sources)
CONSULTING: As part of Adobe Consulting organization, project time tracking, billing hours &
forecast time toward customer projects and other key reporting are required
INNOVATION: Join a team of Data Architects to learn & innovate together on new insights to
improve team processes & solve customer needs

Requirements
Proficiency & experience with designing customer centric database models, datasets (e.g., CRM, Call
Center, Marketing, Offline, Point of Sale etc.)
Proficiency with data transformation & ETL tools (e.g., Informatica, Unifi, Snaplogic) on large data
sets
Proficiency with Data Modeling experience (e.g., Relational, Dimensional, Columnar, Big Data)
Proficiency with complex SQL and NoSQL experience
Experience in advanced Data Warehouse concepts
Experience with Business Requirements definition and management, structured analysis, process
design, use case documentation
Experience with Reporting Technologies (e.g., 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 coordinate with Sales team & lead customers to
successful outcome
Must be self-managed, proactive and customer centric
Degree in Computer Science, Information Systems, Data Science or related field
Special Consideration given for
Experience & knowledge with Adobe Experience Cloud solutions or industry relevant Digital
Analytics or Digital Marketing experience
Experience in programming languages (Python or Bash scripting)
Experience with Big Data technologies (e.g., Hadoop, Spark, Redshift, Snowflake, Hive, Pig etc.)
Experience as an enterprise technical or engineer consultant

Privacy Statement:

The information you provide will be used in accordance with the terms of our and will be used specifically for the business/processing purpose of the event. You should be aware that we may share your details with our approved vendors for this event to be handled successfully.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.