Protect our Land, Ascend with Us!

Ascension LLC is seeking a Data Analyst to support the Maryland Transit Administration under the Transit Business, Organization, and Program Development IDIQ contract. This role provides core analytical, data quality, and reporting support across all planning, organizational development, mobility, compliance, and performance-related activities.

The Data Analyst will work as part of a cross-functional analytic and planning team supporting multiple Task Orders from MTA’s Office of Planning. Responsibilities include cleaning and structuring transit datasets, preparing KPI reports, performing operational analysis, supporting Title VI/ADA compliance documentation, building data tables and maps, and maintaining standardized analytic workflows.

This position can be established as a full-time role, or as a dual-role position alongside the Senior Transit Data Analyst to form a scalable analytics team.

---

Key Responsibilities

1. Data Cleaning, Validation & Preparation

• Collect, clean, and validate datasets from APC, AVL, GTFS, fare systems, schedules, HR systems, and operational logs.
• Standardize data formats, handle missing/erroneous values, and maintain documentation of data quality processes.
• Prepare datasets for dashboards, planning analysis, compliance projects, and executive reporting.

2. Transit Operations Analysis

• Support analysis of ridership trends, load factors, headway adherence, service reliability, and trip-level performance.
• Assist with evaluations of fixed-route, paratransit, and microtransit operations.
• Produce analytic inputs used for run-time validation, scheduling review, or route design enhancements.

3. KPI Tracking & Performance Reporting

• Develop charts, tables, and basic dashboards for the Tangible Results Program.
• Track metrics for service quality, labor utilization, workforce capacity, customer experience, and operational efficiency.
• Assist senior analysts with compiling monthly, quarterly, and annual reporting packages.

4. GIS & Mapping Support

• Prepare maps and spatial layers for route performance, demographic equity, mobility patterns, and capital projects.
• Support geospatial data preparation for Title VI, ADA, and service development studies.

5. Federal Compliance Support

• Assist in preparing datasets for Title VI service equity analysis.
• Support ADA operations reporting such as trip denials, on-time performance, and service coverage.
• Compile compliance-related datasets for procurement, safety, or HR projects.

6. Real Estate & Benefits Analysis Support

• Provide analytic inputs for cost-benefit analyses, station access evaluation, and planning studies.
• Support mapping and data preparation for land-use and capital planning work.

7. Organizational Development & HR Data Analysis

• Assist with staffing analyses, workforce capacity reporting, and job classification support.
• Prepare data supporting HR policy updates, talent acquisition, and position reviews.

8. Task Order & Deliverable Support

• Support the development of technical inputs for TO proposals (LOE tables, data requirements, scheduling assumptions).
• Prepare structured datasets, technical appendices, visualizations, and summary tables for deliverables.
• Maintain standardized analytic scripts, templates, and documentation.

---

Daily Activities

• Collect and clean datasets from multiple MTA systems.
• Prepare tables, charts, and visualizations.
• Update KPI dashboards and performance trackers.
• Assist in creating memos, reports, and presentations.
• Conduct field validation when needed.
• Coordinate with planners, schedulers, and senior analysts.