About the role
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
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. 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