Senior Analytics Developer
Role Overview
Own the modelling and transformation layer that turns warehouse data into reusable, trusted data products.
Partner with Product, Development, Analytics, and Business teams to create semantic models, self-serve datasets, and tools.
Use AI-assisted and agentic coding tools while retaining human accountability for quality, security, correctness, and business meaning.
Key Skills for This Role
Full Job Posting
Position overview
Own the modelling and transformation layer that turns warehouse data into reusable, trusted data products.
Partner with Product, Development, Analytics, and Business teams to create semantic models, self-serve datasets, and tools.
Use AI-assisted and agentic coding tools while retaining human accountability for quality, security, correctness, and business meaning.
Key responsibilities
- Build scalable analytical models and transformations using SQL, dbt, Dagster, and modern warehouse patterns.
- Define model structures, relationships, dimensions, snapshots, incremental strategies, and materializations.
- Create reusable metrics, semantic definitions, and datasets for BI, experimentation, product analytics, and AI workflows.
- Develop reliable ELT workflows and apply production practices including testing, observability, lineage, documentation, governance, version control, and CI/CD.
- Analyze product and business performance, create machine-readable business context, and use and validate AI-generated code.
- Mentor developers and analysts in modelling, SQL, metrics, testing, documentation, and responsible AI-augmented development.
Requirements
- English proficiency for daily communication with international colleagues and partners.
- 5+ years of relevant analytics, data, or BI development experience.
- Advanced SQL and relational and dimensional modelling expertise.
- Production transformation experience with dbt or a comparable framework on a modern cloud warehouse or lakehouse.
- Experience with tests, documentation, lineage, version control, CI/CD, observability, governance, privacy, and access controls.
- Ability to govern business metrics, semantic models, and reusable datasets used across teams or products.
- Strong product and business acumen; proficiency in Python and AI-assisted or agentic development workflows.
- Excellent communication and collaboration skills for explaining technical choices and data limitations.
Preferred experience
- Snowflake is given as an example of a modern cloud warehouse; Dagster is used in the role’s tooling description.
- The French-language description also mentions cloud platforms, ETL/ELT pipelines, orchestration, end-to-end project delivery, and Snowflake, dbt, and Dagster as an asset in that description.
Workplace and flexibility
- The posting describes a Montreal headquarters and opportunities to work from anywhere, but does not state a specific hybrid schedule.
Benefits
- Benefits include health and dental coverage, RRSP matching, a paid STM pass, flexible schedules, work-from-anywhere opportunities, year-end shutdown, and flex days.
- Montreal headquarters amenities include a cafeteria allowance, gym access, and a rooftop terrace with seasonal sports facilities.
Hiring process
- The hiring process includes a screening call, a technical session, and a final interview; the process may change based on team needs.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Stay22
Senior Technical Product Manager – Integrations
, CAN
Stay22 is seeking a senior technical product manager to own the direction and delivery of its travel supplier integrations. The role requires 7+ years in product management, strong technical fluency with APIs and data fl
Senior Technical Product Manager – Integrations
Montréal, CAN
Stay22 is seeking a senior technical product manager to own the direction and roadmap for travel supplier integrations, from APIs and data ingestion to attribution, reporting, and reliability. The role coordinates engine
Sr DevOps / Platform Developer
, CAN
Stay22 is seeking a senior DevOps and platform developer to build and operate scalable cloud infrastructure for its platform. The role focuses on GCP, Kubernetes, infrastructure as code, CI/CD, monitoring, security, and
Chief of Staff
Montréal, CAN
Stay22 is seeking a Chief of Staff to partner with its executive team, translate company priorities into results, and lead cross-functional initiatives and operating cadence. Candidates need 5+ years in strategy, consult
Senior Technical Engineering Manager
Montréal, CAN
Stay22 is seeking a Senior Technical Engineering Manager to lead two engineering squads across product and platform initiatives. The role combines people leadership, technical direction, project delivery, and approximate
Senior Technical Product Manager – Integrations
, CAN
Senior Technical Product Manager – Integrations
Montréal, CAN
Sr DevOps / Platform Developer
Montréal, CAN
Sr DevOps / Platform Developer
, CAN
Chief of Staff
Montréal, CAN
Chief of Staff
Montréal, CAN
Senior Technical Engineering Manager
Montréal, CAN
Senior Technical Engineering Manager
Montréal, CAN