Business Intelligence Consultant

2 weeks ago

Toronto, Canada City of Toronto Full time

**Job ID**: 33256

**Job Category**:Policy, Planning & Research

**Division & Section**:Municipal Licensing & Standards, MLS Policy & Strategic Support

**Work Location**:City Hall, 100 Queen Street W. Toronto

**Job Type & Duration**:Full-time, Temporary (12 Month) Vacancy

**Salary**:$93,500.00 - $119,274.00

**Shift Information**: Monday to Friday, 35 Hours Per Week

**Affiliation**: Non-Union Management

**Number of Positions Open**: 1

**Posting Period**: 09-Feb-2023 to 24-Feb-2023

The Municipal Licensing and Standards (MLS) Division supports the City of Toronto by providing bylaw administration and enforcement services, including targeted strategies to address graffiti, noise, business inspections, parks regulations and animal services issues, as well as business licensing and permitting, property standards, and animal care, including control, shelter and adoption services. In recent years, MLS has led exciting regulatory work in areas such as: Private Transportation Companies (Uber/Lyft), Short Term Rentals and RentSafeTO apartment building standards. In the role of Business Intelligence (BI) Consultant, you will play a critical role within the Division by supporting these initiatives with accurate and timely reporting and analysis.

Reporting to the Manager of Business Planning Performance and Intelligence, you will help develop and maintain MLS'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.
- 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 progre

  • Business Intelligence Consultant

    7 days ago

    Toronto, Canada INNOVER GLOBAL INC Full time

    **Responsibilities**: - Lead the design and development of data warehouse solutions using SQL Server, ADF, and other ETL tools. - Build and optimize databases, data warehouses, and data marts, with a focus on delta/incremental and full loads. - Collaborate with cross-functional teams to analyze requirements, design data models, and develop ETL programs. -...

  • Consultants

    2 weeks ago

    Toronto, Canada The Canadian Centre for Business Intelligence (TCCBI) Full time

    The Canadian Centre for Business Intelligence (TCCBI) is a Canadian business consulting firm based in Toronto, Ontario that is owned and operated by professional Canadians who live and _work_ in North America and around the globe. Our mission is to assist Canadian business owners in particular as well as those who seek Canadian expertise around the...

  • Experienced Consultants

    4 weeks ago

    Toronto, Canada The Canadian Centre for Business Intelligence (TCCBI) Full time

    The Canadian Centre for Business Intelligence (TCCBI) is a Canadian business consulting firm based in Toronto, Ontario that is owned and operated by professional Canadians who live and work in North America and around the globe. Our mission is to assist Canadian business owners in particular as well as those who seek Canadian expertise around the globe. At...

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, Canada Carpedia International Full time

    Senior Consultant, Business Intelligence Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations....

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, Canada Carpedia International Full time

    Senior Consultant, Business Intelligence Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations....

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, Canada Carpedia International Full time

    Senior Consultant, Business Intelligence Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations....

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Toronto, ON, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, Canada Carpedia International Full time

    Senior Consultant, Business Intelligence Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations....

  • Research Consultant

    4 weeks ago

    Toronto, ON, Canada Valona Intelligence Group Full time

    Valona is a leading global provider of competitive and market intelligence solutions. Our hybrid model combines proprietary technology and human intelligence to optimally collect, filter, analyze, and package information in an easy-to-understand format that supports decision-making and strategic planning. Valona is seeking an energetic, hard-working,...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Toronto, ON, Canada Carpedia International Full time

    Senior Consultant, Business Intelligence Carpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations....

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Toronto, ON, C6A, Ontario, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Analyst, Human Intelligence

    7 days ago

    Toronto, ON, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...

  • Analyst, Human Intelligence

    1 day ago

    Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...