Data Analyst

Data Analyst (Transportation)

**Job Number**:1665

**Job Type**: Full-Time
**Location**: 150 Frederick St - Regional Admin Headquarters
**Job Category**: Transportation
**Number of Positions**:1
**Department**: Transportation Administration
**Division**: Transportation Services
**Hours of Work**: 35
**Union**: CUPE 1883**Posting Date**:October 1, 2024
**Grade**: CUPE 1883 Grade 012
**Salary Range**: $71,507.80-$81,026.40**About Us**

The Region of Waterloo is a thriving, diverse community committed to fostering opportunities for current and future generations. 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 focus on equity, inclusion, and sustainability. Our mission is to provide essential services that enhance the quality of life for all residents, while our core values emphasize 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.

Dish with One Spoon Wampum:
- Waterloo Region is part of the Dish with One Spoon wampum, a treaty guiding our commitment to:
- Recognizing our shared humanity and land
- Taking only what we need
- Leaving some for others
- Keeping the dish clean
- This agreement underpins our vision, mission, and core values, and reinforces our dedication to meaningful reconciliation and equity.

**The Role**
- Administers program data sets for the Department. Develops, compiles, and maintains reports and interactive dashboards for internal and external audiences; performs data quality control/assurance; and coordinates corporate and external reporting. Works with management to plan and address their data needs and provides analytical support to management and other members of the team.

**Duties/Responsibilities**
- Administers internal and external program data sets derived from regional systems (e.g., Verint CM Pro, Lucity, Power Plan Miovision). Acts as the Department’s liaison with corporate Information Management and Technology Services (ITS) staff and external vendors/system owners to ensure data and system maintenance and integrity standards are implemented and maintained (e.g., updates, license renewals). Coordinates with administrative and technical ITS staff on system/data management standards related to security and user access/permissions. Collaborates with ITS and Information Management and Privacy to maintain data/data sets including implementing related changes/updates. Provides support to administer vendor and consultant contracts and agreements.
- Designs, compiles, automates, and maintains reports on interactive dashboards of program performance data for the Department and external audiences (e.g., data dictionaries, visualizations, indicators, self-serve analysis functions). Collaborates with corporate partners particularly ITS to ensure required transportation data can be integrated with other corporate data such as asset, GIS, human resources and financial data into dashboards. Assists Transportation teams to build, access, and maintain transportation data as required. Maintains transportation data for internal intranet and external website.
- Works with transportation management, external stakeholders, and transportation business units to establish and maintain data sets and systems to support integrated client service delivery. Recommends software, data set structure, and required service enhancements to maximize the useability of departmental data internally and externally while meeting all corporate data management standards.
- Creates, recommends, and implements data quality control/quality assurance processes used by program areas to ensure data integrity meets established corporate data quality standards. Problem solves and corrects issues as required to ensure compliance with corporate data standards.
- Maintains an inventory of internal, external, and corporate data reporting requirements and facilitates the various transportation business units’ required data reporting, including taking primary responsibility for the review and approval process to ensure compliance with corporate data standards. Catalogues reports for staff, management, and stakeholder use. Monitors key performance indicators and reports to management as appropriate.
- Responds to and supports data requests from the departmental management team and all transportation business units.
- Participates on departmental and corporate data committees. Works with management to ensure departmental compliance with corporate data governance policies and develops the Department’s data strategy and priorities.
- Supports and advises management and transportation business units with data aspects of customer service, system planning, process improvement, quality assurance, and research projects. Provides support with quantitative and qualitative analysis for data visualization support as required.
- Collaborates with transpo