Apply By: Monday, July 8, 2024 11:59 pm EDT
Competition Status: Application Screening

Approximately 41 individuals applied for this opportunity.

We are screening ALL applications received on or before the closing date and rating them against the qualifications outlined in the job ad. Applicants whose resume and cover letter best demonstrate how they meet the qualifications to do the job will be invited to continue in the hiring process.

To learn about our recruitment process, visit our Hiring Process.

Business Intelligence Specialist

Ministry of Education
Education Quality and Accountability Office (EQAO)
Language of Position(s):
Job Term:
1 Temporary - up to 24 months with possible extension
Job Code:
17162 - Systems Officer 6
$1,852.71 - $2,314.51 Per Week*
*Indicates the salary listed as per the OPSEU Collective Agreement.
Posting Status:
Open Targeted
Job ID:
The Education Quality and Accountability Office (EQAO) is an arms-length government agency focused on modernizing Ontario's approach to large-scale assessment. This transformation is part of an exciting mandate to contribute to the continuous improvement of Ontario's publicly funded education system. The agency creates and delivers engaging and relevant assessments for students that lead to further insights into their learning.

The agency is dedicated to building a strong team to support the development and delivery of its assessment program. EQAO is seeking an experienced Business Intelligence (BI) Specialist to lead and provide technical BI, data warehousing web portal management, report writing expertise to support data and information management systems, lead user aspects of the technical design, development, testing and implementation of information management systems, manage relationship with I and IT service providers and BI systems users and provide user-focused BI systems development, business analysis and systems consulting expertise to senior management, internal users and external stakeholders.

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:

We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.

Visit the OPS Anti-Racism Policy and the OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.

What can I expect to do in this role?

As a Business Intelligence (BI) Specialist, you will:
• Lead the design, development, testing, and implementation of BI systems and data warehouses.
• Manage relationships with IT service providers and users to ensure efficient system operations.
• Translate user requirements into technical specifications and oversee BI application development and deployment.
• Develop and implement BI processes, policies, and provide user training and support.
• Analyze business processes, identify BI needs, and develop recommendations and solutions.

How do I qualify?

Technical Skills:

• Lead and provide senior-level BI expertise and leadership in the design, development, testing, and implementation of large-scale BI systems and data warehouse projects.
• Translate user requirements into technical specifications and manage all user aspects of BI systems, ensuring solutions meet business objectives.
• Oversee the development and implementation of web reporting portals, integrating data warehouses, and ensuring compliance with quality assurance standards.
• Develop and implement BI processes, procedures, and policies, including user training and support materials.

Technical Knowledge:

• Extensive knowledge of contemporary BI concepts, principles, best practices, and standards.
• Proficient in BI-related IT platforms and technologies such as PowerBI, DAX, tabular models, and web-based portal applications using Microsoft Power Platform.
• Understanding of ETL processes and tools, relational and dimensional database concepts, cloud based data structures and un-structured data tools.
• In-depth knowledge of the SDLC demonstrating good understanding of processes within each of the stages of requirements gathering, design, development, testing, implementation, and maintenance as well as systems documentation methodologies for each stage.

Analytical and Problem-Solving Skills:

• Identify, analyze, and evaluate diverse BI data sources, information, and reporting needs to develop authoritative recommendations and solutions.
• Assess feasibility of business requirements by streamlining, explore and recommend BI options, help structure concise requirements and standards, and translate them into technical specifications.
• Develop BI quality assurance policies and procedures and evaluate their effectiveness.
• Analyze business processes, recommend improvements, and manage responses to atypical reporting requests to present viable solutions.

Communication and Interpersonal Skills:

• Influence, negotiate, and build consensus with stakeholders on BI data, information, and reporting needs.
• Develop effective relationships with team members, service providers and end users, using diplomacy and persuasiveness with clear understand of roles and responsibilities
• Present reports, mock-ups, recommendations, and conduct training sessions for diverse audiences.
• Prepare comprehensive documentation, including business processes, user guides, and training materials, and lead user training seminars.
Collaborate with team members and stakeholders effectively handling priorities while respecting the roles and responsibilities.

Additional Information:

  • 1 English Temporary, duration up to 24 months, 2 Carlton St, Toronto, Toronto Region
Compensation Group:
Ontario Public Service Employees Union
Information Technology
Posted on:
Friday, June 21, 2024
  • T-EU-215523/24
Please be advised that the results of this competition may be used to form an eligibility list of qualified candidates to potentially fill future vacancies represented by the Ontario Public Service Employees Union (OPSEU). In accordance with the Collective Agreement, eligibility lists are shared with OPSEU representatives. By applying to this competition, you are providing consent that your name may be shared with OPSEU representatives.
All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.
Remember: The deadline to apply is Monday, July 8, 2024 11:59 pm EDT. Late applications will not be accepted.

We thank you for your interest. Only those selected for further screening or an interview will be contacted.

All Ontario Public Service external job advertisements are posted in English and French. To confirm the language requirements of a job, check the "language of position" information at the top of each job ad. For all positions, candidates will be assessed in English, the business language of the Ontario Public Service. For English/French designated bilingual positions, candidates will also be assessed through French-language proficiency testing.

Toutes les offres d'emploi externes de la fonction publique de l'Ontario sont affichées en anglais et en français. Pour connaître les exigences linguistiques, vérifiez les renseignements sur la « langue du poste » figurant dans le haut de chaque offre d'emploi. Pour tous les postes, l'évaluation des candidates et candidats se fera en anglais, la langue usuelle de la fonction publique de l'Ontario. En ce qui concerne les postes désignés bilingues, la maîtrise du français des candidates et candidats sera également évaluée.

The Ontario Public Service is an inclusive employer.
Accommodation is available under the Ontario's Human Rights Code .
Note: The only website where you can apply on-line for positions with the Ontario Public Service is

You must enable JavaScript in your browser to access full functionality on the OPS Careers website.

Vous devez activer JavaScript dans votre navigateur pour avoir accès à toutes les fonctionnalités du site Carrières dans la FPO.

Ontario Logo / Logo de l'Ontario
This site is maintained by the Government of Ontario
Ce site est mis à jour par le gouvernement de l'Ontario

Privacy | Important Notices
Confidentialité | Avis importants

© Queen's Printer for Ontario, 2007
© Imprimeur de la Reine pour l'Ontario, 2007