Database Administrator​/Data Engineer

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: 1
Department: Database Administration and Systems Analysis
Division: Corporate Services
Hours of Work: 35
Union: Management/Management Support
Grade: Management/Management Support Grade 06
Salary Range: $93,347.80 - $ 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, and 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 is expected to grow to nearly one million by 2051. Guided by our  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-structured 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 elop 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…