Analytics Engineer

Propel Holdings•Toronto, ON

12d•CA$65,000 - CA$85,000

About The Position

As an Analytics Engineer, reporting to the Director, Business Analytics Engineering, you’ll be part of a centralized BAE team that supports all departments including Operations, Marketing, Compliance, Finance, and Risk. You’ll collaborate closely with stakeholders to understand their data needs, design efficient and reliable data pipelines, and deliver dashboards and insights that power smarter decisions. This is not your typical reporting role — you’ll be helping shape how Propel leverages modern data stack tools like Snowflake, dbt Cloud, Glean, and Domo to build scalable, intelligent solutions including next-generation Snowflake AI-driven analytics.

Requirements

Bachelor’s degree in Computer Science, Finance, Economics, Analytics, Business, Math, Statistics, or a related field.
5+ years of hands-on analytical experience in a professional or business setting, ideally within fintech or a fast-paced data-driven organization.
Advanced SQL skills with proven experience querying and transforming large datasets in Snowflake or similar data warehouses.
Strong data visualization and storytelling skills using tools like Domo, Tableau, or Power BI.
Experience with data transformation and modeling (e.g., dbt).
Excellent problem-solving and critical-thinking skills — you don’t just answer questions, you help people ask better ones.
Strong communication skills — able to collaborate effectively with technical and non-technical stakeholders.
Proven ability to manage multiple priorities and deliver high-quality work under tight timelines.
Ability to integrate or adopt AI tools in day-to-day tasks

Nice To Haves

Experience using generative AI tools (e.g., ChatGPT, Claude, Copilot) is an asset

Responsibilities

Design, build, and maintain scalable analytics data models and transformations in dbt Cloud and Snowflake.
Develop reliable, reusable datasets and business-ready data products that support reporting, analysis, experimentation, and operational decision-making.
Improve the structure, quality, and maintainability of Propel’s analytics engineering ecosystem, with a focus on consistency, performance, and trust.
Help define and evolve Propel’s semantic layer, core metrics, and business logic so teams are aligned on how performance is measured.
Lead efforts to document, standardize, and centralize key business definitions within a governed data dictionary.
Partner with cross-functional stakeholders (Product, Operations, Marketing, Finance, Risk, Compliance) to understand business objectives and translate them into scalable data solutions.
Build and maintain dashboards and reports that clearly answer key business questions and drive decision-making.
Identify trends, patterns, and opportunities through creative analysis and critical thinking.
Troubleshoot and optimize SQL queries and pipelines for efficiency and reliability.
Contribute to the development of AI-powered analytics and data enrichment initiatives within Snowflake.