Senior Analytics Engineer

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

📋 Description

• Design, develop, and enhance scalable dimensional data models and marts utilizing dbt.

• Construct and expand Forward's semantic layer and metrics standards to ensure that key business KPIs are defined once, governed clearly, and consistently utilized across dashboards, models, AI agents, and downstream products.

• Assist in establishing the data foundation that powers AI at Forward by contributing high-quality models, metadata, and governance that render Snowflake Intelligence and other AI/agent use cases reliable and production-ready.

• Propel Forward's data centralization vision by collaborating with BI, Data Science, Data Engineering, and Product teams to consolidate sources of truth and eliminate fragmented business logic.

• Serve as the main point of contact with the Data Science team to interpret features into production-ready data variables necessary for training and validating predictive models.

• Work closely with the Data Engineering team to guarantee the robust and reliable deployment and orchestration of data variables that support production machine learning models.

• Collaborate with the Core Technology teams on internal application schema alterations and data migrations, ensuring rigorous data accuracy validation while minimizing disruptions to downstream analytical models.

• Partner with the DevOps team to oversee, maintain, and contribute to our independent, high-performance streaming pipelines designed for real-time analytics use cases.

• Enhance team code quality by acting as a technical reviewer for Analytics team pull requests, mentoring junior members, and enforcing strict compliance with internal standards for style, maintainability, performance, and modern best practices.

• Assess, integrate, and operationalize high-value third-party data sources to strategically enrich and broaden the overall data ecosystem.

• Advocate for data governance and quality across the data platform, incorporating automated dbt tests, comprehensive data cataloging, lineage, and adherence to security and regulatory standards, ensuring that stakeholders and AI systems can both depend on the numbers.

⛳️ Requirements

• Over 4 years of experience in Analytics Engineering, Data Engineering, or Business Intelligence.

• More than 2 years of hands-on experience in developing and maintaining production-level data transformation pipelines using dbt or equivalent scripting experience in Python.

• At least 2 years of experience with a cloud-based data warehouse such as Snowflake or Redshift.

• Advanced skills in SQL and dimensional data modeling, with a proven history of building models that are durable, well-tested, and user-friendly for downstream consumers.

• Proven capability to swiftly translate complex business needs and ambiguous requirements into robust, scalable technical data solutions.

🏝️ Benefits

• Medical coverage.

• Dental insurance.

• Vision benefits.

• Flexible time-off policy.

• Paid parental leave.

• RRSP matching.

• Wellness reimbursement.

• Volunteer days.

• Annual professional development budget.

• Charitable donation matching.