Senior Analytics Developer

Location: Montreal

Based in Montreal, Stay
22 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 Stay
22, 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 Stay
22 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,…