Senior Data Engineer

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

📋 Description

• Assist in steering projects within the team's domain from conceptualization to execution.

• Transform normalized operational data into well-structured dimensional models (Kimball/star schema) that reflect how commonsku functions across orders, distributors, suppliers, products, and revenue.

• Enhance data reliability and performance by optimizing queries, increasing test coverage, and addressing pipeline reliability challenges.

• Establish and maintain canonical metric definitions in our dbt marts to ensure every dashboard utilized a unified source of truth.

• Create accessible infrastructure in Snowflake and Metabase to empower analysts and business users to confidently answer questions, while also engaging in deep, hands-on analysis when necessary.

• Offer support, direction, and constructive code reviews to our Data Engineer and Data Analyst.

• Collaborate closely with the Manager of Platform and Data, as well as Product Managers, to translate business objectives into a technical roadmap.

• Incorporate AI development tools such as Cursor, CodeRabbit, and Snowflake Intelligence/Cortex to enhance efficiency, while actively validating and refining their outputs.

⛳️ Requirements

• Over 5 years of experience in analytics engineering, data engineering, or a related role, preferably in a SaaS or product-focused environment.

• Extensive production experience with SQL, dbt, and a cloud data warehouse (such as Snowflake or similar), along with proficiency in Python for analytics tooling and automation.

• Comprehensive understanding of dimensional modeling, relational databases, managed ingestion (Fivetran), and designing BI environments (Metabase) for self-service use.

• A demonstrated history of mentoring and developing engineers or analysts, with an emphasis on fostering a healthy, collaborative, and inclusive team culture.

• A balance of technical expertise with practical business considerations, a strong sense of customer empathy, and a commitment to ongoing growth and feedback.

• Experience effectively utilizing AI-assisted development tools and exploring how AI can enhance daily workflows.

• Familiarity with Snowflake AI tooling (or similar) to expedite solutions for business requirements.

🏝️ Benefits

• Remote-first culture (with numerous excellent in-person experiences throughout the year)

• Company-wide closure from December 25th to January 1st

• Health and dental benefits, including a $1,000 healthcare spending account

• RRSP/TFSA contributions up to $3,000 annually (no employee contribution necessary!)

• Biannual company-wide summits (we refer to it as HQ, and you’ll enjoy it)

• A wonderful team of intelligent individuals who excel in their fields