Business Intelligence Solutions Developer

Position Overview

This role will design and produce standard and ad‑hoc visual insights/reports and will be directly responsible for translating data into meaningful, digestible, and actionable insights. It develops dashboards, reports, Power Apps and reusable semantic models; creates and maintains dataflows; defines data and database requirements for data engineering teams; and orchestrates workflow automation to improve data operations and reporting efficiency. The role serves as a bridge between Sales, Marketing and technical teams, ensuring data solutions are accurate, scalable and aligned to business goals.

It works with different stakeholders in the organization to provide analysis and insight through data.

This position is based in the Burlington, Ontario office located at 5180 South Service Road and is flexible. Employees in flexible roles are required to be at the office a minimum of 50% of the time each month and must report to the office when requested and required by their Manager/Department.

• Gather business requirements to conceptualize, design and develop/project manage delivery of interactive data visualisation translating raw data into compelling insights; develop data‑driven stories and executive presentations.
• Develop and distribute actionable key performance indicators (KPIs), Gross to net, and sales reports on national, district and territory geographies for each species business unit.
• Develop smart, compelling business intelligence assets for Marketing teams to track KPIs, identify trends, and monitor Marketing initiatives and processes. Responsibility for secondary data analysis and reporting that supports and challenges brand/TA performance and promotion evaluation.
• Partner with the data technology team to oversee and drive the creation of data products, helping to define source system requirements, ETL and data delivery into a standard data warehouse. Use this data to create standard and scalable semantic models and data flows that can be leveraged by different reports and dashboards.
• Evaluate emerging Business Intelligence technologies and provide thought and perspective for adoption where appropriate.
• Implement compliance requirements. Perform all company business in accordance with all regulations, BICL compliance guidelines and procedures. Demonstrate high ethical and professional standards with all business transactions in order to maintain BICL’s excellent reputation within the industry.
• Plan and execute the modernization of the existing catalogue of BI assets to the latest data platforms and methods focusing on automation, standardisation and scalability.

• Bachelor’s degree in Statistics, Mathematics, Physics, Computer Science, Engineering, or related fields with an emphasis on statistics and business analysis.
• Proficiency in advanced mathematics/statistics (regressions, optimisation, clustering analysis, predictive modelling, etc.).
• Minimum 3 years of work experience in a non‑academic setting.
• Minimum 5 years of experience in an analytical business function.
• Excellent attention to detail and ability to convert raw data into usable visual insights.
• Previous experience supporting a commercial organisation with reports and analytics that drive business insights.
• Hands‑on experience with business intelligence and dashboarding tools (Power
  
  BI, Tableau).
• Mastery of Microsoft Office (Excel, Outlook, Access, PowerPoint).
• Technical fluency with data preparation and predictive modelling.
• Ability to work effectively in a cross‑functional matrixed environment.
• Effective communication and presentation skills.
• Ability to work independently and in a team environment in a positive and supportive manner.
• Experience in data mining structured and unstructured data (SQL, ETL, data warehouse, etc.) in a business environment with large‑scale, complex data sets.
• Strong interpersonal skills; ability to collaborate with a wide range of individuals at all levels of the organisation.
• Advanced Excel expertise (VBA, functions, connections to external data sources, Power Query, etc.).
• Competencies critical for the success of this job: leading innovation, fast and focused execution,…