Data Preparation and Instructional Guide for Title VI Equity Analysis and Reporting

The Regional Transportation District (RTD) is seeking a consultant to provide data preparation and instructional guide services for Title VI equity analysis and reporting. The consultant will prepare, clean, validate, and document key demographic, geographic, and operational datasets to support Title VI equity analyses required by the Federal Transit Administration (FTA). The scope of work includes preparing and documenting data sources, developing standard operating procedures, and providing training and technical assistance to RTD staff. The project will enhance RTD's internal capacity to replicate data collection and preparation prior to completing Title VI equity analyses and to maintain compliance with FTA regulations. • The consultant will work with RTD staff to identify and document data sources, including the U.S. Census Bureau's American Community Survey, Colorado Address Database, and other relevant datasets. • The consultant will develop and implement a data management plan to ensure data quality, accuracy, and completeness. • The consultant will provide training and technical assistance to RTD staff on data preparation, analysis, and reporting. • The consultant will develop and maintain standard operating procedures for data preparation and analysis. • The consultant will ensure that all work products are delivered in a format compatible with RTD's systems and software.