Apply on Employer Site

DEPT® · 2 months ago

AEP 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. They are seeking an experienced Data Architect who specializes in customer-centric data modeling to join their Data Architecture team, where the main responsibility will be to bridge the gap between disparate customer data sources and unified marketing use cases.

AdvertisingBrand MarketingDigital MarketingInternetMarketing

H1B Sponsor Likely

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-managementCommunication skillsOrganizational 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

Benefits

DEPT® is an equal opportunity employer (EOE).

We believe our work is its best when our people feel safe and free to be themselves.

We’re committed to an inclusive and barrier-free recruitment and selection process and workplace, regardless of anyone’s identity, background, beliefs, lifestyle or disabilities.

DEPT® participates in E-Verify, meaning your Form I-9 information will be sent to the federal government to confirm you are authorized to work in the U.S.

We are a B Corp-certified company passionate about purpose-driven work.

Our hope is that you can feel good about the contributions DEPT® is making to the world and we always have an open door for your ideas in making the world a better place.

At DEPT®, we take pride in creating an inclusive workplace where everyone has an equal opportunity to thrive.

Company

DEPT®

Glassdoor3.9

DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster.

Founded in 2016

Amsterdam, Noord-Holland, NLD

1001-5000 employees

https://www.deptagency.com

H1B Sponsorship

DEPT® has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2024 (1)

2022 (1)