Business Intelligence Specialist - Intermediate

2iResourcing; Ontario; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

A leading company in business intelligence solutions is seeking a Business Intelligence Specialist for a hybrid role. The position requires expertise in data visualization tools such as Tableau and Power BI, along with extensive analytical skills. You will provide support to the Ministry of Treasury Board Secretariat and help develop effective data solutions. This opportunity involves working with clients to manage and analyze key business data.

Qualifications

• 8-10 years of experience in BI solutions and data warehousing.
• Proficiency in using data visualization tools like Tableau and Power BI.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop and implement BI solutions for data analysis.
• Create visual representations of data and dashboards.
• Support client data needs and troubleshoot data issues.

Skills

Data visualization

Analytical skills

Business Intelligence Solutions

ETL processes

Communication skills

Tools

Tableau

Power BI

Microsoft Power Platform

SQL

Visio

Job description

If interested please share your resume at [e-mail] | [e-mail]

RQ09327 - Business Intelligence Specialist - Intermediate
Client: Ministry of Treasury Board Secretariat
Period: Apprx. 10 months
Start Date: 2025-06-23
End Date: 2026-03-31
Working Hrs.: 7.25 Hrs. / day
Location: 222 Jarvis St Toronto or 33 King St W Oshawa
Hybrid role - Candidate is required to come in office - 3 days a week/2 day remote
MUST HAVES:

• Ability to create visual representations of data using tools like Tableau, Power BI, or similar platforms to create dashboards and reports that effectively communicate insights.
• Experience with low code platforms such as Microsoft Power Platform
• Experience developing and implementing business intelligence solutions such as Microsoft Power BI.
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
• Experience developing test cases and perform QA testing on business intelligence solutions
• Effective in making presentations and conducting product/solution demonstrations

Description:
General Skills:
Responsibilities
Supports Client's wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized query applications which analyze key business data. Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of "opportunity” and "key-trend” alerts. Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives. General Skills Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data) Experience with developing feedback processes to fix corrupt data in the source systems Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores) Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts Experience with developing monitoring and error notification processes to ensure data is updated as designed Experience with developing automation extraction, cleansing and load scripts Experience generating research models and reports (scheduled and ad-hoc) 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 in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines Desirable Skills Knowledge and experience in developing data analysis applications Knowledge and understanding of Information Management principles, concepts, policies and practices Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes. Experience with developing monitoring and error notification processes to ensure data is updated as designed Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio. Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Experience and Skill Set Requirements
8-10 Years in the Following:

Requirement 1 (35%) – Technical Knowledge:

• Experience with information technologies such as servers, storage, networks, operating systems, database technologies, security technologies (e.g., authentication), development tools and programming languages.
• Ability to create visual representations of data using tools like Tableau, Power BI, or similar platforms to create dashboards and reports that effectively communicate insights.
• Experience with low code platforms such as Microsoft Power Platform
• Experience developing and implementing business intelligence solutions such as Microsoft Power BI.
• Experience with SQL and No SQL database technologies.
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Requirement 2 (20%) – Analytical and Problem-Solving Skills:

• Familiar with industry best practices, policies, and strategies for deployment of business intelligence solutions.
• Experience assessing information and system needs of clients, and assist in the development of improved, cost-effective solutions.
• Experience designing and developing alternatives based on business/client needs and provide recommendations on solutions.
• Experience developing test cases and perform QA testing on business intelligence solutions.

Requirement 3 (20%) – Communication & Interpersonal Skills:

• Lead discussions on systems development options and technical processes to project teams.
• Excellent written and oral communication skills.
• Effective in making presentations and conducting product/solution demonstrations.
• Work independently, with minimal supervision, as well as in a team-oriented, collaborative environment.

Requirement 4 (25%) – Computer Skills:

• Proficiency using various office applications such as Word, Excel, PowerPoint, and Visio to develop documents and presentations.
• Experience using Microsoft Power Platform tools such as Power Automate and Power BI.
• Knowledge and experience using shared folders and working with collaborations tools such as Microsoft Teams and SharePoint.
• Experience using Software Development tools.

If interested please share your resume at [e-mail] | [e-mail]