Business Intelligence Analyst (H) Full Time NEW

Education Centre- ITS

Applicants Will Be Considered In The Following Order

• Qualified permanent ESS/OSSTF Bargaining Unit employees.
• Qualified probationary, temporary and Temporary Hourly Rated (THR) ESS/OSSTF employees.
• Qualified external applicants (includes employees from other Bargaining Units)

Waterloo Region District School Board (WRDSB) serves approximately 65,000 students in 123 schools, as well as alternative and continuing education sites. WRDSB is committed to creating learning environments that support the achievement and well-being of all students through partnering with staff, parents, families, caregivers and communities to promote success in learning and life. Additional information regarding the Board is available on the Board’s website at .

Reporting to the IT Manager and working within the IT Project Management Office, the Business Intelligence Analyst will apply their expertise to play a crucial role in determining requirements and producing comprehensive reports and dashboards to support operational needs of all departments across the WRDSB. The successful candidate will be responsible for the development and support of Business Intelligence solutions using tools such as Fabric, Power BI, SSRS, SQL, and Power Query.

The successful applicant for this Education Support Staff position, Level H ( $74,462-$ 85,666) , will work thirty-five (35) hours per week, twelve (12) months per year effective as soon as possible.

Responsibilities

• Assists in the designing, implementing and maintaining a vision and three-year plan related to WRDSB business intelligence systems as a component of the larger IT Service planning cycle.
• Supports reporting for Learning Services, Human Resources, Finance, Facilities, Security, Information Technology and other Board departments. A high degree of ingenuity, and the ability to make complex design and data modeling decisions, are essential to ensure accurate reporting outcomes.
• Supports the life cycle and maintenance of business intelligence systems including availability, performance and security in accordance with agreed upon service level agreements.
• Develops reports, dashboards, and other business intelligence solutions for Board departments for both internal and external publication.
• Responsible for changes to production environments, including maintaining data, updating applications, creating roles, and maintaining security.
• Proactively supports multiple complex technical projects for the optimization and continuous improvements of business intelligence systems.
• Practices agile leadership by leading sprints for small to medium size projects, ensuring quick, reliable, and timely delivery of outcomes.
• Collaborate with stakeholders across departments of WRDSB to gather and analyze requirements.
• Design and develop scalable and efficient business intelligence (BI) solutions to provide actionable insights and support decision-making processes, using tools such as Power BI, SQL, and Power Query.
• Establish and maintain best practices for data visualization and report design.
• Ensure data accuracy, consistency, and integrity across all reporting solutions.
• Optimize report performance and user experience through effective design and configuration.
• Follow change control and testing processes for modifications to reports and dashboards.
• Analyze and resolve issues facing users, including technical support and troubleshooting of system errors and performance issues.
• Collaborate with IT teams to ensure data sources are properly integrated, secured, and maintained.
• Conduct training sessions and workshops to enhance BI skills among end-users.
• Stay updated with the latest features and capabilities of Power BI, AI, and other BI tools.
• Other duties as assigned.

Qualifications

• 3+ year degree or diploma in Computer Science, Information Systems, or related field.
• 3+ years of proven experience in developing reports and dashboards using business intelligence tools including Power BI, SSRS, TSQL, and Power Query.
• Power BI certification or equivalent is preferred.
• Expected to stay up to date with current trends and technologies.

Applicant Self-Identification Questions

The information collected in Apply to Education is used to monitor WRDSB’s progress toward our equity goals including our commitment to diversity in WRDSB recruitment and hiring practices.

We are committed to the security and confidentiality of information under our control, and to the protection of privacy with respect to personal and confidential information that is collected, used, disclosed and retained in the system . Information is collected pursuant to (Ministry of Education), and the Municipal Freedom of Information and Protection of Privacy Act . Access to this information is restricted to specific individuals in Human Resources. Access, use and disclosure of the data is governed by MFIPPA and . Applicant Self-Identification data will be attached to your Apply to Education applicant profile as long as you are employed with the WRDSB.

If you prefer not to answer any of the Self Identification questions, you can select “prefer not to answer”. This in no way affects your application or the applicant selection process. If you have questions or concerns about this please contact humanresources@wrdsb.ca.

The Waterloo Region District School Board is committed to equity in employment. We are committed to fair and equitable hiring practices that allow us to hire qualified staff who reflect the diversity of the community we serve, who will foster the success and well-being of our students and who demonstrate a commitment to equity and inclusion in the classroom.

We actively encourage application from members of groups with historical and/or current barriers to equity, including, but not limited to:

• First Nations, Metis and Inuit peoples, and all other Indigenous peoples;
• Members of groups that commonly experience discrimination due to race, ancestry, colour, religion and/or spiritual beliefs, or place of origin;
• Persons with visible and/or invisible (physical and/or mental) disabilities; and
• Persons of marginalized sexual orientations, gender identities, and gender expressions.

We will make any appropriate accommodation based on any of the human rights protected grounds, to support candidate participation in the hiring process.

Upon request, we will provide reasonable accommodations in the hiring process to support applicants with disabilities.