Analytics Engineer: SQL, dbt, Redshift & Tableau

FORM Athletica, Inc; Vancouver; Hybrid; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Extended Healthcare

Group Life Insurance

Paid Time Off

Employee Discounts

Counselling Services

Job summary

FORM 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.

This is a hands-on role for someone who can contribute quickly, take ownership of production work and leave

Qualifications

• 3–5 years in analytics development, data engineering or a highly technical analytics role.
• Advanced SQL and dimensional data modelling expertise.
• Hands-on experience building, testing and documenting production data models with dbt.
• Experience with a cloud data warehouse; Amazon Redshift and AWS experience preferred.
• Experience using Git, code review and software development practices in an analytics environment.
• Proficiency in Python for data pipelines, integrations or automation.
• Experience with Tableau or another modern BI platform.
• Ability to troubleshoot data issues across source systems, transformation pipelines and downstream reporting.
• Strong communication skills to translate ambiguous questions into clear 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, reusable analytics datasets.
• Define and maintain metrics such as revenue, MRR, churn, retention and CLV.
• Implement automated data-quality tests, documentation and lineage for trustable data.
• Monitor analytics workflows, investigate failures and improve pipeline reliability.
• Develop and maintain Tableau data sources and dashboards from curated warehouse models.
• Build Python-based data integrations and automation where SQL/dbt aren’t the right tool.
• Improve Git-based development, code review, deployment and CI/CD practices for analytics.
• Collaborate with Analytics, Data Engineering and business stakeholders to translate requirements into durable data products.

Skills

Advanced SQL

dbt

Python

Tableau

Amazon Redshift

AWS

Git

Data Modeling

Data Quality Testing

CI/CD

Stakeholder Communication

Tools

Dagster

Airflow

Fivetran

Job description

FORM 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.

This is a hands-on role for someone who can contribute quickly, take ownership of production work and leave