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 Analyst is a hands-on analytical contributor embedded in the engineering team. This role bridges the gap between the data itself and the engineers, product managers, and data analysts building and evaluating the Knowledge Graph. The primary focus is data integrity: validating datasets, verifying query outputs, tracing the root cause of discrepancies, and applying statistical methods to assess data quality across multiple storage technologies.  
This is a practitioner role, not a consulting engagement. The deliverable is evidence — validated results, documented defects, root cause analysis, and statistical assessments that the team can act on.  

What You’ll Do:

• Validate datasets loaded into each technology to confirm completeness, accuracy, and structural integrity relative to source data in Databricks and CDS 
• Verify benchmark query outputs across technologies — confirm that the same logical query against the same underlying data produces consistent, correct results regardless of which system executes it  
• Identify, document, and trace the root cause of data discrepancies and defects discovered during validation; distinguish between ETL issues, schema translation errors, technology-specific behavior, and upstream data quality problems  
• Develop and maintain validation test cases and expected outputs for benchmark queries and compliance use cases  
• Support the collection and documentation of compliance use cases from the business unit  
• Help assess each use case: can it be fulfilled by a conventional database approach, or does it require the traversal and pattern-matching capabilities of a purpose-built graph database?  
• Contribute analytical rigor to use case triage — this is a cost-and-complexity decision as much as a technical one  
• Apply statistical methods to evaluate dataset representativeness, sampling quality, and measurement reliability across benchmark runs  
• Analyze benchmark result distributions — identify outliers, assess variance across cold/warm/concurrent runs, and flag results that require deeper investigation before scoring  
• Produce summary statistics and data quality reports that inform the team's architecture assessment  
• Document validation findings, defect reports, and root cause analyses in a format the engineering team can act on
• Maintain a running record of known data issues and their resolution status across each technology under evaluation

What You Bring:

• Demonstrated experience validating large, complex datasets — identifying discrepancies, tracing root causes, and documenting findings clearly
• Strong SQL skills; ability to write analytical queries against relational databases (PostgreSQL experience preferred)
• Experience working with data at significant scale — hundreds of millions of records — where manual spot-checking is insufficient and systematic validation approaches are required
• Familiarity with ETL pipelines and the types of data quality issues that arise in data loading and transformation
• Practical experience applying statistical methods to data quality assessment: distribution analysis, outlier detection, variance analysis, sampling validation
• Ability to interpret benchmark result data and distinguish meaningful performance differences from noise
• Comfort working across multiple database technologies and query languages — this role will need to query data in PostgreSQL, graph databases, and Databricks as part of normal validation work
• Experience with Databricks or similar distributed data platforms (Spark, Delta Lake)
• Strong written communication — validation findings, defect reports, and root cause analyses must be clear enough for both engineers and product stakeholders
• Ability to work independently under minimal supervision, taking direction from peers rather than requiring structured management oversight
• Experience embedded in a cross-functional engineering team

The anticipated hourly range for this position is $70 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 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