Summer Intern, Tolling Technology & Data Analytics

Port Authority of NY & NJ-posted 11 days ago
$18 - $30/Yr
Full-time • Intern
Hybrid • New York, NY
5,001-10,000 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

The Tolling Technology and Data Analytics team (TaDA), situated within the Tunnels, Bridges and Terminals Department's (TB&T) Regional E-ZPass unit, leads initiatives related to data governance and analytics, cybersecurity, and technological modernization for Port Authority tolling technology and information systems. Tolling is a major revenue generator for the Port Authority, so it is essential that the Agency's tolling data systems are reliable, consistent, and accurate. This role would be a great fit for someone interested in improving legacy systems and processes and creatively leveraging data and technology to meet operational needs. This intern will develop hands-on experience with large transactional databases, analytics and visualization, documenting datasets and workflows, process automation, and applying all of the above to real-world tolling challenges using tools like Oracle SQL, Python, the Microsoft Power Platform, and more.

  • Develop SQL and/or Python scripts and procedures to reconcile information between distinct and/or partially integrated data sources, identify discrepancies, and notify relevant parties of any anomalies that should be addressed.
  • Using available datasets and reports, assess database compliance with E-ZPass business rules to ensure that database procedures are functioning as intended and data integrity is maintained. Malfunctioning rules can have significant adverse operational and financial impacts, so it is essential that they function correctly.
  • Document key datasets, their structures, and processes that use them.
  • Build PowerBI dashboards to monitor KPIs and other metrics for gauging E-ZPass systems' health.
  • Engage with internal stakeholders on data and technology pain points and develop solutions for addressing these needs.
  • Research and evaluate modern data engineering and governance tools and make recommendations for their potential deployment in the context of current tolling technology systems.
  • Support development of long-term departmental data strategy.
  • Enrollment at a college or university at the time of the internship
  • Major in Computer Science, Data Science, Information Systems, Urban Planning, Public Policy/Administration or related discipline
  • Familiarity with Python and SQL, or the ability to rapidly learn these tools based on comparable coursework and/or programming experience.
  • Familiarity with Microsoft Power Platform (PowerBI, Power Automate, and PowerApps).
  • Knowledge of basic data engineering concepts and tools/approaches for data integration, transformation and warehousing.
  • Excellent attention to detail.
  • Excellent problem-solving and troubleshooting skills.
  • Experience working in the public sector.
  • Demonstrated interest in tolling, transportation and/or urban planning.
  • Ability to opt in to the New York State and Local Retirement System
  • Access to Employee Business Resource Groups
  • Facility Tours
  • Career Panels
  • Social/Networking Events
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service