{bc}
indeed

Senior Analytics Developer

Stay22
Quebec, CAN
Senior
Hybrid
Discovered 1 weeks ago
SQLRelational and dimensional data modellingdbt or comparable transformation frameworkCloud data warehouse or lakehousePythonEnglish

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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Stay22