Overview

Canada
Appfire is a rapidly growing SaaS company headquartered in Canada, offering remote work across 28 countries. We develop award‑winning products such as Appfire Flow, JXL, Comala Document Management, 7Pace Time Tracker, Jira Misc Workflow Extensions, and BigPicture. We are looking for an experienced Senior Analytics Engineer who will build and manage the company‑wide data asset in Snowflake from ground up data sources.

What You Will Do

- Understand decision needs by interfacing with fellow Analytics Engineers, Data Engineers, Data Analysts, and Business Partners
- Architect, build, and launch efficient and reliable data models and pipelines in partnership with Data Engineering, leveraging DBT and Snowflake
- Design and implement metrics and dimensions that enable self‑service analysis and structured views of Appfire’s KPIs, scaling trust, accountability and decision impact
- Define and share best practices on metric, dimension, and data model development and definitions for analytics use cases

What We Would Like to See

- 5+ years of relevant industry experience
- Passion for high data quality and impactful analytics engineering work
- Expert SQL skills for data modeling and query optimization
- Extensive experience with self‑service, advanced analytics, semantic and metrics layers
- 3+ years of experience with Python and DBT
- Strong understanding of data warehousing concepts and best practices
- Efficient problem‑solving and analytical skills
- Proven ability to succeed in both collaborative and independent work environments at a remote‑work company




- Proven experience managing concurrent complex data projects from start to finish
- Continuous learner with an eye on industry trends and new technologies
- Excellent communication and documentation skills with the ability to explain technical concepts to a non‑technical audience
- Ability to effectively leverage AI tools and techniques to enhance dbt development, increase efficiency, and strengthen documentation

Preferred Qualifications

- Experience with dbt (Data Build Tool) and its implementation for data transformation and modeling
- Proven experience with data wrangling and designing/developing end‑to‑end SDLC, owning stakeholder management, expectation setting, prioritization, development and delivery
- Proficiency in source code management tools such as GIT, BitBucket, etc.
- Experience working with Cloud Technologies (AWS, GCP, Azure)
- Experience working with semi‑structured data formats (e.g., JSON)
- Experience building data solutions for future scale and analytics use‑cases
- 3+ years of development experience on industry standard BI tools
- Machine‑learning analytics engineering experience a plus

What Do We Offer





- Work in a product‑first SaaS B2B environment focused on building and scaling solutions for large enterprise customers
- Deliver meaningful, high‑impact work that directly influences product direction and customer success
- Every Appfire team member is eligible for company equity, fostering a true sense of ownership and connection to our growth
- Paid time off: 25 days per year, increasing to 30 days per year after five years of employment
- Comprehensive health coverage through Empire Health, including medical, dental, and vision insurance; additional protection includes life insurance, critical illness coverage, accidental death and dismemberment, and long‑term disability insurance
- A yearly sport allowance of CAD 600 for fitness or outdoor activities (e.g., gym memberships, sports equipment)
- Volunteering: every employee receives three fully paid days each year to participate in Appfire Town, our Corporate Social Responsibility program supporting local communities

Equal Employer Prospect (EEO)

Appfire is an equal opportunity employer and does not discriminate based on race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, veteran status, or any other protected characteristic as defined by applicable law. Our commitment extends to all employment practices, including recruitment, hiring, training, promotion, compensation, benefits, and termination.

#J-18808-Ljbffr

📌 Senior Data Analytics Engineer - Data Insights (Ottawa)
🏢 Appfire
📍 Ottawa