Transit Data Systems & Reporting Analyst

Bi-State Development Agency of the Missouri-Illinois Metropolitan District•St. Louis, MO

5d•$60,940 - $71,095•Onsite

About The Position

The Transit Data Systems & Reporting Analyst serves as the steward of Metro's transit data systems of record, ensuring the accuracy, integrity, and reliability of operational, ridership, performance, and revenue-related 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 requirements. This role partners with Operations, Finance, Information Technology, Planning, vendors, and external agencies to improve data quality, reporting capabilities, and organizational performance. Success in this role requires a systems-thinking mindset, intellectual curiosity, and the ability to translate operational insights into improved data quality, reporting accuracy, and business processes.

Requirements

Knowledge of database management, data warehousing concepts, and data integration processes.
Strong analytical skills with proficiency in Excel, SQL, Power BI, Tableau, Access, or similar reporting and analytics tools.
Knowledge of statistical analysis, data validation techniques, and performance measurement methodologies.
Understanding of transit operations, including scheduling, service delivery, ridership measurement, and performance management.
Ability to analyze complex systems and understand the relationship between operational, financial, and regulatory data.
Ability to develop automated reporting solutions, dashboards, and data quality monitoring processes.
Strong attention to detail with a focus on accuracy, reconciliation, and internal controls.
Ability to communicate technical concepts effectively to non-technical audiences.
Strong collaboration skills with Operations, Finance, Planning, Information Technology, executive leadership, vendors, and external stakeholders.
Ability to manage multiple projects and lead cross-functional problem-solving efforts.
Ability to investigate anomalies, identify root causes, and recommend process improvements.
3 Years 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, financial data validation, and transit technology systems such as APC, automated vehicle location (AVL), fare collection, scheduling, or related operational systems preferred.

Nice To Haves

Preferred - Bachelors/4-year degree
Data analytics, information systems, computer science, business administration, accounting,
experience supporting NTD reporting, FTA compliance activities, audits, compliance reporting, fare revenue analysis, financial data validation, and transit technology systems such as APC, automated vehicle location (AVL), fare collection, scheduling, or related operational systems preferred.

Responsibilities

Serves as the business owner and steward for transit data systems of record, including ridership, automated passenger counter (APC), fare collection, scheduling, vehicle location, and related operational data systems.
Develops and maintains processes to ensure data accuracy, completeness, consistency, and timeliness across multiple systems.
Monitors system integrations and data transfers and identifies, investigates, and resolves data quality issues.
Develops and maintains data validation procedures, exception reporting processes, and audit trails to support reporting accuracy and transparency.
Serves as a liaison between agency departments, vendors, and technology partners to support system maintenance, troubleshooting, and enhancements.
Leads the preparation, validation, documentation, and submission of NTD reports and other required 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 applications, automated reports, and data visualization tools.
Develops automated analyses to identify data gaps, unusual trends, equipment failures, and reporting exceptions.
Evaluates automated passenger counter, fare collection, scheduling, computer-aided dispatch, and automated vehicle location data to ensure accuracy and reliability.
Conducts root-cause analyses of discrepancies and recommends corrective actions.
Supports fare revenue monitoring, reconciliation, and financial accountability through data analysis and validation activities.
Collaborates with Finance to ensure the accuracy of revenue reporting and internal controls.
Assists with audits, compliance reviews, and requests for operational, ridership, and financial information.
Develops analyses supporting service planning, scheduling, operational performance monitoring, and strategic initiatives.
Investigates ridership trends, service delivery performance, and operational anomalies and communicates findings to stakeholders.
Maintains documentation related to data definitions, business rules, reporting methodologies, and quality assurance processes.
Serves as a subject matter expert for agency performance metrics, reporting methodologies, and data governance practices.

Benefits

Join a company committed to making a positive impact in the community
Receive a competitive salary
Enjoy comprehensive medical, prescription, dental, and vision coverage starting on your first day
Earn 4 weeks of paid time off (PTO) each year
Take advantage of 10 paid holidays annually — plus a floating holiday to celebrate your birthday
Contribute to our company-sponsored 401(k) retirement plan
Access supplemental benefits through Unum, including off-the-job accident, critical illness, whole life, and hospital indemnity insurance
Participate in our wellness program, which includes free health screenings
Use our Employee Assistance Program (EAP) for confidential support and resources
Bi-State Development is an eligible employer for the Public Service Loan Forgiveness (PSLF) program
Get exclusive gym discounts at Club Fitness, The Edge Fitness Clubs, and OneLife Fitness at Ballpark Village
Work out anytime at one of our nine onsite gyms, available 24/7
Enjoy free MetroLink and MetroBus access
Save with discounted cell phone plans
Let us support your well-being and professional growth while making a difference!