BUSINESS INTELLIGENCE CONSULTANT

City of Toronto•Toronto, ON

22h•CA$89,337 - CA$132,880•Hybrid

About The Position

Toronto Building has a bold ambition to become a modern, client-centric regulator that helps the City achieve its strategic objectives through partnership, innovation and regulatory excellence. As Canada's largest municipal building regulator, the Division is critical to Toronto's success and prosperity. Its core services — issuing building permits and inspecting construction — ensure that Toronto's built environment is safe, accessible, and sustainable. These services also play a critical role in delivering many of Toronto's city-building priorities, including affordable housing.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.

Requirements

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.
Considerable experience in Business Intelligence and Business Analytics.
Considerable experience with Structured Query Language (SQL) programing, query design and developing scripts and reporting.
Considerable experience with maintaining data warehouse environment and with strong knowledge of ETL (extract/transform/load) concepts and processes.
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.
Experience in developing Performance Management frameworks, Key Performance Measures and Indicators.
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).
Ability designing and delivering formal group training and presentations.
Excellent strategic and lateral thinking skills in combination with strong research, analytical and problem-solving abilities.
Excellent analytical, problem-solving and conflict resolution skills.
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.

Nice To Haves

Aptitude and interest in Python, R, .NET Technology, XML/XSLT, JavaScript would be considered an asset.

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.