AEP Data Architect — Unified Customer Data (Remote)

Dept Agency; Toronto; Hybrid; CAD 75,000 - 95,000; Full time

Job summary

A leading digital agency in Toronto is seeking an experienced Data Architect to join their team. This role emphasizes customer-centric data modeling, working closely with enterprise clients to optimize data for marketing use cases. Candidates should have strong skills in SQL, ETL tools, and data modeling. The contract is for 3 months with flexible hybrid working arrangements. The agency promotes a collaborative and innovative culture, offering numerous benefits.

Benefits

15 days holiday per annum

10 paid sick days off

Flexible, hybrid working policy

Buddy Program

Opportunity for training and development

Office perks including biweekly breakfasts and snacks

Qualifications

• Ability to design customer-centric database models.
• Experience with ETL tools on large data sets.
• Expertise in data modeling for various types.
• Proficiency in SQL and NoSQL.
• Experience in Data Warehouse concepts.
• Knowledge of process design and documentation.
• Skilled in reporting technologies.
• Software development experience is a plus.
• Exceptional organizational and communication skills.

Responsibilities

• Coordinate closely with Adobe project team and document requirements.
• Conduct data discovery through business process reviews.
• Design and tailor a unified data model from disparate sources.
• Configure Adobe platform data lake and real-time profiles.
• Test schema designs and assist in customer data imports.
• Build, test and schedule marketing customer segments.
• Develop tailored SQL queries for customer insights.
• Track project time and manage billing.
• Learn and innovate on new insights with the Data Architects team.

Skills

Customer-centric database modeling

Data transformation & ETL tools

Data Modeling (Relational, Dimensional, Big Data)

Complex SQL and NoSQL experience

Business Requirements definition

Reporting Technologies (Tableau, PowerBI)

Software development experience

Organizational skills

Communication skills

Proactivity

Education

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

Tools

Informatica

Unifi

Snaplogic

Adobe Experience Platform

REST APIs

Postman

Job description

A leading digital agency in Toronto is seeking an experienced Data Architect to join their team. This role emphasizes customer-centric data modeling, working closely with enterprise clients to optimize data for marketing use cases. Candidates should have strong skills in SQL, ETL tools, and data modeling. The contract is for 3 months with flexible hybrid working arrangements. The agency promotes a collaborative and innovative culture, offering numerous benefits.