Business Intelligence (BI) Specialist

Onico Solutions; Richmond Hill; On-site; CAD 70,000 - 75,000; Full time

Job summary

A leading company seeks a Business Intelligence Specialist to design and implement BI solutions tailored to business user needs. This permanent role in downtown Toronto requires strong analytical skills, experience with visualization tools like Power BI, and a commitment to providing customer-centric solutions. You will be responsible for the development and testing of BI systems while ensuring data integrity and availability across the organization.

Qualifications

• Minimum of 3 years’ experience in BI development.
• Strong analytical abilities and customer-centric disposition.
• Experience with visualization tools and data warehousing.

Responsibilities

• Design, code, test, and document BI systems and applications.
• Develop front-end BI applications based on user requirements.
• Lead projects in the use of BI software tools.

Skills

Data modelling and analysis

Communication skills

Problem-solving

Analytical skills

Education

College diploma or university degree in computer science or related field

Certified Business Intelligence Professional (CBIP)

Tools

Power BI

Tableau

Sisense

MS SQL Server

Crystal Reports

SSRS

ETL tools

Job description

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

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