PennTIME - Pennsylvania Traffic Incident Management Enhancement · 2 days ago
Toll Collection Business Systems Specialist
Middletown, PA
Full-time
Hybrid
Senior Level, Lead/Staff
$77K/yr - $103K/yr
8+ years expThe Pennsylvania Turnpike Commission is known as 'America’s First Superhighway' and is responsible for operating a safe and reliable toll road system. This position is responsible for leading the analysis and optimization of business systems that support toll collection operations, ensuring efficient and secure processing and integration.
Transportation/Trucking/Railroad
No H1B
Responsibilities
May supervise/lead and provide guidance to lower-level staff including monitoring performance, delegation of work assignments, and review of work product
Leads projects related to the enhancement or expansion of TC systems
Performs project life cycle and coordination activities that involve the design, configuration, development, testing, installation, or upgrades of tolling systems and databases
Designs program logic to meet the performance and processing needs for business requirements
Maintains the database, job scheduling, nightly processing issue resolution, Structure Query Language (SQL) report writing, modifications to stored procedures and data transformation
Creates complex database queries for internal customers as well as for Toll Collection System Performance
Conducts system audits to monitor system performance
Leads the analysis of information to diagnose, troubleshoot, and resolve complex problems detected with toll collection systems, programs, hardware, software, and services
Maintains existing application software and toll collection systems support in the event of failure or changing business needs
Collaborates and consults with vendors, consultants, integrators, and contractors providing specific services or functions for the establishment and maintenance of toll collection systems
Participates in the preparation of specifications, requests for proposal (RFP), cost estimates, project plans, timelines, and budgets and works with vendors, contractors, and consultants to ensure adherence to contracts
Reviews and prepares technical documentation relating to program design and development
Performs data analysis and provides insights on toll collection metrics
Identifies data trends, issues, and patterns to support informed decision making and recommend opportunities for improvement
Works closely with stakeholders to understand reporting needs and delivers timely, accurate spreadsheets of requested data using pivot tables and charts to provide data visualization
Provides training, support, and troubleshooting guidance to stakeholders
Uses situational awareness to anticipate and prevent accidents
Performs related duties as assigned
Qualification
Required
Eight (8) years of experience with Microsoft Structure Query Language (SQL) or other database querying experience
OR
Four (4) years of Microsoft Structure Query Language (SQL) or other database querying experience AND a bachelor's degree in information technology or related field
Equivalent combination of education and/or experience may be accepted
Two (2) years of the experience must include creating reports using SQL Server Reporting Services (SSRS) or other similar reporting software
Must demonstrate proficiency in Microsoft Excel. Skills assessment may be required
Possession of a valid driver's license. Must obtain and maintain a valid Pennsylvania driver's license within six (6) months of employment
Preferred
SSRS experience preferred
Extensive knowledge of toll collection concepts, business processes, and data processing operations is preferred
Benefits
Flexible Work Options
Hybrid Work - combination of remote and in-person reporting
Alternate Work Schedule - flexibility to adjust work schedule length to complete work week in fewer days
Company
PennTIME - Pennsylvania Traffic Incident Management Enhancement
This is the Linkedin Page for PennTIME, the Statewide Pennsylvania Traffic Incident Management Enhancement Group.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase