At a Glance
- Tasks: Design and build scalable analytical models using SQL and dbt for impactful data products.
- Company: Join Stay22, a dynamic tech company based in Montreal with global collaboration.
- Benefits: Competitive salary, flexible work environment, and opportunities for professional growth.
- Other info: Collaborative team culture with a focus on cutting-edge technology and career advancement.
- Why this job: Make a real impact by transforming data into trusted insights and innovative solutions.
- Qualifications: 5+ years in analytics, advanced SQL skills, and experience with dbt and Python.
The predicted salary is between 108000 - 132000 $ per year.
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.
Senior Analytics Developer SQL dbt in Montréal employer: Stay22
Stay22 is an exceptional employer located in the heart of Montreal's vibrant Little Italy, offering a dynamic work environment that fosters creativity and collaboration. With comprehensive benefits including health and dental coverage, RRSP matching, and flexible work arrangements, employees are empowered to thrive both personally and professionally. The company prioritizes employee growth through mentorship opportunities and a culture that values innovation, making it an ideal place for those seeking meaningful and rewarding careers.
