Analytics Engineer: SQL, dbt & Tableau

Teck; Vancouver; On-site; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Extended Healthcare Plan (Medical, Dis

Group Life - AD&D - Critical Illness

Paid Time Off Benefits

Employee Discounts

Employee Assistance Program - Counsell

Job summary

FORM, founded in Vancouver, is seeking an experienced Analytics Developer to strengthen FORM’s analytics data foundation and business intelligence capabilities.

Working primarily in SQL, dbt, Amazon Redshift and Tableau, you will transform raw product, subscription, ecommerce and financial data into trusted, reusable models and translate those models into clear, decision-ready dashboards and visualizations.

Qualifications

• 3-5 years of analytics development or data engineering experience.
• Advanced SQL and dimensional modeling expertise.
• Hands-on with production data models using dbt.
• Experience with a cloud data warehouse; Redshift and AWS preferred.
• Git, code review and software development practices in analytics.
• Proficiency in Python for data pipelines, integrations or automation.
• Experience with Tableau or a modern BI platform.
• Ability to troubleshoot data issues across source systems and pipelines.
• Strong communication to translate ambiguous questions into data solutions.

Responsibilities

• Build and maintain scalable SQL and dbt models in Amazon Redshift.
• Transform raw product, subscription, ecommerce, marketing and financial data into clean analytics datasets.
• Define and maintain metrics such as revenue, MRR, churn and CLV.
• Implement automated data-quality tests, documentation and lineage.
• Monitor analytics workflows, investigate failures and improve pipelines.
• Develop Tableau data sources and dashboards using curated warehouse models.
• Build Python-based data integrations and automation.
• Improve Git-based development and CI/CD practices for analytics.
• Partner with Analytics, Data Engineering and business stakeholders to translate requirements into durable data products.

Skills

Advanced SQL

dbt models

Python

Tableau

Git

Amazon Redshift

AWS

Dimensional modeling

Data pipelines

Communication

Tools

Amazon Redshift

Git

Job description

FORM, founded in Vancouver, is seeking an experienced Analytics Developer to strengthen FORM’s analytics data foundation and business intelligence capabilities.

Working primarily in SQL, dbt, Amazon Redshift and Tableau, you will transform raw product, subscription, ecommerce and financial data into trusted, reusable models and translate those models into clear, decision-ready dashboards and visualizations.