Job ID: 56696
Job Category: Policy, Planning & Research
Division & Section: Employment & Social Services, E&SS Strategic Program Management
Work Location: Union Station/Metro Hall, 55 John Street, Hybrid
Job Type & Duration: Full-time, 2 Temporary (12 month) vacancies
Salary: $93,734 - $123,449.00 annually
Shift Information: Monday to Friday, 35 hours per week
Affiliation: Non-Union
Number of Positions Open: 2
Posting Period: 18-Jun-2025 to 03-Jul-2025
Major Responsibilities:

Your primary responsibilities as a Business Intelligence Consultant (BIC) will be varied, but you will be expected to:

• Oversee the development and maintenance of dashboards, reports, data visualizations, and analytics in Microsoft Power BI and Report Builder
• Lead a team in responding to ad hoc information requests and new scheduled reports through sourcing and reporting the highest quality information possible in a timely manner.
• Analyze and interpret quantitative data to provide insights for a variety of Divisional audiences. Lead a team in validating data, building data models, and writing queries (SQL).
• Oversee the development and maintenance of metadata documentation for data constructs, data objects, and information products.
• Develop, implement, and apply sound information management standards, procedures, and tools to provide consistent, accurate, and timely information.
• Identify, prioritize, and develop data products suitable for disclosure or contribution to enterprise open data repositories.
• Lead the development and production of information publications such as annual reports, neighbourhood/ward profiles, etc.
• Liaise with business users and developers to ensure effective communication and training, as well as address data and reporting issues.
• Prepare and deliver reports and data to staff, the public, external agencies, and community organizations.
• Oversee projects and manage staff to facilitate the completion of assigned work and projects. Develop the team’s knowledge base and oversee continuous learning required in the Business Intelligence field.
• Apply an equity lens to data analysis and reporting, as well as prioritizing equity, diversity, and inclusion as a people leader and in support of staff / team.

This job call is for two Business Intelligence Consultant positions. While both positions will be required to perform the same major responsibilities, each will be assigned a distinct focus area:

• Oversee the development and maintenance of dashboards, reports, data visualizations, and analytics in Microsoft Power BI and Report Builder
• Lead a team in responding to ad hoc information requests and new scheduled reports through sourcing and reporting the highest quality information possible in a timely manner.
• Analyze and interpret quantitative data to provide insights for a variety of Divisional audiences. Lead a team in validating data, building data models, and writing queries (SQL).
• Oversee the development and maintenance of metadata documentation for data constructs, data objects, and information products.
• Develop, implement, and apply sound information management standards, procedures, and tools to provide consistent, accurate, and timely information.
• Identify, prioritize, and develop data products suitable for disclosure or contribution to enterprise open data repositories.
• Lead the development and production of information publications such as annual reports, neighbourhood/ward profiles, etc.
• Liaise with business users and developers to ensure effective communication and training, as well as address data and reporting issues.
• Prepare and deliver reports and data to staff, the public, external agencies, and community organizations.
• Oversee projects and manage staff to facilitate the completion of assigned work and projects. Develop the team’s knowledge base and oversee continuous learning required in the Business Intelligence field.
• Apply an equity lens to data analysis and reporting, as well as prioritizing equity, diversity, and inclusion as a people leader and in support of staff / team