Senior Data Analyst, Fixed Term - Toronto

DEPT®; United States; Remote; USD 57,000 - 81,000; Full time

Job summary

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

Responsibilities include modeling data, writing advanced SQL, implementing quality checks, and producing client-ready templates with configurable features.

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

Data analysis

Dashboard development

dbt experience

SQL proficiency

Data modeling

Documentation

Stakeholder communication

Independent delivery

Tools

dbt

Git

Cloud data warehouse

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.

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.

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

#LI-Remote