DEPT®
Senior Data Analyst (Graph focused), Fixed Term - Toronto
Toronto Canada · Senior
Sponsorship not specifiedDetected 1 day ago
SQLPostgreSQLDatabricksSparkData EngineeringStatisticsResearchCommunicationVariance Analysis
About the role
- The Senior Data Analyst is a hands-on analytical contributor embedded in the engineering team.
- 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.
Responsibilities
- Validate datasets loaded into each technology to confirm completeness, accuracy, and structural integrity relative to source data in Databricks and CDS
- Identify, document, and trace the root cause of data discrepancies and defects discovered during validation
- 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
- 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
- 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
Requirements
- 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
- Ability to interpret benchmark result data and distinguish meaningful performance differences from noise
- 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
- Rate is based on a range of factors that include relevant experience, expertise, and organizational impact.
- 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.
- 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.
- 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)
Nice to have
- Strong SQL skills
- ability to write analytical queries against relational databases (PostgreSQL experience preferred)
Skills
- This is a 3 month fixed term salaried contract, located in Ontario Canada.
- Preferably in Toronto.
- 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
Company info
- 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
Visa & Work Authorization
- 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.
This listing is sourced directly from DEPT®'s careers page and normalized into a canonical job model.