Engineering
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, a