Business Intelligence Analyst

FreshBooks; Toronto; Remote; CAD 70,000 - 90,000; Full time

Job summary

A leading cloud-based accounting software platform is seeking a Business Intelligence Analyst to design and deliver data assets that empower teams to make analytics-informed decisions. Responsibilities include collaborating with stakeholders, designing data models, and building Looker dashboards. The ideal candidate has 1-3 years of experience in Business Intelligence and strong proficiency in SQL. This role offers remote work options and a range of comprehensive benefits.

Benefits

Comprehensive health and wellness benefits

Retirement savings program

Generous time off

Peer Recognition Program

Home office credit

Qualifications

• 1-3 years of experience in Business Intelligence, Data Analytics, or Data Engineering.
• Strong knowledge of data warehousing and ETL/ELT concepts.
• Full proficiency in SQL for complex queries.

Responsibilities

• Collaborate with stakeholders to gather and refine data requirements.
• Design and maintain scalable data models using dbt.
• Build and optimize Looker Explores and Dashboards.

Skills

Business Intelligence

Data Analytics

SQL

Looker

Data Governance

Tools

GCP

dbt

Looker

Job description

Overview

As a Business Intelligence Analyst at FreshBooks, you will design and deliver data assets that empower our teams to make analytics-informed decisions. You’ll collaborate with stakeholders across the business to understand priorities and challenges, translating them into effective, scalable data solutions. Your work will enable self-service analytics, ensure data quality, and provide actionable insights.

Note: This role can be worked remotely from Toronto, Ontario, or the Greater Toronto Area. The team meets in our Toronto office on an ad hoc basis, up to twice per month.

What You’ll Do

• Collaborate with stakeholders to gather and refine data requirements, ensuring solutions address business needs.
• Design, develop, and maintain scalable data models using dbt within the GCP environment.
• Build and optimize Looker Explores, Dashboards, and LookML to enable self-service analytics and deliver clear business insights.
• Create and certify Looker reports for decision-makers across the organization.
• Implement data governance best practices, including documentation, access controls, and data quality processes.
• Maintain detailed documentation for all data models, including ERDs, data dictionaries, and transformation logic.
• Continuously improve data performance, accuracy, and usability across the business.

What You’ll Bring

• 1–3 years of proven experience in Business Intelligence, Data Analytics, or Data Engineering, or equivalent Co-op/Internship experience.
• Strong knowledge of data warehousing, dimensional modeling, and ETL/ELT concepts.
• Full proficiency in SQL (complex querying, optimization, debugging, joins, window functions, CTEs).
• Experience developing and maintaining data models and pipelines using dbt.
• Proficiency in Looker (including LookML) for dashboards and reporting.
• Ability to translate complex data into clear, impactful visualizations and insights.
• Strong problem-solving and communication skills for technical and non-technical collaboration.

You’ll Stand Out If You Have

• Experience writing Python or R scripts for analytics workflows.
• Exposure to Google Cloud Platform (GCP) data tools.
• Background in a SaaS or technology-driven environment.

About FreshBooks

FreshBooks is a leading cloud-based SaaS accounting software platform built for small business owners and consistently ranks #1 for ease of use. We focus on simplicity and reducing administrative burden, helping customers get paid faster and spend less time on admin and paperwork so they can grow their businesses. We believe in human-centric connections that empower teams to do their best work. Headquartered in Toronto, our team operates across North America and Europe with remote, hybrid, and in-office options based on team needs.

Perks & Benefits

We understand that you’ll weigh many factors when deciding if FreshBooks is the right next step. Here are some offerings to support your growth:

• Comprehensive health and wellness benefits. Including a retirement savings program or pension plan matched to your local office, stock options for every full-time employee, generous time off, 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. Peer Recognition Program, Employee Assistance Program, headphone credit, meaningful in-person gatherings to bring onsite and remote employees together, and other region-specific perks.
• Working environments to help you thrive. Beautiful office spaces in Toronto, Amsterdam, and San Luis Potosi. If you don’t have office access, you receive a home office credit.
• Supportive peer group, mentors, and leaders. Programs to foster belonging and collective impact.
• Accelerated growth. Comprehensive onboarding, career development through coaching, training, and on-the-job learning.

Note: Even if your experience doesn’t meet every bullet, we’d love to learn more about you and why 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 qualifications and merits. We are committed to diversity, inclusion, and a respectful workplace.

FreshBooks provides employment accommodations during the recruitment process. If you require accommodations, please indicate this on your application and we will work with you to meet accessibility needs. For accessibility inquiries, contact 1-416-780-2700 or [e-mail].

Seniority level

• Entry level

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology
• Industries
• Software Development