Automated Organizational Chart Solution – Water & Power, Scalable Citywide

The City of Pasadena is launching a pilot project to implement a Software as a Service (SaaS) solution that automates the creation and maintenance of organizational charts. This pilot will focus on the Water and Power Department, covering 442 budgeted positions across 12 locations, and is designed to scale citywide to approximately 2,000 employees across 100 locations. The solution will integrate seamlessly with the City’s Tyler Munis system, ensuring accurate, real-time workforce data with minimal manual effort. The goal is to provide a dynamic, user-friendly platform that supports multiple organizational views, incorporates key data elements such as underfills, vacancies, and employee photos, and offers robust visualization tools for improved clarity and interactivity. The system must be SaaS-based, fully integrated (not custom-built), and require less than 80 cumulative hours of integration effort. This initiative will enhance transparency, streamline workforce planning, and reduce administrative burden, setting the foundation for a scalable solution that benefits the entire City organization.