Specialist, Data and Digital Solutions

Regional Municipality of Peel•Brampton, ON

6d•CA$94,455 - CA$118,069•Hybrid

About The Position

The Specialist, Data and Digital Solutions role is within the Public Works – Water and Wastewater department, specifically supporting the Water & Wastewater Operations business support team. This team focuses on continual improvement initiatives and develops and maintains data and digital solutions for the Water and Wastewater Divisions. The role involves developing sophisticated algorithms, models, statistical representations, pattern recognition, and data visualizations to process data and build insightful reports, dashboards, and metrics using BI tools like Microsoft Power BI. The specialist will also complete user needs assessments, scope and develop digital solutions for divisional staff, provide technical expertise throughout the project lifecycle, and develop user and technical documentation and training. They will work closely with project teams to understand and validate requirements, design and implement user interfaces, maintain programs and applications, and develop automated processes. The role also includes identifying data sources, extracting, transforming, and analyzing data for management reports, supporting the implementation of the Region’s Work Order Management (Maximo) system, designing and maintaining metadata repositories, mining data for trends and patterns, building predictive models using machine learning techniques, conducting advanced statistical analysis, developing data visualizations and dashboards, and maintaining performance measurement scorecards. Additionally, the role requires developing and maintaining positive business relationships with internal and external stakeholders.

Requirements

A University Degree in Computer Science, Information Technology, Statistics, Economics, Mathematics, Data Management/Science or related discipline
3 years direct relevant work experience
Considerable experience in: Business Intelligence, Business Analytics, Business Strategy or Data Warehousing, Software Development, Enterprise Asset Management
Advanced Analytics, descriptive and predictive modeling skills utilizing Statistical Software packages such as SPSS, SAS, STATA, R and Text Analytics tools
Advanced skills using the Microsoft Power Platform (Power BI, PowerApps, Power Automate and SharePoint), ETL and RPA tools.
Experience working with JSON, XML, JavaScript, Python and SQL file formats
Familiarity with Data visualization tools
Ability to use a sophisticated blend of classical and advanced components like artificial intelligence, pattern recognition, databases, traditional statistics and graphics to present hidden relationships and patterns found in a large data pool
Experience with extracting valuable insights from large pools of data
Considerable experience extracting, transforming and loading data from operational systems
Considerable experience in business reporting, performance measurement and decision support systems
Project management experience and demonstrated skills in working collaboratively with cross-functional teams
Ability to communicate complex quantitative analysis in a clear, precise, and actionable manner
Strong written and verbal communication skills with the ability to present technical concepts to non-technical audiences
Strong facilitation skills to be able to deliver training on technical solutions
Demonstrate a commitment to diversity, equity, and inclusion through continuous development, modeling inclusive behaviors, and proactively managing bias

Nice To Haves

Combination of education and experience may be considered

Responsibilities

Develops sophisticated algorithms, models, statistical representations, pattern recognition, and data visualizations to process both structured and unstructured data sets and build insightful reports, dashboards and metrics utilizing BI tools such as Microsoft Power BI.
Completes user needs assessments, scoping and develop digital solutions for use by divisional staff using a variety of technology platforms and solutions.
Provide technical expertise throughout project lifecycle and develops user, technical design documentation, and end use training.
Work closely with project team to understand, document and validate requirements to ensure solutions meet project needs.
Design and implement user interfaces, maintain existing programs and applications, and develop automated processes to improve business efficiencies.
Identify and assess appropriate data sources to respond to various research or information requests.
Extract, transform and analyze data and information from a variety of sources including operational systems, to prepare management reports, metrics and dashboards.
Support the implementation of the Region’s Work Order Management (Maximo) system and act as the technical expert for the Operations teams including supporting scoping, configuration, technical and functionality requirements.
Design, develop and maintain metadata repository related to the enterprise information for assets.
Mine data to discover trends and patterns, develop algorithms to validate existing assumptions and processes.
Build predictive models using machine learning techniques such as decision trees, logistic regression and Structural Equation Modeling (SEM).
Conduct advanced statistical analysis and problem-solving utilizing data from widely varied programs and services to help realize service linkages and program objectives.
Develop sophisticated data visualization, advanced web graphics and interactive dashboards to make large datasets coherent in order to better understand patterns and explain complex issues and results to decision-makers and the general public.
Design, develop and maintain the Division's performance measurement scorecards and dashboards.
Develop and maintain positive business relationships with internal and external stakeholders.