Senior Data Analyst, Fixed Term - Toronto

DEPT; Amsterdam; On-site; EUR 61,000 - 71,000; Full time

Job summary

DEPT in Ontario, Canada is seeking a Senior Data Analyst to transform raw data into trusted, well-modeled datasets using dbt, and to design, build, and validate customizable dashboard templates atop them. You will collaborate with product, client-facing teams, and engineering to turn client use cases into reliable dashboards.

You will gather requirements from relationship managers, build production dashboards in an enterprise BI platform, apply advanced SQL, and ensure data quality across

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
• Strong documentation habits
• 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 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.

Skills

Senior Data Analyst

Dashboards

dbt

Advanced SQL

Dimensional modeling

Git

Cloud data warehouse

Requirements gathering

Stakeholder communication

Tools

dbt

Git

Job description

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.

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
• Strong documentation habits
• 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.

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.

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.