Business Intelligence Analyst

Join to apply for the Business Intelligence Analyst role at FreshBooks 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 easiest to use. With an emphasis on keeping things simple and stress-free wherever possible, FreshBooks makes the hard parts of running a business a little bit easier. With FreshBooks, our customers can get paid faster and spend less time on admin and paperwork, so they can focus on what they do best—growing their businesses. 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 and accountants worldwide. Perks & Benefits 🩺 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. 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 Potosí. 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. 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. Seniority level Entry level Employment type Full‑time Job function Research, Analyst, and Information Technology Industries Software Development #J-18808-Ljbffr