Business Intelligence Analyst

As a Business Intelligence (BI) Analyst, you will develop dashboards, reports, and visualizations to support business decision-making. Your day will involve working closely with business stakeholders to gather requirements, collaborating with data engineers to integrate and transform data, and ensuring BI tools deliver accurate and actionable insights. You will monitor data quality, optimize performance, and contribute to data governance efforts while maintaining documentation and providing training to business users.

Vancouver-based and Toronto-based team members work in-office every other week (Tues–Thurs). Core attendance is required from 9 AM – 3 PM on these days to support business priorities.

A DAY IN THE LIFE

• BI Solution Design: Play a key role in designing BI solutions, including dashboards, reports, and visualizations, that meet the strategic and operational needs of the business. Recommend solutions based on best practices, balancing practicality and business value. Raise concerns for unfeasible solutions and obstacles that prevent solutions from being implemented.
• Collaboration (Engineering): Collaborate with data engineers to integrate data from various internal and external sources. Facilitate support from business stakeholders in answering engineering questions.
• Collaboration (Business): Work closely with business stakeholders (e.g., product, marketing, finance) to gather requirements, understand business needs, and deliver BI solutions that drive actionable insights.
• Dashboard & Report Creation: Develop interactive, user-friendly dashboards and reports using Tableau, ensuring they are tailored to the needs of different business units.
• Data Transformation & ETL Processes: Work with the data engineering team to design and implement ETL (Extract, Transform, Load) processes, transforming raw data into clean, structured formats ready for analysis and reporting.
• Data Quality Assurance: Monitor and maintain the quality and integrity of BI data, ensuring reports and dashboards are accurate, up-to-date, and meet user requirements. This includes Tableau data environment (Tableau Flow), investigating and preventing stale data in reports.
• Data Catalog & Governance: Contribute to and help maintain a data catalog by collaborating with Data Stewards on shared definitions and their consistent application across reporting.
• Performance Optimization: Strive for high performance of BI tools and reports, focusing on optimization and ensuring that queries and visualizations are fast and efficient. Identifying bottlenecks where possible for engineering to support.
• Documentation & Training: Maintain thorough documentation on BI processes, models, and tools. Provide training to business users to ensure they can make the most of the BI solutions you develop.
• Self Development: Stay current with industry trends, new BI tools, and best practices, ensuring that BI solutions evolve to meet changing business needs.
  
  

What You Bring To The Table

• Experience designing BI solutions that align with business needs while ensuring feasibility and value.
• Strong ability to develop interactive dashboards and reports, primarily using Tableau.
• Ability to work effectively with data engineers and business stakeholders to translate business needs into BI solutions.
• Understanding of data extraction, transformation, and loading (ETL) processes to ensure clean, structured data.
• Experience maintaining data accuracy, monitoring Tableau environments, and contributing to a data catalog.
• Staying current with industry trends, BI tools, and best practices to improve solutions over time.
  
  

Compensation & Benefits

• Salary $55,000 to $70,000 per annum (Actual salary offered will be commensurate with education, experience and internal parity).
• The Total Compensation Package includes Extended Health, Dental. Focus on your development through our professional development programs. Enjoy a variety of health and wellness initiatives, including access to gym facilities at our corporate head office. Speak to us to learn more about what we offer.
  
  

THE HIRING PROCESS

• Pre-Screen – Let’s talk about your experience, goals & excitement for this role!
• Interviews – Two or more interviews with different team members, including structured competency & scenario-based questions.
• Presentation/Assessment.
• References & Background Check.
• We use audio recording transcription for our interview practices.
  
  

About Us

Did you know O2E Brands has been voted one of the Best Workplaces in Canada 14 times!? Take a sneak peek into why that is, here: (YouTube). Check us out on social! At O2E Brands, we know that great talent comes in many forms, and we want to meet you at your best. We will provide reasonable accommodations to applicants with disabilities at any time throughout the recruitment and selection process. Please contact our Talent Acquisition Team at talentacquisition@o2ebrands.com or notify the Talent Acquisition team member you are working with if unique arrangements will enable your equal participation.

Ready to take your career to the next level? Apply today!