Remote Senior Data Analyst – 3-Month Contract (Ontario)

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

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.