Apply on Employer Site

DEPT® · 2 days ago

Adobe Experience Platform Data Architect, Contract

United States

Contract

Remote

Senior Level

DEPT® is a pioneering technology and marketing services company that creates integrated end-to-end digital experiences for brands. The role involves working closely with enterprise clients to design customer-centric data models and oversee data ingestion for the Adobe Experience Platform.

AdvertisingBrand MarketingDigital MarketingInternetMarketing

No H1B

Responsibilities

Coordinate closely with the Adobe project team and work directly with customers to document requirements for the Adobe platform solution

Collaborate with Enterprise Architect and Digital Strategist roles to provide data discovery through systems and business process review

Analyze a customer's disparate data sources (e.g., sales, CRM, analytics data) to design and tailor a data model that unifies the data to meet their digital marketing use cases

Configure the Adobe platform data lake and real-time customer profile for data ingestion and activation. Create REST APIs, use POSTMAN, and write ad hoc basic scripting to automate setup across environments

Test your schema design by loading sample data within the platform and coordinating with Data Engineer consultants for final customer data importing

Build, test, and schedule customer segments to activate marketing use cases

Develop tailored, sophisticated SQL to provide answers to customers' business questions using the combined platform data (e.g., a 360-degree view of the customer)

As part of a consulting organization, you'll be responsible for project time tracking, billing hours, and forecasting time toward customer projects and other key reporting

Join a team of Data Architects to learn and innovate together on new insights to improve team processes and solve customer needs

Qualification

Data ModelingSQLETL toolsData Warehouse conceptsReporting TechnologiesSelf-managedCustomer-centricProactiveOrganizational skillsCommunication skills

Required

Proficiency and experience with designing customer-centric database models and 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, and use case documentation

Experience with Reporting Technologies (e.g., 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 to coordinate with the Sales team and lead customers to a successful outcome

Must be self-managed, proactive, and customer-centric

A Degree in Computer Science, Information Systems, Data Science or a related field