Senior Data Engineer (Graph focused), Fixed Term - Toronto

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. The Role: The Senior Data Engineer will be a core technical contributor on the evaluation team within one of our most relevant clients in AMER. Will be responsible for determining whether an enterprise-scale knowledge graph requires a purpose-built graph database or whether PostgreSQL can carry the load. The work is hands-on and benchmark-driven — measured results, not opinions. What You’ll Do: * Pull data from Databricks, transform it, and load it into multiple graph database candidates — then tear them down and do it again under controlled, repeatable conditions * Build and manage relationship structures and entity linkages within each graph database to mirror real production data models * Implement benchmark queries in each technology's native language (Cypher, GSQL, nGQL, AQL, openCypher) and as PostgreSQL recursive CTEs for the baseline * Build APIs against each candidate to evaluate real-world query performance across use cases * Contribute scored candidate evaluations and written analysis to a final technology recommendation presented to engineering and architecture leadership What You Bring: * Databricks fluency * Hands-on experience with at least two graph databases — Neo4j and/or TigerGraph strongly preferred — and working proficiency in Cypher at minimum * Strong PostgreSQL skills: recursive CTEs, materialized views, query plan analysis, index strategy * Comfort spinning up and tearing down database environments repeatedly in a structured evaluation context * Experience designing and executing structured technology benchmarks at enterprise scale * Bonus: KYC/AML domain knowledge, Kubernetes for database workloads, or AWS-native database deployment The anticipated hourly range for this position is $90 hourly. Rate is based on a range of factors that include relevant experience, expertise, and organizational impact. This is based on a 40-hour workweek and leveling. Keep in mind, we're flexible. 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 [https://www.deptagency.com/the-good-company/becoming-a-good-company/] company passionate about purpose-driven work [https://www.deptagency.com/the-good-company/]. 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® [http://www.deptagency.com] 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 [https://www.deptagency.com/the-good-company/]. #LI-Remote

The Senior Data Engineer will evaluate whether an enterprise-scale knowledge graph requires a purpose-built graph database or PostgreSQL. This involves building benchmarks, implementing queries in various native languages, and providing a final technology recommendation to leadership.

Candidates must be fluent in Databricks and have hands-on experience with at least two graph databases, specifically Neo4j or TigerGraph. Strong PostgreSQL skills, including recursive CTEs and index strategy, are required.

• 15 Days Holiday • 10 Paid Sick Days • Flexible Hybrid Working Policy • Buddy Program • Training And Development • Certifications • Office Perks • Free Snacks • Team Events

• PostgreSQLPreferred

Identified from the job description. Confirm important requirements above.

• Databricks
• Neo4j
• TigerGraph
• Cypher
• PostgreSQL
• Recursive CTEs
• Graph Database Design
• API Development
• Technology Benchmarking
• Query Plan Analysis

• Data & Analytics
• Technology
• Engineering
• Software
• Consulting

Minimum experience

5+ years

Posting language

English

Working hours

40 hours per week