Specifications include, but are not limited to: Phase 1 – Implementation Readiness & Software Needs Assessment 1. Assess current data quality, data governance, and security practices. 2. Perform stakeholder interviews to gather requirements and expectations for a data warehouse. 3. Recommend improvements to existing processes and procedures. 4. Work with the City project team to create a RFP, which complies with City procurement and purchasing policies, for data warehousing software that will meet the City’s current and future needs. 5. Provide guidance to the City project team during the software selection and evaluation process. Phase 2 – Software Implementation 1. Serve as the implementation project manager for the City of Madison, provide project coordination, and report project status to key stakeholders at an agreed cadence. 2. Work with the City project team and the chosen software vendor to identify processes and functions that will be operational at the conclusion of the implementation period. 3. Provide guidance on efficient data extract, transform, and load (ETL) processes to enter data from existing systems into the data warehouse. 4. Develop an implementation plan, including training and change management plans, for the selected software. a. The change management plan will include a communications plan to ensure employees are prepared for process changes. 5. Work with key stakeholders to develop optimized processes and procedures that take advantage of the selected software platform. 6. Coordinate trainings and develop documentation for employees. 7. Track the progress of the software vendor’s implementation and ensure adherence to the project timeline. 8. Document new or changed processes resulting from the implementation.
