Advanced SQL and dimensional modelling define this Senior Analytics Developer role at Stay22, based in Montreal with international collaboration. Build trusted data products.
As a senior member of Stay22’s Data team, you will own modelling and transformation layers for reusable analytical products. You will define entities, grain, relationships, facts, dimensions, and governed metrics. Your work supports BI, experimentation, product analytics, and AI-enabled workflows.
Key Responsibilities: Design scalable analytical models with SQL, dbt, Dagster, and warehouse patterns
Define keys, joins, facts, dimensions, snapshots, and incremental strategies
Translate business concepts into semantic models and reusable datasets




Maintain reliable ELT workflows from internal and third-party sources
Apply testing, lineage, documentation, governance, and CI/CD practices
Requirements: Five or more years in analytics or data development
Advanced SQL and relational or dimensional modelling expertise
Production dbt experience on Snowflake or comparable warehouse
Proficiency in Python and AI-assisted development workflows
English proficiency for daily international communication
Apply your SQL, dbt, modelling, and governance expertise to build trusted analytical products at Stay22 in Montreal.

#J-18808-Ljbffr

📌 Senior Analytics Developer SQL dbt (Quebec City)
🏢 Stay22
📍 Quebec City