Job Title

Adobe Experience Platform Data Architect, Fixed Term - Platforms - Toronto 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. Thats why we hire curious, selfdriven, talented people who never stop innovating. Our culture is big enough to cope and small enough to care. With people across 20+ countries, were big enough to provide the best tools, global opportunities, and benefits that help you thrive, but small enough to invest in you, your growth, your team, and give you the autonomy to solve our clients problems, no matter where you are in the world. About You You are an experienced and proactive Data Architect who specializes in customercentric 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. What Youll 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 customers 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 realtime 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 360degree view of the customer). CONSULTING: As part of a consulting organization, youll 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 customercentric 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 multitask 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 selfmanaged, proactive, and customercentric. A Degree in Computer Science, Information Systems, Data Science or a related field. What We Offer 10 paid sick days off, not prorata. 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 youll get the opportunity to work with clients of all sizes and across all industries. 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. DEPT is an equal opportunity employer (EOE). We believe our work is best when our people feel safe and free to be themselves. Were committed to an inclusive and barrierfree recruitment and selection process and workplace, regardless of anyones lived experience, race, color, religion, sex, national origin, age, disability, and genetic information. Well support any accommodations you need. DEPT participates in EVerify, meaning your Form I9 information will be sent to the federal government to confirm you are authorized to work in the U.S. We are a B Corpcertified company passionate about purposedriven work. We hope 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. #J-18808-Ljbffr