Sr. Business Intelligence Analyst

1 week ago


Toronto, Ontario, Canada FreshBooks Full time
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 DoLead 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 Bring3–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 HaveExperience 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.

  • Toronto, Ontario, Canada Mastercard Full time

    Our PurposeMastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships...


  • Toronto, Ontario, Canada Iris Software Inc. Full time

    Our Client which is a large Investment Bank is urgently looking to hire aSr. Business System Analyst - Wealth Management & Capital Markets.Sr. Business System Analyst - Wealth Management & Capital Markets.Location - Downtown Toronto, ONLong Term Contract.Hybrid Role - Need 4 days onsite.Skills - Strong BSA, Wealth Management, Investment Banking/Trading,...


  • Toronto, Ontario, Canada Source Code Full time

    Sr. Business Analyst (JIRA, Azure DevOps, Pivotal Tracker) - RQ09430Downtown, TorontoHybrid - in office 3 days a weekContract (9 months)Must-haves:Knowledge of Backlog Management tools such as JIRA, Azure DevOps, Pivotal TrackerSignificant experience designing online user experiences for complex digital solutions.Ability to deliver on a product with a...


  • Toronto, Ontario, Canada Alliants Full time

    Job Description We're Hiring a Business Intelligence Analyst Location: Canada Remote Salary: $135,000 – $150,000 CAD per year Travel: occasional visits to client HQ Washington DC for important planning sessions, and potential client site visitsAt Alliants, we're on a mission to transform every customer engagement into something exceptional. We believe in...


  • Toronto, Ontario, Canada Iris Software Inc. Full time

    We are hiring forSenior Business System Analyst.Title : Business Systems Analyst (Technical BSA)Required Skills : SQL, BSA, BankingWork Mode: HybridLocation : Hybrid 4 daysPlease email me your resume atBusiness Analysis & AgileShould have Banking and FinancialShould Have good SQLBRD and FRDPartner closely with business users to gather, refine, and translate...

  • Sr. Data Analyst

    3 days ago


    Toronto, Ontario, Canada Themesoft Inc. Full time

    Sr. Data AnalystToronto ON(Hybrid)6+ months ContractStrong expertise in Data Extraction, Transformation, Management from various data sources.7+ years of experience with Advanced proficiency in Power BI, DAX, SQL, data model optimization skills and data analysis tools (e.g. Python with Pandas). Proven ability to build enterprise semantic layers and data...


  • Toronto, Ontario, Canada GS1 Canada Full time

    DescriptionThe Business Intelligence Analyst is responsible for designing, developing, and maintaining reporting, analytics, and data solutions that support GS1 Canada's strategic objectives and Industry Managed Solutions. Working closely with internal stakeholders, senior leadership, and technical teams, the incumbent gathers requirements, analyzes data...


  • Toronto, Ontario, Canada MNP Full time

    This bilingual opportunity is also available on MNP's Postes avec expérience job board in French. Please submit one application only to be considered for this opportunity. Thank you.Inspirational, innovative and entrepreneurial - this is how we describe our empowered teams. Combine your passion with purpose and join a culture that is thriving in the face of...


  • Toronto, Ontario, Canada Peel Regional Police Full time

    Positing Title:Analyst-Business IntelligenceDepartment:Analytics BureauStatus:Regular, Full-TimeSalary Range:$71, $120,727.00Grade:C9Open Positions:1Job Id:500484Additional Info:NoneOpen Date: Close Date: Are you an ambitious and highly motivated analyst with experience in collection, analysis and interpretation of police data to provide real-time...


  • Toronto, Ontario, Canada FreshBooks Full time

    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...