Hampton Roads Transit · 2 days ago

Data Analyst II

Norfolk, VA

Full-time

Onsite

Mid Level

$53K/yr - $68K/yr

2+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

GovernmentTransportation

Insider Connection @Hampton Roads Transit

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Responsibilities include data processing, analysis, and reporting for all transit modes and transit-related data within the agency.

Analyzes daily automatic passenger counter (APC) reports for deficiencies in reporting and function, to develop an APC repair plan with operations staff.

Assists in the preparation of the National Transit Database (NTD) report required to be filed annually with the Federal Transit Administration (FTA).

Assist with data compilation and analysis for National Transit Database (NTD) audits.

Create, upload, manage, and manipulate regional Geographic Information Systems (GIS) data from various sources.

Migrate reports for ridership, revenue miles, and service hours from Access database into newly developed databases for analysis.

Reviews and analyzes statistical data to evaluate the compliance of on-going service and major service changes.

Design and develop database queries and reports as needed.

Compile required monthly reports for National Transit Database (NTD), Department of Rail and Public Transportation (DRPT), and HRT Finance Department.

Manage data compilation for the bus ridership sampling process, revenue miles, and hours from HASTUS for all modes.

Develop and present oral, written, and graphic presentations that convey complex data in an accessible and understandable manner.

Ensure data integrity and research causes of inconsistencies and anomalies.

Assist with implementation of data reporting tools: Remix, APC dashboard, and TransTrack.

Manage records in compliance with the Hampton Roads Transit Records Management Policy and Procedures.

Performs other related duties as assigned.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ProcessingData AnalysisPublic Transit SystemsNational Transit Database Driver's LicenseVBASQLArcGISDatabase Management