Data Analyst II, Demand Response

Knowledge, Skills and Abilities: 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. 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. WORK ENVIRONMENT AND PHYSICAL DEMANDS Work is generally performed within a designated office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. This position works with multiple project timelines and is responsible for collaborating with employees performing work of a complex nature. Incumbent must have the ability to stand and sit frequently throughout an eight-hour period, reach vertically for overhead use as well as horizontally. Must be able to use a telephone or headset equipment. Incumbents must be able to lift and move material weighing up to 20 lbs., perform work at a computer terminal for 6-8 hours a day, and function in an environment with constant interruptions. Reasonable accommodation may be made to enable individuals with disability to perform the essential functions as previously described. Mobility Status: As an Onsite position, the incumbent's primary workplace is a CapMetro facility or field location. Expected to work in the office or field location 4+ days a week. Mobility status is subject to change at any time based on business needs or organizational decisions. COMMITMENT TO EQUAL EMPLOYMENT OPPORTUNITY CapMetro is an equal employment opportunity employer and committed to creating a welcoming environment for all employees. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, pregnancy, age, or any other protected characteristic as outlined by federal, state, or local laws. CapMetro makes hiring decisions based solely on qualifications, merit, and organization needs at the time.

Note: The duties and primary responsibilities below are intended to describe the general content of and requirements of this job and are not intended to be an exhaustive statement of duties.

Data Analysis & Reporting: 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.

Performance Monitoring & Forecasting: 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.

Stakeholder Collaboration & Business Support: 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.

Data Management & Governance: 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.

Quality Assurance & Continuous Improvement: 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.

Project & Systems Support: 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.

Regulatory & Geographic Reporting: 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.

Posting Date: 2026-10-05