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 patternsDefine keys, joins, facts, dimensions, snapshots,



and incremental strategiesTranslate business concepts into semantic models and reusable datasetsMaintain reliable ELT workflows from internal and third-party sourcesApply testing, lineage, documentation, governance, and CI/CD practicesRequirements:
Five or more years in analytics or data developmentAdvanced SQL and relational or dimensional modelling expertiseProduction dbt experience on Snowflake or comparable warehouseProficiency in Python and AI-assisted development workflowsEnglish proficiency for daily international communicationApply your SQL, dbt, modelling, and governance expertise to build trusted analytical products at Stay22 in Montreal.
#J-18808-Ljbffr

📌 Senior Analytics Developer Sql Dbt (Winnipeg)
🏢 Stay22
📍 Winnipeg