Job Specifications
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
About the Company
FreshBooks is accounting software built for small business owners and accountants, proudly serving customers in more than 160 countries. We simplify invoicing, payments, and bookkeeping so business owners can focus on what they do best. We put our customers at the heart of everything we do. We are dedicated to helping businesses grow—whether they’re freelancers, entrepreneurs, or established teams—by equipping them with easy-to-use accounting and admin solutions that save them valuable time, enhance their workflows, and acce...
Know more