Senior Data Analyst, Client Reporting

Dialogue; Montreal (administrative region); Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading virtual care provider is seeking a Senior Data Analyst to enhance client reporting data products. The ideal candidate will design and implement scalable data models and translate client needs into actionable insights. This role requires 5+ years of experience in data analytics, strong SQL expertise, and proficiency in Python. Bilingualism in French and English is essential. Join us in improving wellness through innovative data solutions with a hybrid work model based in Montreal.

Benefits

Access to virtual mental health support

Fully funded insurance and health spending account

4 weeks vacation and wellness days

Hybrid work model

Work abroad options

Incentive plans and referral bonuses

Learning and mentorship opportunities

Qualifications

• Strong SQL expertise and ability to design scalable, structured data models.
• Hands-on experience with analytics engineering workflows and tools.
• Proven experience in building and maintaining reliable, well-tested data assets.
• Proficiency in Python for data transformation and automation.
• Excellent communication skills for translating data insights.

Responsibilities

• Write complex SQL queries and design scalable data models.
• Implement strong data quality tests and monitoring.
• Build and evolve client reporting data products.
• Translate business logic into well-defined KPIs.
• Identify data gaps and improve data modeling.

Skills

Strong SQL expertise

Analytics engineering workflows

Proficiency in Python

Excellent communication skills

Education

5+ years of experience in data analytics

Tools

SQL

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