BUSINESS INTELLIGENCE CONSULTANT

Toronto Business Enterprise.; Toronto; On-site; CAD 94,000 - 129,000; Full time

Job summary

An innovative organization seeks a Business Intelligence Consultant to enhance data analytics capabilities. In this role, you will provide strategic advice, develop dashboards, and support decision-making processes. You will collaborate with diverse teams to ensure effective communication and implementation of BI solutions. If you're passionate about data and eager to make a significant impact in a dynamic environment, this opportunity is perfect for you. Join a forward-thinking team committed to equity, diversity, and inclusion, and contribute to meaningful community initiatives.

Qualifications

• Post-secondary education in Statistics or related field.
• Extensive experience as a BI analyst in data warehousing.

Responsibilities

• Oversee development of dashboards and visualizations for performance management.
• Perform complex data analysis and manipulation from various sources.

Skills

Data Analysis

Business Intelligence

Python

R

SQL

Presentation Skills

Problem-Solving

Communication Skills

Education

Post-secondary education in Statistics

Equivalent experience in Data Analysis

Tools

OBIEE

Tableau

Job description

Join to apply for the BUSINESS INTELLIGENCE CONSULTANT role at City of Toronto.

Get AI-powered advice on this job and more exclusive features.

Job Details

• 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: Monday to Friday, 35 hours/week
• Affiliation: Non-Union
• Number of Positions: 2
• Posting Period: 7-May-2025 to 22-May-2025

Role Overview

The Business Intelligence Consultant (BIC) provides strategic analytical advice and services to enhance the division's data analytics capabilities, supporting strategic planning, decision-making, public information, and engagement.

BIC will develop analysis, dashboards, and visualizations based on business requirements, liaise between business and BI teams, and assist with testing and quality assurance. The role includes training business users to create or modify analyses.

Major Responsibilities

• Oversee development of dashboards/visualizations supporting performance management and reporting
• Perform complex data analysis and manipulation from sources like Oracle and flat files
• Analyze reports and document business metrics, models, and dashboard requirements
• Coordinate with business and BI teams to clarify decision support needs
• Support interpretation of performance data and connect analyses for insights
• Develop performance measures aligned with strategic goals
• Recommend improvements for divisional and city initiatives
• Prepare management reports on BI solutions and processes
• Participate in pilot projects and data mining activities
• Manage sensitive data following privacy protocols
• Respond to ad hoc data requests with high-quality information
• Develop service standards and performance measures
• Design and update dashboards for business recovery and performance
• Consult with managers on data findings and recommendations
• Create decision support info from various data sources and maintain data dictionaries
• Implement information management standards and tools
• Develop data products for open data repositories
• Collaborate with data providers and stakeholders
• Ensure effective communication with users and developers
• Deliver presentations and reports to diverse audiences
• Build team knowledge and support continuous learning in BI

Key Qualifications

• Post-secondary education in Statistics, Data Analysis, or related field, or equivalent experience
• Extensive experience as a BI analyst in data warehousing, with skills in OBIEE/Tableau and dimensional modeling
• Experience in two or more areas: BI, analytics, strategy, or data warehousing
• Proven ability to lead and implement process improvements within critical timelines
• Experience in research, data extraction, analysis, and reporting
• Knowledge of performance management frameworks and indicators
• Experience delivering training and presentations
• Experience working with equity-seeking communities is an asset
• Skills in Python, R, SQL+ are assets
• Familiarity with Agile methodologies is an asset
• Strong strategic, analytical, and problem-solving skills
• Excellent interpersonal and communication skills
• Ability to train end-users in analysis creation and modification

Equity, Diversity, and Inclusion

The City promotes an inclusive workplace reflecting its diverse community. Learn more about employment equity.

Accommodation

The City is committed to accessible employment practices. If you require accommodations during the recruitment process, please inform us when contacted. More info on policies and accommodations is available.