Sr. Business Intelligence Analyst

As a Senior Business Intelligence Analyst at FreshBooks, you will play a critical role in transforming data into actionable insights that shape strategic business decisions across the company. You’ll lead complex data modeling initiatives, architect advanced reporting solutions, and act as a subject matter expert for key business metrics. In addition to hands-on development, you will provide mentorship to other analysts, fostering a collaborative and high-performing environment.

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

• Lead complex data modeling projects from inception to deployment, translating business requirements into scalable solutions.
• Architect, develop, and maintain advanced data models using dbt within the GCP environment, ensuring data integrity, performance, and governance compliance.
• Design and implement sophisticated Looker Explores, Dashboards, and LookML to enable advanced self-service analytics.
• Proactively identify opportunities for new insights and deliver innovative reporting solutions for high-impact business challenges.
• Act as the subject matter expert for key business metrics, delivering certified Looker reports and strategic recommendations to senior leadership.
• Implement and enforce data governance best practices, including documentation, classification, access controls, and data quality processes.
• Maintain detailed documentation for all data models, including ERDs, data dictionaries, lineage mapping, transformation logic, and business glossaries.
• Mentor and guide junior BI Analysts on data modeling, Looker development, and data best practices.
• Contribute to the evaluation and selection of new BI tools and technologies.
  
  

What You’ll Bring

• 3–5 years of experience in Business Intelligence, Data Analytics, or Analytics Engineering role.
• Advanced SQL skills with the ability to optimize queries for large datasets, apply best practices for maintainability, debug complex logic, and develop transformation workflows in dbt using SQL as the primary language.
• Proven experience developing and maintaining advanced data models and pipelines using dbt.
• Proficiency in Looker (including LookML) for dashboards and complex reporting.
• Strong knowledge of data warehousing, dimensional modeling, and ETL/ELT concepts.
• Ability to communicate complex data concepts clearly to technical and non-technical audiences.
• Track record of collaborating with cross-functional teams to drive data-informed decision-making.
  
  

You’ll Stand Out If You Have

• Experience writing Python or R scripts for analytics workflows.
• Proficient in Google Cloud Platform (GCP) data tools.
• Experience working in a SaaS or technology-driven environment.
• Familiarity with APIs for data integration.