The City needs a Data Analyst to support management by collecting, analyzing, and reporting data from various departments to ensure efficient and effective management of services, including maintenance and life cycle planning.
Requirements
- Cityworks
- GIS
- SCADA
- AMI systems
- Relational databases
- APIs
- Data visualization tools
- Statistical analysis software
- Data management and visualization tools
Responsibilities
- Collect, clean, analyze, and interpret data from multiple sources, including Cityworks, GIS, SCADA, and AMI systems.
- Collaborate with department heads to understand data needs and ensure accurate data collection.
- Create and present detailed statistical analysis, charts, graphs, maps, dashboards and reports for decision-making purposes.
- Extract, clean, and analyze data from Cityworks AMS to track asset condition, work orders, service requests, and inspections.
- Develop custom reports and dashboards to support utility asset lifecycle tracking and maintenance planning.
- Perform routine data audits to maintain accuracy and consistency in Cityworks and GIS databases.
- Implement best practice data management strategies; develop and maintain metadata; review and clean data to ensure data quality.
Other
- High School diploma
- Ability to communicate complex data and statistical concepts to non-technical stakeholders
- Ability to work with internal and external stakeholders
- Ability to develop and maintain cooperative and professional relationships with employees and management
- Ability to perform related duties as assigned
