Transit Data & Reporting Analyst — BI & Compliance

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

PTO 4 weeks

Holiday pay

401(k)

Job summary

Bi-State Development seeks a Transit Data Systems & Reporting Analyst to steward Metro's data systems of record, ensuring the accuracy, integrity, and reliability of operational, ridership, performance, and revenue data used for decision-making, regulatory reporting, and financial accountability.

The position develops and maintains reporting processes, monitors system performance, and supports compliance with Federal Transit Administration (FTA) and National Transit Database (NTD) reporting

Qualifications

• Bachelor's degree in a related field such as data analytics, information systems, computer science, business administration, or accounting.
• 3+ years of progressively responsible experience in data analysis, systems administration, business intelligence, transit analytics, financial analysis, reporting, or a related field; experience supporting NTD reporting, FTA compliance activities, audits, compliance reporting, fare revenue analysis, and data validation preferred.

Responsibilities

• Serves as the business owner and steward for transit data systems of record, including ridership, APC, fare collection, scheduling, vehicle location, and related data systems.
• Develops and maintains data accuracy, completeness, consistency, and timeliness across multiple systems.
• Monitors system integrations and data transfers and resolves data quality issues.
• Develops and maintains data validation procedures, exception reporting, and audit trails for accuracy and transparency.
• Leads liaison between agency departments, vendors, and tech partners for system maintenance and enhancements.
• Leads preparation, validation, and submission of NTD and other regulatory reports.
• Maintains reporting methodologies, sampling plans, supporting documentation, and compliance records.
• Monitors regulatory changes and recommends modifications to reporting and data collection practices.
• Designs, develops, and maintains dashboards, scorecards, databases, reporting apps, automated reports, and data visualization tools.
• Develops automated analyses to identify data gaps, trends, and reporting exceptions.
• Evaluates data from APC, AVL, fare collection, scheduling, and related systems for accuracy.
• Conducts root-cause analyses of discrepancies and recommends corrective actions.
• Supports fare revenue monitoring, reconciliation, and financial accountability via data analysis.
• Collaborates with Finance to ensure revenue reporting accuracy and internal controls.
• Assists with audits, compliance reviews, and data requests.
• Develops analyses supporting service planning, scheduling, and performance monitoring.
• Investigates ridership trends and operational anomalies and shares findings with stakeholders.
• Maintains data definitions, business rules, reporting methodologies, and QA processes.
• Acts as a subject matter expert for performance metrics and data governance.

Skills

SQL

Data analysis

Data governance

Regulatory reporting

Dashboard development

Cross-functional collaboration

Attention to detail

Education

Bachelor's degree

Tools

Tableau

Power BI

Excel

Access

Job description

Bi-State Development seeks a Transit Data Systems & Reporting Analyst to steward Metro's data systems of record, ensuring the accuracy, integrity, and reliability of operational, ridership, performance, and revenue data used for decision-making, regulatory reporting, and financial accountability.

The position develops and maintains reporting processes, monitors system performance, and supports compliance with Federal Transit Administration (FTA) and National Transit Database (NTD) reporting