This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
This is a 3 month fixed term salaried contract, located in Ontario Canada. Preferably in Toronto. 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.
Job Responsibility:
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
Requirements:
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 we offer:
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
The opportunity for possibility
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