Senior Analytics Developer — AI-Driven Data Engineer (Remote)

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

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.