Analytics Engineer

Position Overview

We’re seeking an experienced Analytics Engineer 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.

Requirements

Required Skills and Qualifications

• 3 - 5 years of experience in analytics engineering, 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 engineering 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.

Benefits

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