Analytics Engineer
Top Benefits
About the role
About The Role 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.
This role can be worked remotely from the above location. Ad-hoc in person meetings might be required from time to time in our Toronto office.
What You'll Do
- 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.
What You'll Bring
- 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.
Compensation At FreshBooks, we approach each individual's compensation with a promise of fair market value and internal equity commensurate with experience and specific skill set.
The total annual compensation for this role ranges from CA$86,800 to CA$108,500, which may include participation in our incentive programs. Additionally, this position offers an equity grant and immediate enrollment in FreshBooks' comprehensive benefits program, detailed below.
Perks And Benefits We understand that you'll weigh many factors when deciding if FreshBooks is the right next step in your career. Here are some of our offerings for our employees (we call ourselves ✨ FreshBookers✨) to support their growth:
- 🩺 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, and more.
- 📚 Perks that matter. Including a Peer Recognition Program, an Employee Assistance Program, headphone credit, meaningful in-person gatherings to bring onsite and remote employees together, and more perks matched to your local cluster.
- 🌱 Working environments to help you thrive. Beautiful office spaces welcome you in Toronto, Amsterdam, and San Luis Potosi. If you don't have access to a FreshBooks office, you receive a home office credit to set up your home office.
- 🤗 Supportive peer group, mentors, and leaders. We care about each other across the organization and have programs to support this so everyone feels a strong sense of belonging, and believes in collective impact.
- 🚀 Accelerated growth. Comprehensive company onboarding, career development through continuous coaching, training, and learning on the job.
About FreshBooks You've probably learned a bit about FreshBooks before making it to this point, but let us take a moment to introduce ourselves: At FreshBooks, we believe that small business owners are the backbone of the economy, yet they are often the most underserved when it comes to technology. For over 20 years, we’ve been on a mission to support owners, from the scrappy solopreneur with a big dream to the growing business with employees to manage.
Our leading platform is more than just business software; it’s an all-in-one financial toolkit that automates invoicing, expenses, payments and payroll, allowing our customers to spend less time on paperwork and more time doing the work they love.
We believe in human-centric connections that empower teams to do their best work. Headquartered in Toronto, Canada, our team operates in clusters across North America and Europe using a variety of working environments - remote, hybrid, and in-office - all based on what’s best for the team, collaboration, and mental well-being. We are committed to creating a supportive and flexible workplace where everyone can thrive, grow, and make an impact on the lives of small business owners worldwide.
Even if your experience doesn't meet every bullet on the above lists, we'd love to learn more about you and why you think FreshBooks is the next step in your career. FreshBooks is an equal-opportunity employer. We do not discriminate based on gender, religion, race, mental disability, sexual orientation, age, or any other status. All applicants are considered based on their qualifications and merits. At FreshBooks, we inspire an environment of mutual respect and we believe diversity and inclusion are crucial to our success. FreshBooks provides employment accommodation during the recruitment process. Should you require any accommodation, please indicate this on your application and we will work with you to meet your accessibility needs. For any questions, suggestions or required documents regarding accessibility in a different format, please contact us by phone at 1-416-780-2700 and/or email at accessibility@freshbooks.com.
Analytics Engineer
Top Benefits
About the role
About The Role 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.
This role can be worked remotely from the above location. Ad-hoc in person meetings might be required from time to time in our Toronto office.
What You'll Do
- 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.
What You'll Bring
- 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.
Compensation At FreshBooks, we approach each individual's compensation with a promise of fair market value and internal equity commensurate with experience and specific skill set.
The total annual compensation for this role ranges from CA$86,800 to CA$108,500, which may include participation in our incentive programs. Additionally, this position offers an equity grant and immediate enrollment in FreshBooks' comprehensive benefits program, detailed below.
Perks And Benefits We understand that you'll weigh many factors when deciding if FreshBooks is the right next step in your career. Here are some of our offerings for our employees (we call ourselves ✨ FreshBookers✨) to support their growth:
- 🩺 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, and more.
- 📚 Perks that matter. Including a Peer Recognition Program, an Employee Assistance Program, headphone credit, meaningful in-person gatherings to bring onsite and remote employees together, and more perks matched to your local cluster.
- 🌱 Working environments to help you thrive. Beautiful office spaces welcome you in Toronto, Amsterdam, and San Luis Potosi. If you don't have access to a FreshBooks office, you receive a home office credit to set up your home office.
- 🤗 Supportive peer group, mentors, and leaders. We care about each other across the organization and have programs to support this so everyone feels a strong sense of belonging, and believes in collective impact.
- 🚀 Accelerated growth. Comprehensive company onboarding, career development through continuous coaching, training, and learning on the job.
About FreshBooks You've probably learned a bit about FreshBooks before making it to this point, but let us take a moment to introduce ourselves: At FreshBooks, we believe that small business owners are the backbone of the economy, yet they are often the most underserved when it comes to technology. For over 20 years, we’ve been on a mission to support owners, from the scrappy solopreneur with a big dream to the growing business with employees to manage.
Our leading platform is more than just business software; it’s an all-in-one financial toolkit that automates invoicing, expenses, payments and payroll, allowing our customers to spend less time on paperwork and more time doing the work they love.
We believe in human-centric connections that empower teams to do their best work. Headquartered in Toronto, Canada, our team operates in clusters across North America and Europe using a variety of working environments - remote, hybrid, and in-office - all based on what’s best for the team, collaboration, and mental well-being. We are committed to creating a supportive and flexible workplace where everyone can thrive, grow, and make an impact on the lives of small business owners worldwide.
Even if your experience doesn't meet every bullet on the above lists, we'd love to learn more about you and why you think FreshBooks is the next step in your career. FreshBooks is an equal-opportunity employer. We do not discriminate based on gender, religion, race, mental disability, sexual orientation, age, or any other status. All applicants are considered based on their qualifications and merits. At FreshBooks, we inspire an environment of mutual respect and we believe diversity and inclusion are crucial to our success. FreshBooks provides employment accommodation during the recruitment process. Should you require any accommodation, please indicate this on your application and we will work with you to meet your accessibility needs. For any questions, suggestions or required documents regarding accessibility in a different format, please contact us by phone at 1-416-780-2700 and/or email at accessibility@freshbooks.com.