Senior Analytics Developer

Stay22; Montreal (administrative region); On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Cafeteria allowance

Gym access

RRSP matching

Transit pass

Team events

Job summary

Stay22, based in Montreal, is seeking a Sr Analytics Developer to own the modelling and transformation layer turning warehouse data into reusable data products. You will partner with Product, Development, Analytics, and Business teams to drive product and business decisions, from user experience to revenue metrics.

This role combines advanced SQL and development practices with AI-assisted tooling, ensuring data quality, governance, and business meaning while mentoring the team.

Qualifications

• 5+ years in analytics or data development with strong modeling skills.
• Advanced SQL skills and experience with cloud data warehouses.
• Hands-on dbt/Lakehouse development and data governance experience.
• Proficiency in Python and AI-assisted development workflows.

Responsibilities

• Design, build, and evolve scalable analytical models and transformations.
• Define grain, keys, facts, dimensions, and materializations balancing usability and cost.
• Translate business concepts into reusable metrics and datasets for BI and AI workflows.
• Partner with cross-functional teams to identify problems and opportunities.
• Build reliable ELT pipelines, ensure data quality, observability, and governance.
• Mentor peers on modelling, SQL quality, and responsible AI development.

Skills

Advanced SQL

dbt

Dagster

Snowflake

Python

Data modelling

Governance & quality checks

AI-assisted development

Stakeholder communication

Tools

dbt

Dagster

Snowflake

Python

Job description

Based in Montreal, Stay22 helps ambitious creators and intent-rich digital platforms turn their existing traffic into incremental revenue, with technology that works quietly in the background.

Today, more than 6,500 creators and platforms rely on Stay22, with over $1 billion in annual transactions flowing through the platform. Originally built for travel, the company now supports partners across retail, lifestyle, publishing, events, and transport as it expands its monetization infrastructure for the modern creator economy.

Position overview

The Data team at Stay22 transforms raw data into trusted insights that drive product and business decisions. As a Sr Analytics Developer, you will own the modelling and transformation layer that turns warehouse data into reusable data products. Modelling is central to your work: defining entities, grain, relationships, facts, dimensions, and governed metrics that stakeholders can trust.

You will partner with Product, Development, Analytics, and Business teams to solve problems and uncover opportunities—from improving user experience and product performance to increasing conversion, partner revenue, and operational efficiency. You’ll translate these needs into semantic models, and self-serve datasets and tools that help teams decide and act fast.

This role combines advanced SQL and development practices with strong product and business acumen. You’ll use AI-assisted and agentic coding tools to accelerate delivery while retaining human accountability for quality, security, correctness, and business meaning.

Key responsibilities

• Design, build, and evolve scalable analytical models and transformation workflows using SQL, dbt, Dagster and modern warehouse patterns.
• Define model grain, entities, keys, join paths, facts, dimensions, snapshots, incremental strategies, and materializations that balance usability, performance, and cost.
• Translate business concepts into reusable metrics, semantic definitions, and analytical datasets for BI, experimentation, product analytics, and AI-enabled workflows.
• Partner with Product, Development, Revenue, Marketing, Operations, and Analytics to identify business problems and opportunities, including instrumentation, funnels, activation, engagement, conversion, retention, attribution, and revenue metrics.
• Build and maintain reliable ELT and transformation workflows from internal and third-party sources, working closely with Data Development on ingestion and platform concerns.
• Apply production development practices—including data quality tests, freshness checks, observability, lineage, documentation, governance, version control, CI/CD, and automated validation—to protect trust in analytical products.
• Investigate product and business performance, using reliable models and analysis to explain changes, identify opportunities, recommend next steps, and optimize performance, scalability, cost, and freshness.
• Create machine-readable business context.
• Use AI coding assistants and agentic workflows for exploration, SQL and Python scaffolding, refactoring, test generation, documentation, and impact analysis.
• Validate AI-generated code and analytical logic through profiling, targeted tests, query results, lineage, impact and performance checks, and human review; retain human ownership of metric meaning, modelling, privacy, security, architecture, and production approval.
• Mentor developers and analysts on modelling, SQL quality, metric design, testing, documentation, stakeholder discovery, and responsible AI-augmented development, while staying current with modern analytics practices.

Requirements

• English proficiency is required for daily communication with international colleagues and partners.
• 5+ years of experience in analytics development, data development, BI development, or a closely related role.
• Advanced SQL skills and strong relational and dimensional modelling expertise, including grain, keys, joins, facts, dimensions, incremental processing, and performance trade-offs.
• Hands-on experience building production transformation projects with dbt or a comparable framework on a modern cloud warehouse or lakehouse such as Snowflake.
• Experience applying tests, documentation, lineage, version control, CI/CD, observability, governance, privacy, and access controls to analytical data products.
• Demonstrated ability to define and govern business metrics, semantic models, and reusable datasets used by multiple teams or products.
• Strong product and business acumen.
• Proficiency in Python and AI-assisted or agentic development workflows, with the judgment to validate outputs through testing, profiling, review, and business context.
• Excellent communication and collaboration skills, including the ability to explain modelling choices, analytical trade-offs, and data limitations to non-technical stakeholders.

What to expect during our hiring process

We know your time is valuable, here is a quick look at the next steps:

• Screening call with our Talent Acquisition Partner (30-45 minutes)
• Techncial session with a member of the Data Team and Manager (60 minutes)
• Final interview with our CEO (30 minutes)

Note: this process may evolve based on the team's needs.

• Prime Montreal Location: Work from our vibrant Little Italy HQ with a cafeteria allowance, full gym access, and a rooftop terrace complete with a seasonal basketball/pickleball court & hockey rink.
• Comprehensive Benefits: Health & dental coverage, RRSP matching, fully paid STM pass', and regular team socials, events, and retreats.
• Flexibility That Works: Flexible schedules, work-from-anywhere opportunities, year-end shutdown, and flex days.

(Stay22 is an equal-opportunity employer. All qualified applicants are given consideration. If you have a disability or particular need that requires accommodation, please contact us at [e-mail])