Staff Data Engineer

commonsku

. Architect and maintain a reliable, seamless, high-impact analytics layer across product and operational units .

Posted 9/23/2026full-timeRemote • CanadaLead💰 CA$160,000 - CA$180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analytics engineering and data transformation, with a strong focus on SQL, dbt, and cloud data warehousing using Snowflake. Proven ability to mentor teams and drive technical initiatives from conception to execution while leveraging AI-assisted development tools.

Highest-signal resume keywords

8+ Years Experience In Analytics EngineeringStrong Production Experience With SQLProficiency In Python For Analytics ToolingExperience With Fivetran For Managed IngestionDesigning BI Environments In Metabase

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLDbtPythonDimensional ModelingRelational DatabasesFivetranSnowflakeMetabaseData TransformationData Engineering

Soft Skills

MentoringCustomer EmpathyTechnical JudgmentContinuous GrowthFeedback Dedication

Tools & Technologies

FivetranSnowflakeMetabaseAI Coding AssistantsCursorCodeRabbitClaude

Industry Keywords

SaaSProduct-Driven EnvironmentAnalytics LayerSelf-Serve AnalyticsData Marts

Tech Stack

Tools & technologies

CloudPythonSQL

About the role

Key responsibilities & impact

Architect and maintain a reliable, seamless, high-impact analytics layer across product and operational units
Guide key initiatives from inception through completion using robust software design principles
Transform raw transactional records into star schemas covering orders, distributors, suppliers, catalog offerings, and financial workflows
Identify and fix sluggish queries, unoptimized transformations, and testing blind spots
Oversee automated Fivetran syncs and adapt to schema modifications
Establish and safeguard standardized logic within dbt data marts
Build Snowflake and Metabase layers for self-serve analytics access
Conduct complex exploratory data deep dives
Mentor engineers and analysts through reviews and ongoing support
Partner with product leads and engineering managers to translate strategy into technical milestones
Use AI coding assistants including Cursor, CodeRabbit, and Claude with human verification
Contribute to distributor benchmarks and AI-powered query access for company-wide decision-making

Requirements

What you’ll need

8+ years of experience in analytics engineering, data engineering, or a closely related role
Experience ideally within a SaaS or product-driven environment
Strong production experience with SQL, dbt, and a cloud data warehouse such as Snowflake or comparable
Proficiency in Python for analytics tooling and automation
Deep understanding of dimensional modeling and relational databases
Experience with managed ingestion using Fivetran
Experience designing BI environments in Metabase for self-serve use
Proven track record of mentoring and developing engineers or analysts
Strong technical judgment and pragmatic business tradeoff skills
Customer empathy and dedication to continuous growth and feedback
Experience using AI-assisted development tools effectively
Experience using Snowflake AI tooling or similar
Eligible to work in Canada, excluding Quebec

Benefits

Comp & perks

Remote-first culture with in-person experiences
Company-wide closure between December 25th and January 1st
Health and dental benefits
$1,000 healthcare spending account
RRSP/TFSA contributions up to $3,000 a year, with no employee contribution required
Twice-yearly company-wide summits
Delightful team of smart people
Equal opportunity workplace
AI-assisted application support and human-reviewed hiring process