Data Analyst II, Demand Response

Capital Metropolitan Transportation Authority•Austin, TX

1d•Onsite

About The Position

The Data Analyst II, Demand Response, reports directly to the Manager, Contract Administration & Analytics and supports CapMetro in making informed business decisions that improve the quality, efficiency, cost-effectiveness, and sustainability of the organization. This position analyzes operational, financial, contractor performance, customer service, eligibility, service coordination, and related datasets to identify trends, evaluate performance, and support timely management decisions. The position prepares routine and ad-hoc reports, analyzes key performance data, assists with National Transit Database reporting, and develops clear narratives, dashboards, scorecards, charts, and presentations for department leadership. The position uses Excel, SQL, data visualization tools, business intelligence platforms, and other analytical tools to access, validate, analyze, and present data.

Requirements

Bachelor’s degree in Business, Finance, Accounting, Economics, Statistics, Data Analytics, Computer Science, or a related field. Related experience may substitute for the education requirement on a year-for-year basis up to four (4) years.
Three (3) years of experience in operations analysis, financial analysis, business analysis, performance reporting, data analytics or related analytical role.
Intermediate knowledge of data analytics principles, performance measurement methodologies, financial analysis, forecasting techniques, and reporting best practices.
Intermediate skill in analyzing operational and financial data, identifying trends, developing actionable insights, and presenting findings and recommendations to management and stakeholders.
Intermediate skill in using Microsoft Excel, SQL, business intelligence platforms, data visualization tools, and other Microsoft Office applications to extract, validate, analyze, and communicate complex data.
Intermediate skill in developing dashboards, automated reports, performance metrics, and data visualizations that support operational and strategic decision-making.
Ability to manage multiple projects and priorities, coordinate with cross-functional teams, and support data-related initiatives through effective project management practices.
Ability to communicate complex analytical information clearly and effectively through written reports, presentations, and verbal discussions.
Ability to establish and maintain effective working relationships with internal and external stakeholders and contribute positively in a collaborative team environment.
Ability to leverage emerging technologies, including artificial intelligence tools, to support data ingestion, analysis, reporting efficiency, and business process improvement.

Nice To Haves

Experience with transit operations, demand response services, scheduling and dispatch systems, call-center platforms, contract performance monitoring, public-sector reporting, GIS applications, spatial analysis, data warehouse reporting, and report automation is preferred.

Responsibilities

Develop, maintain, and enhance reports, dashboards, scorecards, and analytical tools using SQL, Excel, business intelligence platforms, and data visualization tools to support operational and financial decision-making.
Analyze operational and financial performance data, including trend analysis, forecasting, projections, and cost reconciliation activities; provide actionable insights and recommendations to support departmental goals and strategic decisions.
Partner with internal departments, contractors, and stakeholders to identify business needs, define performance measures, develop reporting solutions, and communicate analytical findings through presentations, meetings, and ongoing consultation.
Extract, validate, organize, and analyze data from multiple systems; document data sources, definitions, methodologies, assumptions, and business requirements to ensure data integrity, consistency, and reliability.
Perform quality assurance reviews of reports, dashboards, data extracts, and analytical products; identify and resolve data discrepancies and recommend process improvements to enhance reporting accuracy and efficiency.
Coordinate analytical projects and reporting initiatives, maintain tracking of recurring and ad hoc assignments, collaborate with Information Technology on system enhancements, and support testing of software upgrades and reporting solutions.
Coordinate the collection and reporting of required National Transit Database (NTD) statistics and utilize GIS and mapping tools, as needed, to analyze and visualize service performance, demand, and geographic trends.
Develop and maintain user documentation and training materials related to reports, dashboards, software applications, and compliance reporting; support a culture of safety and accessibility in the delivery of transportation services.
Support Capital Metropolitan Transportation Authority’s Safety Management Systems process by following safety and security policies, considering safety in every action, and reporting safety and security concerns.
Performs other duties as required.