Apply on Employer Site

DEPT® · 1 month ago

Adobe Experience Platform Data Architect, Fixed Term - Platforms - Toronto

Toronto Canada

Full-time

Onsite

Mid, 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 to join their Data Architecture team, focusing on customer-centric data modeling and bridging disparate customer data sources for 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 ArchitectureSQLData ModelingETL toolsData Warehouse conceptsReporting TechnologiesSelf-managementProactivityCustomer-centricDegree in Computer ScienceOrganizational 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

Benefits

15 days holiday (per annum, pro rata)

10 paid sick days off, not pro rata

A flexible, hybrid working policy

Buddy Program: You will be paired with a ‘Buddy’ to help you through your first weeks’ at DEPT®

A reputation for doing good. DEPT® has been a Certified B Corp® since 2021 and named ‘Agency of the Year’ at both The Lovies and The Webby Awards.

Awesome clients. Whether big or small, local or global — at DEPT® you’ll get the opportunity to work with clients of all sizes and across all industries. And we celebrate all of our successes together!

The opportunity for possibility. We want to enable you to do what you do best and help you develop your skills further with training, development and certifications.

Global annual DEPT® Cares Month in which employees come together and donate their skills to support local charities.

Tons of Office perks in our Toronto office! Enjoy biweekly breakfasts and lunches, tons of free snacks, and of course team events on the regular!

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)