Senior Data Analyst, Fixed Term - Toronto

DEPT®; Toronto; On-site; CAD 57,000 - 81,000; Full time

Job summary

DEPT® is seeking a Senior Data Analyst for a 3-month fixed-term assignment in Toronto. The role centers on transforming raw data into trusted datasets using dbt, and building customizable dashboard templates for client use cases.

You will collaborate with product, client-facing teams, and engineering to translate requirements into reliable analytics, implement data quality checks, and document models and configurations for governance.

Qualifications

• 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
• Clear communication, including with senior stakeholders
• Ability to deliver independently in a fast-paced environment with minimal ramp-up

Responsibilities

• Gather and document client dashboard use cases and translate them into reporting requirements.
• Build and maintain data models in dbt transforming raw data into staging, intermediate, and reporting layers.
• 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 client-specific configurability.
• 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, including dbt model documentation and lineage.
• Track delivery risks, dependencies, and priorities and communicate status to leadership.

Skills

Data Analytics

BI Analytics

dbt

SQL

Data Modeling

Git Version Control

Cloud Data Warehouse

Requirements Gathering

Stakeholder Communication

Independent Delivery

Tools

dbt

SQL Performance Tuning

Job description

Senior Data Analyst, Fixed Term - 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. 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.

About You:

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.

What You’ll Do:

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

What You Bring:

• 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
• Clear communication, including with senior stakeholders
• Ability to deliver independently in a fast-paced environment with minimal ramp-up

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

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.