# Senior Data Analyst, Fixed Term - Toronto

**Company**: DEPT®
**Location**: Toronto
**Experience**: senior
**Job type**: contract
**Salary**: $50 hourly
**Category**: Data Science
**Industry**: Technology

**Apply**: https://job-boards.greenhouse.io/dept/jobs/8315624?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_62b07a87-3ed

## Description

We are pioneers at heart, always leaning forward, thinking of what we can create tomorrow that does not exist today. We are a new model of agency, with a deep skillset in tech and marketing.

As a Senior Data Analyst, you will transform raw data into trusted, well-modeled datasets using dbt, then design, build, and validate the customizable dashboard templates on top of them. You'll work closely with product, client-facing teams, and engineering to turn client use cases into reliable, well-built dashboards.

Responsibilities:

- Gather and document client dashboard use cases with relationship managers and client-facing teams, and translate them into clear reporting requirements.

- Build and maintain data models in dbt, transforming raw source data into staging, intermediate, and reporting layers that power dashboards.

- Design the reporting layer to support client-specific configuration.

- Implement data quality tests, validation checks, and monitoring in the transformation layer.

- Design, build, and test reusable dashboard templates with a configurable layer for client-specific needs.

- Support with demos, requirements capture, and follow-up analysis.

- Validate data accuracy and visual consistency between legacy and migrated dashboards.

- Document models, templates, and configuration clearly and consistently, including dbt model documentation and lineage.

- Track delivery risks, dependencies, and priorities, and communicate status to program leadership.

Requirements:

- 5+ years as a Data Analyst, BI Analyst, Analytics Engineer, or similar role

- 2+ years building production dashboards in an enterprise BI platform

- 2+ years of hands-on dbt experience (models, tests, macros, documentation)

- Advanced SQL, including performance tuning on large datasets

- Proven experience modeling raw, unprepared data for reporting and analytics (e.g., dimensional modeling, star schemas)

- Experience with Git-based version control and code review workflows

- Experience with a cloud data warehouse

- Experience gathering requirements from non-technical and client stakeholders

- Strong documentation habits

- Clear communication, including with senior stakeholders

- Ability to deliver independently in a fast-paced environment with minimal ramp-up

Benefits:

- The anticipated hourly range for this position is $50 hourly.

- 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.

## Skills

### Required
- dbt
- SQL
- data modeling
- dimensional modeling
- star schemas
- Git-based version control
- cloud data warehouse

---

Source: [Apply at job-boards.greenhouse.io](https://job-boards.greenhouse.io/dept/jobs/8315624?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)