Data Analyst (Community Services)

Job Number: 4953 Job Type: Full-Time Vacancy Reason: BackfillLocation: 99 Regina St S - Public Health & Community Serv Job Category: Other Number of Positions: 1 Department: Strategy and Partnerships Division: Community Services Hours of Work: 35 Work Schedule: Monday to Friday from 8:30am to 4:30pm, Hybrid - 3 days at home, and 2 days in office or as per operational needsUnion:  CUPE 1883 Grade: CUPE 1883 Grade 013 Salary Range: $42.12 - $47.72 per hour

About Us!The Region of Waterloo is a thriving, diverse community committed to fostering opportunities for current and future generations.  Waterloo Region is part of the Dish with One Spoon wampum, a treaty guiding our commitment to:

Taking only what we need

Leaving some for others

Keeping the dish clean

This agreement underpins our vision, mission, and core value, and reinforces our dedication to meaningful reconciliation and equity.Waterloo Region is home to over 674,000 residents and expected to grow to nearly one million by 2051. Guided by our 2023-2027 Strategic Plan, “Growing with Care,” we prioritize homes for all, climate aligned growth, equitable services and opportunities and a resilient and future ready organization. Our mission is to provide essential services that enhance the quality of life for all residents, while our core value emphasizes caring for people and the land we share. Join us and be part of a team dedicated to making a meaningful difference in our community.The Role

Administers internal and external databases and datasets for program areas within the Community Services Department (e.g., social assistance, child care, housing, scheduling, employment).

Program area assignments include day-to-day support with HIFIS (Homeless Individuals and Families Information System), and broad support to other program areas and the Community Services Department as a whole.

Analyses data, designs and implements data visualization tools, templates, reports, and models, and develops/adapts datasets to capture key metrics and insights to support program planning, projects, and requirements.

Applies skills in report writing, business analytics tools (e.g., Power BI), programming languages (e.g., R, SQL), and advanced data science methods to support program planning, forecasting, and evaluation, including machine learning, natural language processing (NLP), predictive modeling, and statistical simulations. Duties/Responsibilities

Ensures data integrity and accuracy in data and datasets.

Designs, extracts, modifies, compiles, automates, and maintains datasets, interactive dashboards, and data visualization tools (e.g., data dictionaries, visualizations, indicators).

Develops data models and analysis methods to organize and extract information from varied databases, including application of clustering, predictive modeling, and machine learning algorithms to identify trends and generate actionable insights. Assists teams and management to interpret results as required.

Presents data in effective, engaging, understandable formats using a variety of software, analytical tools, and data. Maintains data on the employee intranet and corporate website.

Prepares reports for programs, provincial and federal funding agencies, and Council/Committees of Council. Monitors KPIs and reports to management as appropriate, incorporating predictive analytics to forecast trends and highlight emerging risks.

Responds to and supports data requests from management, planners, staff, and external partners and. Catalogues reports.

Leads the design and implementation of new and updated datasets for projects, initiatives, and other program and departmental needs. Provides analytical and technical support to program areas regarding their data and system needs, including advanced statistical analysis, AI-driven solutions, and bias-detection methods to ensure equitable outcomes    .

Collaborates with staff and management regarding policy and directives, program monitoring, and administration. Facilitates changes in systems and technology. Develops templates, designs fields and process flows to meet compliance and reporting requirements. Provides expertise on data quality standards and input on operational protocols that service providers must follow.

Provides day-to-day technical support to HIFIS users. Monitors system use data and reporting by service providers as part of agreements. Troubleshoots and resolves issues. Coordinates with staff regarding system monitoring and reporting, to fix errors, and/or facilitate supports (e.g., training).

Leads/coordinates changes to data reporting requirements and system use with service providers and other stakeholders such as corporate ITS, federal and provincial contacts, and departmental program analysts and social planning associates based on scope and scale of change. Develops project plans for implementation within timelines/deadlines.

Acts as the system administrator for various databases (e.g., HIFIS), including providing user access, monitoring user accounts, and access control. Maintains data sharing and user agreements.

Creates and maintains issue tracking documents, and compiles resolutions as appropriate. Maintains documentation for support processes, business continuity, technical installations, and system management (e.g., data dictionaries).

Develops and maintains training resources for system users and provides training. Chairs technology and training working group meetings with system users. Provides ongoing technical assistance, guidance, training, and support to service providers using the system. Periodically directs and coordinates with system users regarding system changes and requirements for implementation.

Additional Duties/Responsibilities

Provides expertise in database/data model design, development, and maintenance. Analyses system capabilities, including integration with other systems and best practices for data collection, management, and reporting.

Expands traditional data models with machine learning pipelines, forecasting techniques, AI-enhanced simulations, and automated workflows to improve reproducibility, scalability, and transparency of analysis.

Has contact with other municipalities, Ministry staff, consultants, vendors, service partners, and corporate partners (e.g., ITS, public health, information and privacy) to exchange information and support data and system requirements. Leads/participates in internal and external advisory and working groups.

Maintains effective, collaborative relationships with corporate ITS staff, consultants, vendors, and others to assist with system performance, maintenance, data integrity, and report development.

Works with management to ensure departmental compliance with corporate data governance policies and to develop the Department’s data strategy and priorities.

Collaborates on training, documentation, and manuals related to datasets, systems, and procedures for processing data.

Refers complex issues to management, including major system changes that require significant resource commitments.

Performs related duties as assigned.

Knowledge, Skills, and Abilities

Knowledge and skills are acquired through a 3-year college diploma in a related field plus 3 years of related experience. A 4-year degree in a related field plus 2 years of related experience is considered equivalent.

Knowledge and skills in data management, data analysis, business intelligence and visualization software, and programming languages (e.g., SQL), with experience integrating these with Python/R workflows for machine learning and AI applications.

Demonstrated skill and experience working with Excel, data visualization software, and large datasets, including writing and troubleshooting complex queries in SQL, and presenting machine learning or predictive modeling results in clear, accessible formats.

Skill and experience in mapping, data cleaning, and preparation for ArcGIS and similar GIS tools.

Knowledge of advanced analytics, including machine learning algorithms (clustering, regression, classification, neural networks, deep learning architectures), natural language processing (NLP), predictive modeling techniques, and statistical simulations using Python/R.

Familiarity with cloud-based data platforms, AI/ML libraries (e.g., TensorFlow, PyTorch, scikit-learn), and modern collaboration tools, including MLOps practices for deploying, monitoring, and scaling AI models to support reproducible and ethical AI.

Knowledge of and ability to comply with policies, procedures, legislation (e.g., security, encryption, data protection and privacy, information, accessibility, housing), and industry standards.

Knowledge of program area client service and administrative systems, and data analysis software and systems, including those used in other areas of the corporation. Ability to keep knowledge current related to technologies, programs, and applications.

Analytical and problem-solving skills to identify gaps in data processes and practices, troubleshoot and resolve issues, and develop technical solutions and continuous improvements, including AI-driven approaches such as anomaly detection, forecasting, and optimization models.

Ability to design and implement forecasting models, AI-supported dashboards, automated machine learning pipelines, bias detection methods, and simulation tools for scenario analysis to ensure equitable, effective service delivery.

Organization and project management skills to plan project tasks and timelines, monitor results, work independently, and balance competing requests and priorities. Ability to keep knowledge and skills current.

Communication and interpersonal skills to work with internal and external partners to support their data needs; describe system and data requirements and analysis to varied audiences; provide training and explain data management practices/requirements; respond to questions from and present to staff, management, and external partners. Ability to participate as an effective team member.

Ability to write correspondence, resource/training materials, communications, reports, project plans, and manuals/instructions for technical and non-technical audiences, and draft policies and protocols related to data management and administration for management review.

Computer skills with ability to use Microsoft Office Suite, systems/databases (e.g., HIFIS), relational databases, and data analytics/tools (e.g. Power BI), integrated with Python/R workflows to develop end-to-end AI/ML solutions. Ability to prepare database forms, queries, reports, tables, and dashboards.

• Ability to travel within Waterloo Region.
• Ability to support and demonstrate the Region’s values.

Region of Waterloo is committed to building a workforce through fair, equitable, and accessible hiring practices that allow us to hire qualified staff who reflect the diversity of the community we serve and to promote a respectful, inclusive, and equitable workplace.We invite all interested individuals to apply and actively encourage applications from members of groups with historical and/or current barriers to equity, including, but not limited to:

First Nations, Métis and Inuit peoples, and all other Indigenous peoples;

members of groups that commonly experience discrimination due to race, ancestry, religion and/or spiritual beliefs, or place of origin;

persons with visible and/or invisible (physical and/or mental) disabilities;

persons who identify as women; and persons of marginalized sexual orientations, gender identities, and gender expressions

For questions or to request accommodations during your recruitment, onboarding or employment, please contact talentmanagement@regionofwaterloo.ca, or by calling our Service First Contact Centre at phone number (519) 575-4400.Use of Artificial Intelligence in the Hiring Process: Region of Waterloo may use artificial intelligence (AI) tools to enhance efficiency during the recruitment process. However, applications will also be reviewed by a member of our Talent Acquisition team to ensure a fair and thorough assessment. AI does not make final hiring decisions.  Please note: candidates will be provided an update on their application.  Please check your spam or junk folder occasionally as some candidates have noticed our emails in those folders (Gmail and Hotmail in particular).