Business Intelligence Specialist � Junior

2iSolutions Inc.; Ontario; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A dynamic tech firm in Ontario is seeking a Junior Business Intelligence Specialist. The role entails designing and implementing business intelligence solutions using Cognos and Power BI. Ideal candidates will possess strong analytical skills and experience in data analysis, contributing effectively to BI projects supporting various client needs. If you are ready to embark on a career in BI with a commitment to excellence and learning, this opportunity is for you.

Qualifications

• Entry-level role focused on Business Intelligence.
• Experience with Cognos and Power BI is essential.
• Strong analytical and problem-solving skills are required.

Responsibilities

• Design and develop BI reports and dashboards using Cognos and Power BI.
• Support client data analysis and reporting needs.
• Participate in ETL processes to prepare data for reporting.

Skills

Business Analysis

Designing BI Reports

Data Analysis

Troubleshooting

Problem Solving

Education

Relevant Degree in IT or Business

Tools

Cognos

Power BI

ETL Tools

SQL

Job description

Business Intelligence Specialist � Junior

Join to apply for the Business Intelligence Specialist � Junior role at 2iSolutions Inc.

Business Intelligence Specialist � Junior

Join to apply for the Business Intelligence Specialist � Junior role at 2iSolutions Inc.

Get AI-powered advice on this job and more exclusive features.

RQ08200 - Business Intelligence Specialist - Junior

Client: Ministry of Public and Business Service Delivery and Procurement

Period: 12 months

Start Date: 2025-04-01

End Date: 2026-03-31

Working Hrs.: 7.25 Hrs. / day

Location: 777 Bay St, 4th floor

Hybrid - Candidate must be able to work 3 days onsite and 2 days remote

Assignment Type: This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.

Must Have

• Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutions.
• Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
• Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting.
• Experience in ETL processes, particularly as it relates to migrating data into Power BI-compatible formats. Familiarity with ETL tools (e.g., SSIS, Informatica)
  
  

Description

Evaluation Project Requirements Evaluation Breakdown

Technical Skills - 40%

• Demonstrates business analysis experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
• Experience working with data warehouse systems and understanding the design and concepts of it.
• Experience in ETL processes, particularly as it relates to migrating data into Power BI-compatible formats. Familiarity with ETL tools (e.g., SSIS, Informatica)
• Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
• Working knowledge of the entire Data Dictionary and data mapping
• Working knowledge of the Business Process Design Re-engineering for applications.
• Experience with analyzing data in source systems to identify data cleanliness issues (E.g., missing values, duplicate meanings, and invalid data)
• Experience with developing automation extraction, cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc)
• Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting
• Experience working with Oracle Databases (version 10.x or higher), DB2 Database.
• Demonstrates strong MS Excel skills, including working knowledge of Power Query, Pivot Tables
  
  

Core Skills - 30%

• Experience gathering and eliciting requirements for BI application (Cognos and Power BI)
• Experience with systems design and development, and related methods, techniques, practices, and standards.
• Experience performing the design of data warehouse and related components.
• Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
• Experience Documenting applications designs and specifications, and draft policies and procedures.
• Working Knowledge of aggregate reporting.
• Troubleshooting of production issues and creating fixes for any unplanned deployments.
• Prior experience with BI migration projects, particularly involving Power BI, or from another reporting tool like Tableau, Cognos.
• Proven troubleshooting and analytical experience
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
• Experience in the use of development tools and business re-engineering software
• Experience Designing and developing enterprise-wide data analysis and reporting solutions
• Experience reviewing and analyzing data from multiple internal and external sources
• Familiarity with the source system(s) being migrated from (e.g., Cognos, SSRS, Qlik) can be a significant advantage, as it allows for smoother data mapping and validation
• Ability to use BI tools and data models effectively to help visualize or monitor data
• Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).
  
  

Communication Skills - 20%

• Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
• Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.
• Exceptional organization and presentation skills
• Good written, verbal, and interpersonal skills
  
  

Project Management Skills - 10%

• Experience in the development of various deliverables of various roles including, but not limited to, project coordinator, release management, requirements analyst, system designer, system tester, trainer, etc. throughout SDLC.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at 2iSolutions Inc. by 2x

Get notified about new Business Intelligence Specialist jobs in Ontario, Canada.

Freelance Data Analyst (Python) - AI Trainer

Mississauga, Ontario, Canada CA$99,600.00-CA$107,100.00 2 weeks ago

Business Intelligence Analyst, Insights and Analytics

Sr. BI & Reporting Analyst - Python/SQL/PowerBI/Tableau/Splunk

Business Intelligence Specialist 8575-2812

Business Intelligence Analyst (Ref 20241029)

Freelance Data Analyst (Python) - AI Trainer

Business Intelligence Specialist (Intermediate) 9327-0311

Senior Analyst, Business Intelligence (12 month contract)

Business Analyst (Data, Loyalty & Insights)

Greater Toronto Area, Canada 11 hours ago

Business Intelligence (Intermediate) 0141-3015

Instructor-Data Analytics and Business Intelligence (Remote)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.