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 skills, including performance tuning on large datasets
Proven experience modeling raw data for reporting and analytics
Experience with Git-based version control and code review workflows
Experience with a cloud data warehouse
Strong documentation habits
Clear communication skills with senior stakeholders
Ability to work independently in a fast-paced environment
Responsibilities
Gather and document client dashboard use cases with relationship managers and client-facing teams
Build and maintain data models in dbt, transforming raw source data into reporting layers
Design the reporting layer to support client-specific configurations
Implement data quality tests and validation checks in the transformation layer
Design, build, and test reusable dashboard templates for client-specific needs
Support demos, requirements capture, and follow-up analysis
Validate data accuracy and visual consistency between legacy and migrated dashboards
Document models, templates, and configurations clearly and consistently
Track delivery risks, dependencies, and priorities, and communicate status to program leadership
Benefits
Flexible work arrangements
Opportunity to work on impactful projects
Collaboration with cross-functional teams
Exposure to advanced data modeling techniques
Professional development opportunities
Full Job Description
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.
