Back to jobs
New

AEP Data Architect, Fixed Term - Platforms - Toronto

Toronto Canada

WHY DEPT®?

We are pioneers at heart. What this means, is that we are always leaning forward, thinking of what we can create tomorrow that does not exist today. We were born digital and we are a new model of agency, with a deep skillset in tech and marketing. That’s why we hire curious, self-driven, talented people who never stop innovating.

Our culture is big enough to cope and small enough to care. Meaning, that with people across 20+ countries, we’re big enough to provide you with the best tools, global opportunities, and benefits that help you thrive. While acting small by investing in you, your growth, your team, and giving you the autonomy to solve our clients' problems, no matter where you are in the world. 

This is a 3 month fixed term salaried contract, located in Ontario Canada. Preferably in Toronto.

About You:

You are an experienced and proactive Data Architect who specializes in customer-centric data modeling. You will be a key player in our Data Architecture team, working directly with enterprise clients and collaborating with Adobe consultants to master the Adobe Experience Platform (AEP). Your core responsibility is to bridge the gap between disparate customer data sources and unified marketing use cases. This involves expert data discovery, defining and tailoring robust data schemas (Relational, Dimensional, Big Data), overseeing data ingestion readiness, and developing advanced SQL queries and sophisticated customer segments for activation. You must be self-managed, customer-centric, and eager to innovate within the evolving MarTech landscape.

What You’ll Do:

  • PROJECT TEAM: Coordinate closely with the Adobe project team and work directly with customers to document requirements for the Adobe platform solution.
  • DATA DISCOVERY: Collaborate with Enterprise Architect and Digital Strategist roles to provide data discovery through systems and business process review.
  • DATA SCHEMA DESIGN: 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.
  • PLATFORM SETUP: 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.
  • DATA INGESTION: Test your schema design by loading sample data within the platform and coordinating with Data Engineer consultants for final customer data importing.
  • SEGMENTATION: Build, test, and schedule customer segments to activate marketing use cases.
  • QUERY: 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).
  • CONSULTING: 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.
  • INNOVATION: Join a team of Data Architects to learn and innovate together on new insights to improve team processes and solve customer needs.

What You Bring:

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

WHAT DO WE OFFER?

We are a collaborative, open-door, best-idea-wins environment that fosters personal and company growth and has fun doing it. Here is a snapshot of our  benefits package:

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

WE SUPPORT YOU BEING YOU: 

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 lived experience, race, color, religion, sex, national origin, age, disability, and genetic information. So tell us about any accommodations you need. It’s totally confidential and only used to make sure you feel fully supported at every step.

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. 

DEPT® is a pioneering technology and marketing services company that creates integrated end-to-end digital experiences for brands such as Google, KFC, Philips, Audi, Twitch, Patagonia, eBay and more. Its team of 2,500+ digital specialists across 30+ locations on 5 continents delivers pioneering work on a global scale with a boutique culture. 

Learn more about DEPT®

 

DIVERSITY, EQUITY, & INCLUSION

At DEPT®, we take pride in creating an inclusive workplace where everyone has an equal opportunity to thrive. We actively seek to recruit, develop, nurture, and retain talented individuals from diverse backgrounds, with varying skills and perspectives.

Not sure you meet all qualifications? Apply, and let us decide! Research shows that women and members of underrepresented groups tend not to apply for jobs when they think they may not meet every requirement, when in fact they do. We believe in giving everyone a fair chance to shine. 

We also encourage you  to reach out to us and discuss any reasonable adjustments we can make to support you throughout the recruitment process and your time with us.

Want to know more about our dedication to diversity, equity, and inclusion? Check out our efforts here.

#LI-Remote

Create a Job Alert

Interested in building your career at DEPT®? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...
Select...

Please confirm that you have read and hereby agree and accept the terms of our Privacy Statement.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in DEPT®’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.