Transit Data Systems & Reporting Specialist

Bi-State Development; St. Louis (MO); On-site; USD 61,000 - 71,000; Full time

Benefits offered by this job

Medical coverage

PTO 4 weeks

Holidays + floating birthday

401(k) retirement plan

Wellness program

Transit access

Job summary

Bi-State Development seeks a Transit Data Systems & Reporting Analyst to steward Metro's data systems of record, ensuring accuracy and reliability of ridership, fare, and performance data used for regulatory reporting and financial accountability. The position develops and maintains reporting processes, monitors system performance, and supports compliance with FTA and NTD reporting requirements.

This role partners with Operations, Finance, IT, Planning, vendors, and external agencies to improve

Qualifications

• Knowledge of database management, data warehousing, and data integration.
• Strong analytical skills with proficiency in Excel, SQL, Power BI, Tableau, Access, or similar tools.
• Understanding of transit operations, scheduling, ridership measurement, and performance management.
• Ability to translate operational data into actionable insights.

Responsibilities

• Serves as business owner for transit data systems of record, including ridership, APC, fare, scheduling, AVL, and related data systems.
• Develops and maintains data accuracy, completeness, consistency, and timeliness across multiple systems.
• Monitors data transfers, investigates data quality issues, and ensures reporting reliability.

Skills

Excel

SQL

Power BI

Tableau

Access

Education

Bachelor's degree

Tools

Power BI

Tableau

Access

SQL

Job description

Bi-State Development seeks a Transit Data Systems & Reporting Analyst to steward Metro's data systems of record, ensuring accuracy and reliability of ridership, fare, and performance data used for regulatory reporting and financial accountability. The position develops and maintains reporting processes, monitors system performance, and supports compliance with FTA and NTD reporting requirements.

This role partners with Operations, Finance, IT, Planning, vendors, and external agencies to improve