Business Intelligence (BI) SpecialistOnico Solutions • Toronto, ON

Business Intelligence (BI) Specialist

Onico Solutions • Toronto, ON

30+ days ago

Job type

Permanent

Job description

Business Intelligence (BI) Specialist

Overview

The Business Intelligence (BI) Specialist’s role is to strategically design and implement BI solutions that meet the needs of internal business stakeholders. This includes gathering requirements, designing, and rolling out BI solutions to end users. These solutions would encompass comprehensive back-end functionality in the form of data cubes, or warehouses, and complete front-end dashboards tailored to user requirements.

Ensuring data integrity and single source of truth is paramount when building and deploying solutions. A customer-centric disposition is required to truly understand business user requirements.

The Business Intelligence Specialist is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

Responsibilities

Strategy & Planning

Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Operational Management

Direct, organize, and lead projects in the implementation and use of BI software tools and systems.

Lead the integration efforts for merging BI platforms with enterprise systems and applications.

Design, code, test, and document all new or modified BI systems, applications, and programs.

Develop the semantic layer, metadata, reports, and report definitions.

Develop graphs and portal interfaces.

Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.

Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.

Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.

Conduct job duties and responsibilities according to the organization’s business systems development methodology and / or its Systems Development Life Cycle (SDLC) methodology.

Design and deliver end-user training and training materials; provide technical support as necessary.

Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.

Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.

Position Requirements

Formal Education & Certification

College diploma or university degree in the field of computer science, information systems, or computer engineering.

Certified Business Intelligence Professional (CBIP) or similar is an asset.

Knowledge & Experience

Minimum of 3 years’ direct work experience.

Expertise with one or more visualization tools such as Sisense, Tableau, Power BI, or others.

Expertise in data modelling and analysis, and design of data cubes and warehouses.

Experience with tier-one applications, databases, and data warehouses, such as MS SQL Server, Crystal, SSRS, and so on.

Strong ability to analyze user requirements and build front-end BI applications according to specifications.

Knowledge of various scripting languages.

Strong understanding of relational database structures, theories, principles, and practices.

Demonstrated ability with MS Windows and UNIX operating systems.

Demonstrated ability with various ETL tools.

Full project management and development life cycle experience.

In-depth technical knowledge of network, PC, and platform operating systems, including Windows Server.

Good knowledge of applicable data privacy practices and laws.

Personal Attributes

Strong customer centric disposition.

Strong written and oral communication skills.

Strong presentation and interpersonal skills.

Exceptional analytical, conceptual, and problem-solving abilities.

Ability to prioritize and execute tasks in a high-pressure environment.

Experience working in a team-oriented, collaborative environment.

This is a permanent position located in downtown Toronto with a salary of $70,000.00 – $75,000.00 per annum.

Create a job alert for this search

Business Intelligence BI Specialist • Toronto, ON

Similar jobs

Senior BI Analyst, Business Intelligence & Automation

Questrade Financial Group • Toronto

Full-time +1

Senior BI Analyst, Business Intelligence & Automation.Senior BI Analyst, Business Intelligence & Automation.Questrade Financial Group (QFG), through its companies—Questrade, Inc.Questrade Wealth Ma...Show more

Last updated: 30+ days ago • Promoted

Senior BI Analyst, Business Intelligence & Automation

Community Trust Company • Toronto

Full-time +1

Senior BI Analyst, Business Intelligence & Automation.Posted Thursday, January 8, 2026 at 5 : 00 AM.Questrade Financial Group (QFG), through its companies - Questrade, Inc. Questrade Wealth Management...Show more

Last updated: 24 days ago • Promoted

Senior BI Analyst, Business Intelligence & Automation

Flexiti Financial • Toronto

Full-time +1

Last updated: 24 days ago • Promoted

Senior Manager, Strategy and Business Intelligence

Canerector • Toronto

Full-time

With over 50 mid‑sized manufacturing companies across 100 locations in North America, Canerector brings together unmatched industrial expertise. We are growing our Strategy & Business Intelligence T...Show more

Last updated: 24 days ago • Promoted

Senior Specialist, Business Intelligence & Analytics

Mackenzie Investments • Toronto

Full-time

Grade : P7 Referral Level : Level 1 Division : IGM-Finance.Canada, managing approximately $310 billion in assets as of December 31, 2025. It offers financial planning and investment services to over tw...Show more

Last updated: 9 days ago • Promoted

Business Intelligence (BI) Analyst

Fusemachines • Toronto, ON, CA

Full-time

Quick Apply

About Fusemachines Founded in 2013, Fusemachines is a global provider of enterprise AI products and services, on a mission to democratize AI. Leveraging proprietary AI Studio and AI Engines, the com...Show more

Last updated: 30+ days ago

Business Intelligence Developer

HISH IT SERVICES • Toronto

Full-time

Job type : Contract(6 Months) - High possibility of Extension.Capital Market Experience is mandatory.The Report Engineer (BI Developer) is responsible for designing, developing, and maintaining high...Show more

Last updated: 15 days ago • Promoted

Senior Business Intelligence Analyst

Themis Solutions Inc. • Toronto

Full-time

Clio is the global leader in legal AI technology, empowering legal professionals and law firms of every size to work smarter, faster, and more securely. We are currently looking for a new Senior Bus...Show more

Last updated: 24 days ago • Promoted

Analyst, Business Intelligence

Porter Airlines Inc. • Toronto

Full-time

The Business Intelligence (BI) Analyst is central to driving informed decision-making across our growing Porter network.Our team’s mission is to empower business units across the organization with ...Show more

Last updated: 24 days ago • Promoted

Senior BI Analyst

Black & McDonald Limited • Markham

Full-time

Senior Business Intelligence (BI) Analyst.Black & McDonald’s Business Intelligence / IT team is growing! If you are a committed and collaborative professional looking to contribute to a hard-working,...Show more

Last updated: 24 days ago • Promoted

RQ06224 - Business Intelligence Specialist - Senior

Teacup Tech Systems Inc • Toronto

Full-time

RQ06224 - Business Intelligence Specialist - Senior.About the job RQ06224 - Business Intelligence Specialist - Senior.Experience in business intelligence software development and a number of years ...Show more

Last updated: 19 days ago • Promoted

VP Business Intelligence

Preston Lang • Toronto

Full-time

VP Business Intelligence - JO103667.Our client is a global marketer of branded apparel.They have 200+ offices worldwide and represent many major well-known name brands. Work closely with the group C...Show more

Last updated: 24 days ago • Promoted

Senior Business Intelligence Engineer

Picton Mahoney Asset Management • Toronto

Full-time

Best Workplaces™ in Canada 2020 - 2025 | Best Workplaces™ with Most Trusted Executive Teams 2024, 2025 | Best Workplaces™ in Financial Services & Insurance 2020 - 2025 | Best Workplaces™ for Mental...Show more

Last updated: 20 days ago • Promoted

Senior Business Intelligence Analyst

Clio • Toronto

Full-time

Clio is the global leader in legal AI technology, empowering legal professionals and law firms of every size to work smarter, faster, and more securely. We are transforming the legal experience for ...Show more

Last updated: 24 days ago • Promoted

Manager, Business Intelligence & Data Analytics

Sapling Financial Consultants Inc. • Toronto

Full-time +1

Manager, Business Intelligence & Data Analytics.Manager, Business Intelligence & Data Analytics.Sapling Financial Consultants Inc. Sapling Financial Consultants is a management consulting firm, foun...Show more

Last updated: 24 days ago • Promoted

Banking Research Market Intelligence Specialist

McKinsey & Company, Inc. • Toronto

Full-time

Driving lasting impact and building long-term capabilities with our clients is not easy work.You are the kind of person who thrives in a high performance / high reward culture - doing hard things, pi...Show more

Last updated: 6 days ago • Promoted

SAS Analyst — Banking Data & BI Specialist

RedPico • Toronto

Full-time

A financial services company is seeking a highly proficient SAS Analyst in downtown Toronto.The role involves developing complex data analysis, creating Power BI dashboards, and optimizing SQL quer...Show more

Last updated: 9 days ago • Promoted

Business Intelligence Developer

Insight Global • Toronto

Full-time

Get AI-powered advice on this job and more exclusive features.This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to lear...Show more

Last updated: 24 days ago • Promoted