Analytics Developer

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

Benefits offered by this job

Extended Healthcare

Life Insurance

Paid Time Off

Employee Discounts

Counselling

Job summary

FORM in Vancouver is seeking an experienced Analytics Developer to strengthen our analytics data foundation and BI capabilities. You will work primarily with SQL, dbt, Amazon Redshift and Tableau to transform product, subscription, ecommerce and financial data into trusted models and clear dashboards.

This hands-on role requires ownership of production work, thorough testing, documentation, and collaboration with Analytics, Data Engineering and business stakeholders to deliver durable data

Qualifications

• 3 - 5 years of experience in analytics development or similar technical analytics role.
• Advanced SQL and dimensional data modelling required.
• Hands-on production data modeling with dbt.
• Experience with a cloud data warehouse (Redshift/AWS preferred).
• Experience with Git, code review and analytics development practices.
• Proficiency in Python for data pipelines/automation.
• Experience with Tableau or similar BI platform.
• Ability to troubleshoot data issues across sources and pipelines.

Responsibilities

• Build and maintain scalable SQL and dbt models in Amazon Redshift.
• Transform data across product, subscription, ecommerce, marketing and finance into reusable analytics datasets.
• Define and maintain key metrics (revenue, MRR, churn, retention, LTV, sales performance).
• Implement automated data-quality tests, documentation and lineage for trustable data.
• Monitor analytics workflows, investigate failures and improve pipeline reliability.
• Develop Tableau data sources and dashboards from curated warehouse models.
• Create Python-based data integrations and automation where needed.
• Improve Git-based development, deployment, and CI/CD for analytics.
• Collaborate with Analytics, Data Engineering and stakeholders to translate requirements into durable data products.

Skills

Advanced SQL

dbt

Python

Tableau

Git

Redshift

Data modelling

AWS

Data quality

Tools

Amazon Redshift

Tableau

Job description

A Little Bit About Us

Founded in Vancouver in 2016, FORM is the sports technology company behind the award-winning FORM Smart Swim Goggles. Since launching in 2019, our goggles have earned global recognition, including Red Dot, iF Design, and Global Triathlon awards, and are trusted by professional athletes, age-group triathletes, and swimmers looking to get better.

We’re a talented, tight-knit team that’s fun to work with and serious about building great products. Together, we bring decades of consumer product experience spanning sports eyewear, interface design, and activity-tracking algorithms.

To learn more, visit formswim.com

Position Overview

We’re 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 well-tested, documented systems and intuitive reporting behind.

Primary 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 consistent business metrics, including revenue, MRR, churn, retention, trial conversion, customer lifetime value and sales performance.
• Implement automated data-quality tests, documentation and lineage so stakeholders can trust and understand the data.
• Monitor scheduled analytics workflows, investigate failures and improve pipeline reliability.
• Develop and maintain Tableau data sources and dashboards using curated warehouse models.
• Build Python-based data integrations and automation where SQL and dbt are not the right tools.
• Improve Git-based development, code review, deployment and CI/CD practices for analytics.
• Partner with Analytics, Data Engineering and business stakeholders to translate requirements into durable data products.

Required Skills and Qualifications

• 3 - 5 years of experience in analytics development, data engineering or a highly technical analytics role.
• Advanced SQL skills and strong knowledge of dimensional data modelling.
• Hands-on experience building, testing and documenting production data models with dbt.
• Experience working with a cloud data warehouse; Amazon Redshift and AWS experience are preferred.
• Experience using Git, code review and software development practices in an analytics environment.
• Working proficiency in Python for data pipelines, integrations or automation.
• Experience with Tableau or another modern business intelligence platform.
• Ability to troubleshoot data issues across source systems, transformation pipelines and downstream reporting.
• Strong communication skills and the ability to turn ambiguous business questions into clear, maintainable data solutions.

Nice to Haves

• Experience with Dagster, Airflow or another workflow orchestration platform.
• Experience with Fivetran or other managed data ingestion tools.
• Experience with subscription, ecommerce, product telemetry or financial data.
• Experience working in a fast-paced startup or consumer technology environment.

We thank you for your interest in FORM and to everyone who took the time to apply for this position, however, only qualified applicants will be contacted.

FORM is committed to cultivating and preserving a culture of diversity and inclusion. We recognize that we are better able to achieve our goals and live our core values when we have a diverse team of employees. We are an equal opportunity employer and do not discriminate against any employee or applicant for employment. We welcome the unique contributions that you can bring in terms of your education, opinions, race, colour, place of origin, religion, family status, marital status, physical or mental disability, sex, age, sexual orientation, or political beliefs.

• Extended Healthcare Plan (Medical, Disability, Dental & Vision)
• Group Life - AD&D - Critical Illness Insurance
• Paid Time Off Benefits
• Employee Discounts
• Employee Assistance Program - Counselling

This role has an annual salary range of$90,000 to $110,000. Most new hires do not start at the top of the range. Compensation is determined based on a candidate's experience, skills, qualifications, and overall alignment with the role.

Candidates who are newer to this level of responsibility but demonstrate strong potential may receive an offer toward the lower end of the range. Offers at the higher end are typically reserved for candidates with extensive, directly relevant experience and a proven track record of success in comparable roles and environments.