Job Number: 3846
Job Type: Full-Time
Vacancy Reason: Net New
Location: 150 Frederick St - Regional Admin Headquarters
Job Category: Information Technology
Number of Positions: 2
Department: Database Administration and Systems Analysis
Division: Corporate Services
Hours of Work: 35 per week. This position works Monday to Friday, 8:30am to 4:30pm. This position works a minimum of 3 days in office, and 2 days at home or as per operational needs.
Union: Management/Management Support
Grade: Management/Management Support Grade 06
Salary Range: $93,347.80 - $116,680.20 annually
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.
Designs, builds, and maintains scalable data pipelines and infrastructure to support corporate and community endeavours. Ensures datasets are readily available for consumption by groups internal and external to the organization, as required. Adheres and promotes adherence to governance frameworks around data acquisition, modeling, and dissemination. Creates, maintains and administers databases, datamarts, data models and interactive data visualization for projects/programs. Provides analytical and technical support in data ingestion (ETL, ELT) and data mapping to internal teams and cross-departmental working groups.
Develops insights and provides data-driven decision making methodologies and best practices. Works with structured, semi-structure and unstructured data and provides methods and best practices in storing, querying, modelling, and interpretation. Provides methods and support for predictive analysis and modelling.
- Designing, building, and maintaining scalable data pipelines to ensure a robust flow of information for corporate and community use.
- Executing ETL/ELT processes and providing technical support for data mapping to assist internal teams and cross-departmental groups.
- Creating and managing databases, datamarts, and complex data models to support specific projects and programs.
- Promoting and adhering to strict data governance frameworks regarding how data is acquired, modeled, and shared.
- Developing interactive data visualizations and providing methodologies for data-driven decision-making and best practices.
- Managing diverse data types (structured, semi-structured, and unstructured) and establishing standards for their storage, querying, and interpretation.
- Providing the necessary technical methods and support for predictive analysis and advanced statistical modeling.
- Provide support and expertise on development lifecycle for Data across raw, cleansed and reportable levels, including the use of Development, Test and Production environments.
- Build and prototype analysis pipelines iteratively to provide insights at scale. Develop comprehensive knowledge of Regional data structures and metrics.
- Work closely with GIS team in development of new data sets where the tool offers enhanced capabilities. Leverage and promote the use of GIS within the corporation for data sets where required.
- Develop and enhance existing reports, dashboards, and other visualizations to leverage new features, improvements, and methodologies.
- Interact cross-functionally, making business recommendations (e.g., cost-benefit, forecasting, experiment analysis) with effective presentations of findings at multiple levels of stakeholders through visual displays of quantitative information.
- Facilitate engagement in the corporate reporting community by, answering questions, hosting office hours, and overseeing training.
- Participate in continuous development and innovation by looking for opportunities to apply new features, functionality, and technologies.
- Identify and assess data analysis, data management, and project-related issues (e.g., data quality, software issues) and recommend solutions to management.
- Evaluate, recommend, and implement quality improvements to increase automation and efficiency of piplenes, databases and related processes.
- Represents the Division and team and maintains relationships on inter-departmental, provincial, and national working groups and associations as it relates to data interests, as assigned.
- Performs related duties as assigned.
Knowledge, Skills, and Abilities
- Expertise in information engineering, database management system design, and specialized knowledge of ETL (Extract, Transform, Load) and ELT processes.
Normally acquired through a university degree or college diploma in Computer Science or Computer Engineering with a specialization in Data Analytics or Business Intelligence and 3 years of related experience.
- In-depth understanding of relational and dimensional modeling, data warehousing concepts (e.g., Kimball), and semantic modeling.
- Knowledge of frameworks for data acquisition, data lineage, privacy (de-identification), and government/ministry security standards.
- Ability to design and maintain scalable data pipelines using industry tools.
- Understanding of structured, semi-structured, and unstructured data storage and retrieval techniques.
- Familiarity with predictive modeling methodologies and the lifecycle of machine learning.
- Proficiency in SQL (complex scripts, triggers, stored procedures) and programming languages such as Python.
- Skill in creating interactive dashboards and visualizations using Power BI.
- Hands-on experience in administering databases, datamarts, and data lakes.
- Strong ability to develop data-driven decision-making methodologies and debug complex data flows.
- Experience in database administration is a definite asset but is not required.
- Knowledge of and ability to comply with corporate policies and procedures, database policies and procedures, privacy legislation (e.g., Personal Health Information Protection Act, Municipal Freedom of Information and Protection of Privacy Act), and principles and methodology specific to statistical analysis and data management.
- Knowledge of GIS technologies and applications within data framework.
- Ability to extract, collate, analyze, and interpret data from multiple sources per established principles and methodology, and use reasoning and problem solving skills to identify data quality and software issues, and develop and recommend solutions.
- Ability to keep knowledge and skills current as it relates to data engineering, data management, technology/software, and statistical analysis.
- Communications skills to understand and determine current operations and procedures, and clients’ desired outputs; train clients; interpret technical concepts; express complex technical concepts effectively; provide technical support; and participate as an effective team member.
- Ability to write/prepare reports and display statistical data in easy to understand formats, and draft technical documents involving analytical or interpretive descriptions to professional and lay audiences.
- Ability to compile and write data design outlines/specifications, report and dataset/data flow instructions, system specifications, and memos. Ability to read and understand policies, procedures, user/technical manuals, forms, contracts, and technical resources.
- Ability to travel within and outside 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, colour, 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
[email protected], 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).
