Senior Analytics Developer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Design, develop, and enhance scalable analytical models and transformation workflows using SQL, dbt, Dagster, and contemporary warehouse methodologies.

• Define model grain, entities, keys, join paths, facts, dimensions, snapshots, incremental strategies, and materializations.

• Convert business concepts into reusable metrics, semantic definitions, and analytical datasets for BI, experimentation, product analytics, and AI-driven workflows.

• Collaborate with Product, Development, Revenue, Marketing, Operations, and Analytics teams on instrumentation, funnels, activation, engagement, conversion, retention, attribution, and revenue metrics.

• Develop and sustain reliable ELT and transformation workflows from both internal and third-party sources.

• Implement data quality tests, freshness checks, observability, lineage tracking, documentation, governance, version control, CI/CD, and automated validation.

• Analyze product and business performance, clarify changes, identify opportunities, recommend subsequent steps, and optimize performance, scalability, cost, and freshness.

• Generate machine-readable business context.

• Utilize AI coding assistants and agentic workflows for exploration, SQL and Python scaffolding, refactoring, test generation, documentation, and impact analysis.

• Assess AI-generated code and analytical logic through profiling, testing, lineage, impact and performance checks, and human review.

• Guide developers and analysts on modeling, SQL quality, metric design, testing, documentation, stakeholder discovery, and responsible AI-enhanced development.

⛳️ Requirements

• Proficiency in English is essential for daily communication with international colleagues and partners.

• Over 5 years of experience in analytics development, data development, BI development, or a related role.

• Advanced SQL capabilities.

• Strong expertise in relational and dimensional modeling, including grain, keys, joins, facts, dimensions, incremental processing, and performance trade-offs.

• Practical experience in building production transformation projects using dbt or a comparable framework on a modern cloud warehouse or lakehouse like Snowflake.

• Experience in applying tests, documentation, lineage, version control, CI/CD, observability, governance, privacy, and access controls to analytical data products.

• Capability to define and manage business metrics, semantic models, and reusable datasets utilized by multiple teams or products.

• Strong product and business insight.

• Proficiency in Python and AI-assisted or agentic development workflows.

• Ability to validate AI-assisted outputs through testing, profiling, review, and business context.

• Exceptional communication and collaboration skills.

• Ability to articulate modeling choices, analytical trade-offs, and data limitations to non-technical stakeholders.

🏝️ Benefits

• Cafeteria allowance.

• Full gym access.

• Rooftop terrace featuring a seasonal basketball/pickleball court and hockey rink.

• Health and dental insurance coverage.

• RRSP matching program.

• Fully paid STM pass.

• Regular team socials, events, and retreats.

• Flexible working hours.

• Opportunities to work from anywhere.

• Year-end shutdown.

• Flex days.