

ETC Data Analyst
โญ - Featured Role | Apply direct with Data Freelance Hub
This role is for an ETC Data Analyst with a contract length of more than 6 months, offering a pay rate of $63,294.40 - $94,931.20. Key skills required include data visualization tools, SQL, and proficiency in Microsoft Office.
๐ - Country
United States
๐ฑ - Currency
$ USD
-
๐ฐ - Day rate
431.5045454545
-
๐๏ธ - Date discovered
August 6, 2025
๐ - Project duration
More than 6 months
-
๐๏ธ - Location type
Hybrid
-
๐ - Contract type
Unknown
-
๐ - Security clearance
Unknown
-
๐ - Location detailed
Middletown, PA
-
๐ง - Skills detailed
#Scala #SQL Server #JavaScript #SQL (Structured Query Language) #Data Analysis #Databases #BI (Business Intelligence) #Security #Monitoring #"ETL (Extract #Transform #Load)" #Computer Science #Mathematics #Predictive Modeling #Microsoft Excel #Python #Tableau #Visualization #Research Skills #Qlik #Compliance #Leadership #Microsoft Power BI #Data Quality
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Posting Start Date
August 5, 2025
Posting End Date
August 18, 2025
Position Number
80006914
Union
Non-Union
FLSA Status
Salaried Exempt
Department
Toll Collection Operations
Salary Grade
E-14
Salary Range
$63,294.40 - $94,931.20
Employment Type
Full Time
Building Location:
Central Office Building
Building Street
700 S. Eisenhower Boulevard
Building City
Middletown
Building State
Pennsylvania (US-PA)
Building Zip Code
17057
Work Schedule
Flexible Work Options
The Pennsylvania Turnpike Commission, opened on October 1, 1940, is known as โAmericaโs First Superhighwayโ! Our mission is to operate a safe, reliable, customer-valued toll road system that supports national mobility and commerce. The PTC operates a 565-mile system with over 205 million transactions annually. Together, we are building the highway of the future.
The Commission Values Its Team Members And Understands The Importance Of Work/life Balance To The Health, Well-being And Productivity Of Its Team. Therefore, This Position May Be Eligible For Flexible Work Options
โข Such As
โข 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
โข Some options may require completion of probationary period.
The Commission requires all employees to establish PA residency within 6 months of hire and to maintain PA residency, regardless of Flexible Work Options.
Applicants must be currently authorized to work in the United States on a full-time basis. The Commission will not sponsor applicants for work visas.
Job Purpose And Summary
This position is responsible for performing a wide variety of analytical and reporting duties to assist with Electronic Toll Collection (ETC) operations for the Pennsylvania Turnpike Commission (PTC). Work includes data analysis and monitoring various departmental programs, operations, processes, and procedures. Work is performed with independence and reviewed by a manager to ensure attainment of goals, completion of projects, and adequate performance.
Essential Functions & Responsibilities
Develops and delivers complex reporting and creates a strong narrative that effectively conveys data insights and recommendations. Creates detailed reports and visualizations to present to executive leadership.
Analyzes and interprets existing reports to provide actionable insights. Develops new automated reports and dashboards. Uncovers patterns and trends through reporting that capitalizes on growth opportunities and mitigates risks.
Identifies and recommends internal and external data to be used for modeling and/or decision making. Extracts data for ad hoc predictive modeling.
Identifies problems that data analytics might help solve and/or opportunities to use data analytics to guide decisions. Translates important questions into analytical tasks.
Queries and monitors databases to detect data quality issues, identify the cause, and recommend system improvements or solutions to resolve the issue.
Develops and maintains communication templates for the ETC unit to increase efficiency and ensure consistency/compliance with established policies, procedures, laws, and regulations.
Conducts field audits to validate contracted services and address on-site concerns. Analyzes and resolves escalated issues with vendors. Ensures continuous contact availability for emergency-related issues with vendor services.
Reviews cameraโs security software data to investigate customer service concerns, identify violations, and resolve issues.
Monitors practices, processes, and systems to identify opportunities for improvement. Prepares detailed and comprehensive reports of findings and/or recommendations.
Develops, recommends, and monitors project/program goals and strategic plans in coordination with department managers.
Composes/proofreads correspondence, reports, contracts, policies, and procedures to ensure accuracy and completeness. Creates and revises manuals, bulletins, and other training/instructional materials related to departmental operations.
Attends and represents the PTC in designated committees, meetings, trainings, and other events.
Uses situational awareness to anticipate and prevent accidents.
Performs related duties as assigned.
Qualifications
Eight (8) years of experience in data analytics, reporting, or an administrative/office management capacity;
OR
Four (4) years of experience in data analytics, reporting, or an administrative/office management capacity AND a bachelorโs degree in business administration, computer science, mathematics, or related field.
Equivalent combination of education and/or experience may be accepted.
One (1) year experience creating reports with data visualization tools such as but not limited to Microsoft Power BI, Tableau, Python, Qlik Sense, SQL Server, or JavaScript is required.
Must demonstrate proficiency in Microsoft Excel, Word, and PowerPoint. Skills assessment(s) may be administered prior to interviewing for this position.
Possession of a valid driverโs license. Must obtain and maintain a valid Pennsylvania driverโs license within six (6) months of employment.
Competencies
Analytical Thinking
Attention to Detail
Communication Proficiency
Decision Making and Independent Judgment
Innovation
Problem Solving/Analysis
Quality Control
Research Skills
Results Driven
Technical Capacity
Physical Demands and Work Environment
Position demands include frequent speaking, writing, and reading reports. Position requires frequent work at a computer utilizing business programs and PTC specific operating systems. Position requires frequent travel and/or fieldwork with exposure to roadway traffic. Occasionally works outside of normal business hours for assigned work assignments including being on-call for vendor issues.
Office environment with low levels of noise, adequate lighting, and comfortable temperature. Field environment may include exposure to moderately adverse and undesirable conditions. Physical environment is generally safe, but safety equipment or precautions must be followed in field conditions.
Disclaimer
The information provided in this job description has been designed to indicate the general nature and level of work performed by the incumbent(s) within this job. It is not designed to be interpreted as a comprehensive inventory of all duties, responsibilities, qualifications, and working conditions required of the employee(s) assigned to this job. Management has the discretion to add or modify duties of the job and to designate other functions as essential at any time.
The Pennsylvania Turnpike Commission is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. If you need assistance or an accommodation due to a disability, you may contact the Human Resources Department by calling 717-831-7378.