City of Toronto

BUSINESS INTELLIGENCE CONSULTANT

City of Toronto • $89K — $132K *
Toronto, ON M3C 0E3In-Person
Business Services
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Post-secondary education in a related field; Master's preferred.
  • Significant experience in Business Intelligence and Analytics.
  • Strong skills in SQL programming and query design.
  • Expertise in maintaining data warehouse environments and ETL processes.
  • Proficiency with BI tools like Tableau and PowerBI for dashboard creation.
  • Experience in developing Performance Management frameworks and KPIs.
  • Ability to work towards obtaining Ontario Building Code qualification.

Responsibilities

  • Implement program-specific plans and procedures.
  • Conduct relevant research considering corporate policies and legislative initiatives.
  • Administer and control assigned budget expenditures.
  • Maintain and enhance the Business Intelligence Environment.
  • Create dashboards and performance reports for data visualization.
  • Respond to ad hoc information requests with high-quality data analysis.
  • Support strategic planning through insightful data analysis and performance measures.

Benefits

  • Hybrid work location (City Hall, 100 Queen St. West)
  • Full-time temporary position (12 months duration)
  • Work schedule: Monday to Friday, 35 hours per week
  • Opportunity to influence policy and operational decision-making
  • Engagement with various stakeholders across the City and municipal levels
Full Job Description
Job ID: 64855

Job Category: Policy, Planning & Research

Division & Section: Toronto Building, Tor Bldg Business Operations

Work Location: City Hall, 100 Queen St. West (Hybrid)

Job Type & Duration: Temporary, Full-Time (12 months)

Salary Range: $89,337.00 - $132,880.00, TM2202, PTM2

Shift Information: Monday to Friday, 35 hours per week

Affiliation: Non-Union

Number of Positions Open: 1

Posting Period: 12-Aug-2026 to 26-Aug-2026

Reporting to the Manager of Business Planning Performance and Intelligence, you will help develop and maintain Toronto Building's business intelligence environment. You will consolidate data from a number of internal and external sources, prepare it for analysis, run queries against the data and create data visualizations, BI dashboards and reports to make the analytics results available to business users for operational decision-making and strategic planning.

Major Responsibilities:
  • Implements detailed plans and recommends procedures regarding program specific requirements.
  • Conducts research into assigned area ensuring that such research takes into account developments within the field, corporate policies and practices, legislation and initiatives by other levels of government.
  • Provides input into and administers assigned budget, ensuring that expenditures are controlled and maintained within approved budget limitations.
  • Maintains Business Intelligence Environment.
  • Creates reports and consults with the Managers regarding data collection findings and recommendations.
  • Develops and designs business and performance measures dashboards.
  • Creates decision support information from operational systems, surveys and third-party data sources.
  • Responds to ad hoc information requests through sourcing and reporting the highest quality information possible in a timely manner.
  • Works on research projects and data mining, including trends analysis.
  • Assists with business intelligence program development integrating data that supports performance management, case management, outcome reporting.
  • Supports senior management in the interpretation of performance/outcome data and creates connections between analyses to provide insight into achievements and underperformance at an office, team and caseworker level. Develops performance measures and provides input into measures to support strategic objectives.
  • Develops service standards and performance measures to guide proactive development of new products and/or processes.
  • Develops programs and queries and other data for labour relations and performance related issues. Oversees sensitive data and follows all privacy protocols regarding information storage and extraction.
  • Maintains a data dictionary of all valid, tested and repeatable data constructs, data objects and information products.
  • Develops, implements and applies sound information management standards, procedures and tools to provide consistent, accurate, timely information.
  • Identifies, prioritizes and develops data products suitable for disclosure or contribution to enterprise open data repositories.
  • Develops and produces information publications such as annual reports.
  • Liaises with information providers throughout the City and other service providers and municipalities to develop and share information and data definitions.
  • Liaises with business users and developers to ensure effective communication and addressing production data and application issues.
  • Prepares and delivers presentations, performance measurement and benchmarking reports and data to staff, the public, external agencies, and community organizations.
  • Develops the teams' knowledge base and oversees the continuous learning required in the Business Intelligence field.
  • Provides recommendations that contribute to divisional/City initiatives and the effective use of human/fiscal/IT assets and services that will lead to service efficiencies and optimization of resources.
  • Prepares reports for management in relation to changes in business technology solutions, business methods/processes including appropriate resource allocation.
  • Oversees projects on the execution and completion of assigned projects (i.e. defines purpose, objectives, project activities, milestones and deliverables, monitors work performance and tracks progress to ensure project goals and timelines are met).
  • Reports caseload and performance measures to the City's management dashboard and FPARS.
  • Creates contingency plans for both business and system interruptions and supports business continuity planning.
  • Oversees the development and delivery of information and research support for Service Plans, policies and Council reports for all program areas in the division
  • Develops risk mitigation plans and forecasts related to impacts from policy, budget and regulation changes.


Key Qualifications:

Your application for the role of Business Intelligence Consultant must describe your qualifications as they relate to:
  1. Post-secondary education in a relevant discipline (e.g. Computer Science, Mathematics, Statistics, Data Analysis, Business Administration, Engineering or related field) or an equivalent combination of education, training, and experience; Master's degree is preferred.
  2. Considerable experience in Business Intelligence and Business Analytics.
  3. Considerable experience with Structured Query Language (SQL) programing, query design and developing scripts and reporting.
  4. Considerable experience with maintaining data warehouse environment and with strong knowledge of ETL (extract/transform/load) concepts and processes.
  5. Considerable experience with Business Intelligence tools (e.g. Tableau, PowerBI, SSRS, OLAP tools) along with experience in creating dashboards and data visualization for different audiences.
  6. Experience in developing Performance Management frameworks, Key Performance Measures and Indicators.
  7. Must possess or be able to obtain the following Ministry of Municipal Affairs & Housing Ontario Building Code qualification: Powers and Duties of a Chief Building Official (Legal).
  8. Aptitude and interest in Python, R, .NET Technology, XML/XSLT, JavaScript would be considered an asset.
  9. Ability designing and delivering formal group training and presentations.
  10. Excellent strategic and lateral thinking skills in combination with strong research, analytical and problem-solving abilities.
  11. Excellent analytical, problem-solving and conflict resolution skills.
  12. Exceptional interpersonal and negotiation skills with the ability to establish positive working relationships and interact and communicate effectively with employees, divisional and corporate staff, outside agencies/and or politicians, other levels of government and members of the public.


About City of Toronto

City of Toronto provides its users with information on the lifestyles, business, and locations of Toronto. Lifestyle information consists of health, energy, services, children’s services, arts, culture, festivals, events, housing, and transportation. Business-related information consists of investments, startups, reports, event planning, and city-based partnerships. Furthermore, it provides its users with history, facts, images, events, and attractions of Toronto. City of Toronto is based in Ontario.

City of Toronto Careers

There has never been a better time to explore the diverse job opportunities at the City of Toronto—the hub of professional growth and innovation in the region.

Work You’ll Experience

Join the City of Toronto’s dynamic team to assist in transforming the city through public service and innovative leadership. The City of Toronto offers a unique position in the marketplace, combining public administration with cutting-edge initiatives that enhance the lives of its residents. Engage with a team of skilled professionals dedicated to fostering a culture of diversity, equity, and inclusion. The City of Toronto is not just a place of employment; it is a place where careers flourish and where the professional environment encourages continuous personal and professional development.

City of Toronto Jobs and Employment

The City of Toronto is building a market-leading workforce that supports the city’s vision through strategic leadership and proactive management. This team helps to master the challenges of urban growth and community service.

Innovative Work

At the City of Toronto, innovation isn’t just a buzzword—it's a practical approach to solving real-world issues that affect millions of people. With projects that range from improving municipal services to enhancing urban sustainability, employees at the City of Toronto push the boundaries of what is possible in public service.

Professional Growth and Development

The City of Toronto is committed to nurturing the careers of its employees with unmatched training, development programs, and leadership opportunities. Whether through professional development workshops, leadership training, or diversity training, the City ensures that every team member has the tools to succeed.

Explore Career Opportunities

From internships to full-time positions, the City of Toronto offers a range of job opportunities that cater to various skills and career aspirations. Positions in healthcare, engineering, finance, urban planning, and more are available, providing a broad spectrum of career paths for job seekers.

The City of Toronto Employment Culture

The City’s employment culture is centered on creating a supportive and inclusive workplace. This culture is evident in its commitment to diversity and innovation, where each team member’s contributions are valued and celebrated.

Stay Connected with City of Toronto Careers

Join the Team

Search open positions that match your skills and interests. The City of Toronto looks for passionate, curious, creative, and solution-driven team players. Explore the various benefits, from health insurance to retirement plans, that make the City of Toronto a premier employer.

Keep Up to Date

Stay informed with career tips, insider perspectives, and industry-leading insights—all from the professionals who are part of the City of Toronto team.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at the City of Toronto.

SEARCH CITY OF TORONTO JOBS

READ CAREERS BLOG

Learn more about City of Toronto
Size
10,001 employees
Industry
Education, Government & Non-Profit
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at City of Toronto

More Business Services Jobs

Find similar BUSINESS INTELLIGENCE CONSULTANT jobs:

NationwideToronto, ON