BUSINESS INTELLIGENCE CONSULTANT

City of Toronto; Toronto; On-site; CAD 94,000 - 129,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Consultant to enhance data analytics capabilities within the Public Health division. This role involves developing insightful dashboards, conducting complex data analysis, and collaborating with various teams to ensure effective decision support. The ideal candidate will possess a strong background in business intelligence, data management, and project management, alongside excellent communication skills. Join a forward-thinking organization committed to equity, diversity, and inclusion, where your contributions will significantly impact public health initiatives and community engagement.

Qualifications

• Extensive experience as a business intelligence analyst in a data warehousing environment.
• Experience leading and implementing changes to improve BI & Data services.
• Strong strategic, analytical, problem-solving, and negotiation skills.

Responsibilities

• Oversee the development of business intelligence dashboards and visualizations.
• Analyze existing reports and lead the identification of business metrics.
• Prepare and deliver presentations and performance measurement reports.

Skills

Business Intelligence

Data Analysis

Project Management

Statistical Analysis

Python

SQL

R

Agile Project Management

Interpersonal Skills

Analytical Problem Solving

Education

Post-secondary education in Statistics

Data Management

Project Management

Tools

OBIEE

Tableau

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: Public Health, Operation and Business Services
• Work Location: Union Station
• Job Type & Duration: Full-time, 2 Temporary (14-month) vacancies
• Salary: $94,905-$128,386 Annually
• Shift Information: Monday to Friday, 35 hours per week
• Affiliation: Non-Union
• Number of Positions Open: 2
• Posting Period: 7-May-2025 to 22-May-2025

The Business Intelligence Consultant(BIC) provides strategic analytical advice and services to enhance the division's data analytics capabilities in the development and sustainment of accurate, consistent, relevant, and timely business information to support strategic planning, decision support, public information, and engagement.

The BIC will help with the development of analysis, dashboards, and visualizations based on provided business requirements and documentation for data reporting and business intelligence. The BIC will liaise between business, BI, and DW team developers to understand, clarify, and document the business decision support requirements, and facilitate dashboards/analysis built to meet business needs. The BIC will also assist with testing and quality assurance, and train business users to create or modify analyses.

Major Responsibilities:

• Prioritize and oversee the development of business intelligence dashboards and visualizations supporting performance management, case management, and outcome reporting.
• Perform complex analysis and manipulation of source data from Oracle and other data structures (flat files/text files) to populate data for dashboard development.
• Analyze existing reports and lead the identification and documentation of business metrics, models, scorecards, and dashboard requirements.
• Act as liaison between business and BI & DW teams to understand, clarify, and document decision support requirements.
• Support the interpretation of performance/outcome data and connect analyses to provide insights into public health data.
• Develop performance measures and contribute to strategic objectives.
• Provide recommendations for divisional/city initiatives and optimize resource use.
• Prepare reports for management regarding changes in BI solutions, methods, staffing, and resources.
• Participate in pilot projects and data mining, including trend analysis.
• Ensure sensitive data is handled following privacy protocols.
• Respond to ad hoc information requests with high-quality, timely reports.
• Develop service standards and performance measures based on request history.
• Oversee development and updates of dashboards for business recovery and performance.
• Create reports and consult with managers on data findings and recommendations.
• Maintain a data dictionary and develop information management standards and tools.
• Identify and develop data products for disclosure or open data repositories.
• Collaborate with information providers and stakeholders to develop and share data definitions.
• Ensure effective communication with business users and developers regarding data issues.
• Prepare and deliver presentations, performance measurement, and benchmarking reports.
• Develop team knowledge and oversee ongoing learning in Business Intelligence.

Key Qualifications:

Applicants must describe how their qualifications relate to:

• Post-secondary education in Statistics, Data Analysis, Data Management, Project Management, or equivalent experience.
• Extensive experience as a business intelligence analyst in a data warehousing environment, especially with OBIEE/Tableau and dimensional modeling.
• Experience in at least two of the following: Business Intelligence, Business Analytics, Business Strategy, or Data Warehousing.
• Experience leading and implementing changes to improve BI & Data services, operational efficiencies, and re-designs.
• Research, data extraction, analysis, reporting, and documentation experience.
• Experience developing Performance Management frameworks and KPIs.
• Experience designing and delivering training and presentations.
• Experience working with equity-seeking communities or with an equity lens is an asset.
• Skills with Python, R, and SQL+ are assets.
• Familiarity with Agile project management is an asset.
• Strong strategic, analytical, problem-solving, and negotiation skills.
• Knowledge of compliance, governance, and security best practices.
• Excellent interpersonal and communication skills.
• Ability to train users in creating or modifying analyses in dashboards is desirable.

Equity, Diversity and Inclusion

The City is committed to creating an inclusive workplace that reflects the diversity of the residents it serves. Learn more about the City’s commitment to employment equity.