BUSINESS INTELLIGENCE CONSULTANT

City of Toronto; Toronto; On-site; CAD 93,000 - 124,000; Full time

Job summary

The City of Toronto is seeking two Business Intelligence Consultants to oversee data analysis, reporting, and visualizations. Candidates will manage ad hoc and scheduled report requests using Power BI, while ensuring quality information is provided to various audiences. These roles are crucial for enhancing the division's data governance and management practices.

Qualifications

• Experience in conducting research and data analysis.
• Ability to manage data-related report requests effectively.
• Experience in dashboard creation using Business Intelligence tools.

Responsibilities

• Oversee development and maintenance of dashboards and analytics.
• Lead a team handling report requests and data insights.
• Analyze quantitative data for Divisional audiences.

Skills

Data Analysis

Stakeholder Management

Data Visualization

Communication Skills

Education

Post-secondary education in computer science, data management, statistics, or data analysis

Tools

Power BI

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert: Create Alert

• Job Category: Policy, Planning & Research
• Division & Section: Employment & Social Services, E&SS Strategic Program Management
• 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:

1. Analytic Lead

• Lead and conduct data analysis and interpretation activities
• Lead the development and mobilization of key findings and data insights
• Lead triaging, business requirements collection, and stakeholder management for ad hoc and scheduled report requests
• Oversee the development, validation, and dissemination of requested data products

These assignments will support operational needs while ensuring consistency in delivering business intelligence functions across the division

Key Qualifications:

Your application must describe your qualifications as they relate to:

• Post-secondary education in a relevant discipline (e.g., computer science, data management, statistics, data analysis) or an equivalent combination of education, training, and experience.
• Considerable experience in conducting research, extracting data, data analysis, summarizing findings, and preparing reports.
• Considerable experience effectively managing data-related report requests, including interacting with stakeholders to understand data/reporting needs and developing comprehensive business/reporting requirements.
• Considerable experience in one or more of the following:
• Managing data within a relational database environment
• Creating reports, data visualizations, and/or dashboards using Business Intelligence tools/software (e.g., Power BI)
• Leading BI / Data governance projects dealing with data quality, metadata, and business intelligence (analytical data processing strategies, standards, policies, and best practices)
• Demonstrated ability to plan, set priorities, and lead, coach, and motivate staff.
• Excellent time management and organizational skills, including the ability to prioritize multiple tasks, manage high-volume workflow, and manage numerous projects simultaneously.
• Excellent interpersonal and oral/written/presentation skills to communicate with technical and business audiences and work with cross-functional teams.

Note To Current City of Toronto Employees

City of Toronto employees are eligible to apply for the posted job opportunity, but cannot hold two different jobs. To be considered for this job posting, you must indicate that you are a "Current City of Toronto employee" on the on-line application form, and provide your "Employee Number".

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity .