Analytics Engineer Job at FreshBooks (Toronto)

Analytics Engineer

FreshBooks

Location:
Canada , Toronto

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

86800.00 - 108500.00 CAD / Year

Save Job

Apply Position

Job Description:

As an Analytics Engineer in the Data and Analytics team you will bridge the gap between data engineering and business intelligence, applying best practices to data transformation. You will be responsible for architecting scalable data models, maintaining our modern data stack (dbt), and ensuring the reliability and quality of the data that powers decisions at FreshBooks. You will act as a force multiplier for the team, enabling analysts and stakeholders to self-serve with confidence.

Job Responsibility:

Collaborate with business stakeholders to define conceptual modeling requirements and partner with Data Engineers to align on raw data ingestion. You will translate these inputs into scalable data models that serve as the foundation for the BI layer and downstream analysis
Develop and maintain data transformations using dbt while strictly adhering to analytics engineering best practices. You will ensure code stability by utilizing version control, pull requests, and CI/CD pipelines
Write and monitor automated data quality tests (e.g., dbt tests) to catch schema changes or null values early. You will troubleshoot pipeline failures and ensure the reliability of the data landing in our warehouse
Uphold data governance and engineering best practices within the transformation layer. Proactively identify gaps in test coverage, documentation, or PII tagging, and implement automated solutions (such as SQL linting or CI checks) to ensure code reliability and maintainability
Contribute to the evaluation and selection of new tools and technologies, assessing their potential impact on the data ecosystem and business outcomes
Optimize data warehouse performance and costs, refactoring expensive queries, implementing incremental models, and tuning clustering/partitioning keys to ensure reports load instantly for end users
Enforce engineering best practices within the data stack, conducting code reviews to ensure SQL standards, readability, and the "Don't Repeat Yourself" (DRY) principles are maintained across the repository
Responsible for the maintenance and upkeep of tools, processes and codes within the data stack
Develop and maintain comprehensive documentation for the data models you build, including detailed ERD’s, data dictionaries, lineage mapping, transformation logic, and business glossaries, serving as a resource for the wider data community
Contribute to the creation and maintenance of intellectual property (data models, processes) and analyze/apply information from the broader data ecosystem
Collaborate closely with BI Analysts, acting as a technical resource to help them understand data structures, optimize their queries, and adopt best practices for self-service analytics

Requirements:

Advanced SQL proficiency, including query optimization and complex window functions
3-5 years of experience in analytics engineering, business intelligence, or data warehousing
Strong practical experience with dbt, including version control (Git) and CI/CD workflows
Solid understanding of dimensional data modeling
Familiarity with cloud data warehouses such as BigQuery, Snowflake, or Redshift
Ability to translate abstract business concepts into efficient technical data specifications
Knowledge of how BI tools (like Looker or Tableau) consume data models
Exceptional communication skills for collaborating with both Data Engineers and Business Analysts
Ability to adapt communication style for different audiences, contribute to cross-functional discussions, and help build shared understanding in moderately complex situations

What we offer:

Comprehensive health and wellness benefits
Generous time off including a flexible vacation plan
A retirement savings program or pension plan matched to your local office
Stock options for every full-time employee
Parental leave and new parent support
Annual healthy living credit
Comprehensive medical and dental benefits
Fertility and gender-affirming benefits dependent on your region
Peer Recognition Program
Employee Assistance Program
Headphone credit
Meaningful in-person gatherings to bring onsite and remote employees together
Home office credit to set up your home office
Supportive peer group, mentors, and leaders
Comprehensive company onboarding
Career development through continuous coaching, training, and learning on the job

Additional Information:

Job Posted:
January 12, 2026

Employment Type:

Fulltime

Work Type:

Hybrid work

FreshBooks - All Job Offers

Job Link Share:

Analytics Engineer

FreshBooks

Location:
Canada , Toronto

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Job Description:

Job Responsibility:

Requirements:

Additional Information:

Job Posted:
January 12, 2026

Looking for more opportunities? Search for other job offers that match your skills and interests.

Similar Jobs for Analytics Engineer

Analytics Engineer, Product Analytics

Senior Analytics Engineer

Senior Analytics Engineer

Senior Analytics Engineer

Senior Analytics Engineer, Business Intelligence

Senior Analytics Engineer, Corporate Strategy