MTA Mobility stakeholders need actionable analysis on data collection and assessment of Service Delivery practices. The QA Data Analyst will conduct audits that ensure compliance with MTA Mobility protocols.
Requirements
Experience with MS SQL Server or other relational database systems
A working knowledge of Trapeze PASS paratransit software suite or event-based paratransit application is required and a detailed understanding of Trapeze is a plus
Ability to develop and execute relational database queries and stored procedures
Understanding of XML and SQL queries to extract data from Oracle databases
Knowledge of statistics, at least to the degree necessary in order to communicate easily with Statisticians
Intermediate level of proficiency or above in Microsoft Word, Excel and Access
Programming skills preferred
Responsibilities
Conduct data sampling, data analysis, report preparation, and reviewing information from MOCC and Service Delivery Contractors
Perform complex quantitative and qualitative data review, precision analysis, and investigation and reporting
Review data reconciliation and billing data for all service delivery providers
Monitor MTA Mobility performance measures
Preparation and distribution of real-time, daily, weekly, monthly, quarterly and annual reports
Compile service statistics for federal, state, local and MTA stakeholders
Analyze data collected from Mobility Contractors related to service interruptions
Other
This position sits in-office Mon-Fri in Hyattsville, MD 8am-5pm eastern.
High School Diploma or G.E.D.
Bachelor’s degree with an emphasis on quantitative analytics or experience in a related field
Minimum of two (2) years’ experience in quantitative analytics such as: performance measurement, user segmentation, test design, modeling and web analytics
Ability to work independently and also collaboratively with others to achieve defined goals
