Senior Data Analyst, Client Reporting

Dialogue; Toronto; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

A leading virtual care provider in Canada is seeking a Senior Data Analyst to enhance client reporting through scalable data products. The ideal candidate will have extensive SQL expertise, experience with analytics engineering tools like dbt and Airflow, and strong communication skills to translate complex data into actionable insights. Bilingualism in French and English is essential due to client needs across Canada. This role offers hybrid working arrangements and a supportive workplace focused on well-being.

Benefits

Access to virtual mental health support

Fully funded insurance

4 weeks vacation

Hybrid work model

Incentive plans and RRSP matching

Qualifications

• Strong SQL expertise with modern data warehouse experience.
• Proven ability to design scalable data models.
• Bilingualism in French and English is essential.

Responsibilities

• Write complex SQL queries and design scalable data models.
• Build and maintain data models using modern workflows.
• Implement quality tests to ensure metric accuracy.

Skills

Strong SQL expertise

Hands-on experience with analytics engineering workflows

Proficiency in Python

Excellent communication skills

Strong product and business mindset

Experience building client-facing reporting products

Education

5+ years of experience in data analytics

Tools

dbt

Airflow

Job description

About Dialogue

Dialogue is the #1 virtual care provider in Canada. By developing our Integrated Health Platform🅫, we provide exceptional online health and wellness programs (primary care, mental health, iCBT, EAP, and wellness) to organizations that want to improve the wellness of their employees and families.

When it comes to our work, we set the bar high. Together, we’re transforming health and helping millions improve their well‑being. We’re firm believers that great people don’t settle on:

• Impact
• Community
• Growth
• Excellence

Feel like you can make a difference? Good news, we saved you a seat!

Come as you are. As a proud equal‑opportunity employer, Dialogue is dedicated to creating a diverse and inclusive workplace for everyone. Qualified applicants will be considered regardless of citizenship, ethnicity, race, colour, religion, gender, gender identity or expression, sexual orientation, disability, age, or veteran status. Applicants who require specialized accommodation are encouraged to contact [e-mail].

Your role as Senior Data Analyst

We’re looking for a Senior Data Analyst, Client Reporting to own and evolve the data products that power Dialogue’s client‑facing reports. In this role, you will work across the data stack to transform client and partner needs into scalable analytics features that clearly demonstrate Dialogue’s value, impact, and outcomes.

Our Data team supports Dialogue’s mission through three core pillars:

• Data reliability & quality – ensuring pipelines, metrics, and critical data points are accurate, trusted, and scalable
• Client reporting data products – building and evolving client‑facing analytics that enable self‑serve insights for customers
• Data governance – applying strong change management, documentation, and versioning practices to safeguard key metrics and definitions

As a Senior Data Analyst, you will act as a bridge between clients, partners, and internal teams (GTM, Marketing, Product, Engineering). You will translate business requirements and client feedback into well‑designed reporting features, ship new metrics and insights, and continuously expand the scope, depth, and usability of our client reporting products.

This role is ideal for someone who enjoys owning end‑to‑end data products, from raw data and modeling to client‑facing insights, and who thrives at the intersection of analytics, product, and stakeholder collaboration.

What you’ll be doing

• Write complex, performant SQL queries and design scalable, production‑grade data models
• Design, build, and maintain robust data models using modern analytics engineering workflows and orchestration tools (e.g., dbt, Airflow)
• Implement strong data quality tests, monitoring, and automation to ensure accuracy and reliability of client‑facing metrics
• Translate business logic and client requirements into well‑defined KPIs and metrics
• Build, own, and evolve client reporting data products, enabling self‑serve analytics and actionable insights for customers
• Partner closely with GTM, Marketing, Product, and Engineering to turn client and partner feedback into shipped reporting features
• Identify data gaps, define clear data requirements, and improve underlying data capture and modeling
• Turn complex datasets into clear, insightful narratives that support both internal decision‑making and client understanding

We’d love to hear from you if you have

• Strong SQL expertise with the ability to design scalable, well‑structured data models in a modern data warehouse
• Hands‑on experience with analytics engineering workflows and tools (e.g., dbt, Airflow/Dagster), including version control and production deployments
• Proven experience building and maintaining reliable, well‑tested data assets, with a strong focus on data quality and automation
• Proficiency in Python for data transformation, analysis, and automation, in collaboration with Data Engineering for complex use cases
• Strong product and business mindset, with experience partnering with Product and Engineering to define data requirements and improve data capture
• Excellent communication skills, enabling you to translate complex data into clear, actionable insights for technical and non‑technical audiences
• 5+ years of experience in data analytics, analytics engineering, or related roles, with ownership of production data models
• Experience building or owning client‑facing or external reporting products (e.g., customer dashboards, self‑serve analytics, executive reports)

Please note that as we serve customers across Canada, bilingualism is essential for this position. You may be required to communicate in French and English.

At Dialogue, your well‑being is our priority

Taking care of others also means taking care of our team! Depending on your role and employment status, you could have access to the following benefits:

• Access to the Dialogue app and virtual mental health support for you and your family
• Fully funded insurance, a health spending account, dental coverage, and fitness reimbursement
• 4 weeks vacation, 9 wellness days, and 1 volunteer day
• Hybrid work: 3 days/week in our Montreal or Toronto offices, excluding remote roles
• Work abroad up to 4 weeks/year
• Incentive plans, referral bonuses & RRSP matching
• Learning via Coursera, external training budget & mentorship
• Optional parental leave top‑up