Operates critical infrastructure connecting New York & New Jersey, including transportation & ports.
Data analyst intern handling data cleaning, SQL, Power BI, and automation for E‑ZPass.
8 days ago ago
$18 - $30
Entry-level
Internship
New York, NY
Office Full-Time
Company Size
7,500 Employees
Service Specialisms
Operations
Transportation planning and analysis
Revenue collections
Engineering
Maintenance
Sector Specialisms
Airports
Bridges
Tunnels
Seaports
Rail transit
Marine Terminals
Intermodal Freight Transport
Railroads
Role
Description
financial model
power bi
data analysis
power automate
python automation
data collection
Maintain and improve existing team’s financial model
Create Power BI visuals after gathering stakeholders’ requirements.
Complete ad-hoc data analysis tasks ranging from: gathering, cleaning, and validating data outputs using Excel and Oracle SQL.
Maintain and improve existing Microsoft Power Automate workflows.
Automate workflows using Microsoft Power Automate or python.
Create various new data collection processes
Requirements
sql
excel
power automate
kpis
relevant degree
communication
Working knowledge of databases
Familiarity with metrics and KPIs is a plus
Excellent written and oral communication skills
Major in Business Administration, Computer Sciences, Information Systems, Data Science, Operations Research, or related field.
Enrollment at a college or university at the time of the internship
Ability to opt in to the New York State and Local Retirement System
In accordance with Port Authority policy, this position permits interns to work remotely a maximum of one day per week. In person collaboration is essential to how the Port Authority conducts business and regular in-office days or team collaboration days may be required depending on business needs. Some internships may require interns to be fully in-person.
Excellent analytical and research skills
Some knowledge of Microsoft Power Automate and Powe Apps
Proficient in technology and basic Microsoft Office platforms
Excellent Microsoft Excel skills
Beginner to intermediate SQL skills
Benefits
The hourly rate range is $18.07 to $30.31 (the exact rate will be determined by internship type and rising school year)
Social/Networking Events
This is a full-time internship (5 days per week at 7.25 hours per day)
Facility Tours
Access to Employee Business Resource Groups
Training + Development
Information not given or found
Interview process
hiring team contacts selected applicants to schedule 1‑2 interviews.
only applicants under consideration will be contacted.
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
1921 Established
Year of establishment
The Port Authority was founded to oversee critical infrastructure development between New York and New Jersey.
It plays a crucial role in overseeing key infrastructure between two of the most populous and connected states in the U.S.
It operates a vast network of assets, including major airports, bus terminals, rail facilities, and shipping ports.
It oversees some of the busiest transportation hubs in the world, including John F. Kennedy International Airport and Port Newark-Elizabeth Marine Terminal.
In addition to transportation, it plays a key role in regional planning and economic development, improving connectivity for businesses and commuters alike.
Major projects include the ongoing redevelopment of LaGuardia Airport, the modernization of the Port Authority Bus Terminal, and the expansion of the PATH rail network.
It has historically been at the forefront of innovations in large-scale infrastructure projects, setting new standards in efficiency and sustainability.
A standout achievement was its leadership in the post-9/11 rebuilding efforts at the World Trade Center site, culminating in the construction of the One World Trade Center.
Culture + Values
Integrity: The company operates with honesty, fairness, and transparency.
Safety: The company maintains a safe environment for employees, partners, and the public.
Accountability: The company is responsible and answerable for its actions.
Innovation: The company embraces new ideas and technologies to improve performance.
Collaboration: The company partners across agencies, jurisdictions, and communities.
Environment + Sustainability
Net-zero by 2050
Greenhouse Gas Emissions Target
Aimed to achieve zero-net greenhouse gas emissions by 2050.
$344 million
EPA Funding Secured
Secured $344 million in funding for zero-emission cargo equipment and other green initiatives.
5 MW
Solar Array Installation
Installed a 5-megawatt solar array at Newark Airport.
70,000 gallons
Fuel Savings
Annual fuel savings achieved through road upgrades in the Port Newark Corridor.
35% reduction in Scope 1 & 2 emissions by 2025; 50% by 2030.
Converted 98% of ship-to-shore and rail-mounted gantry cranes to electric, targeting 100% by 2026.
Light-duty non-emergency vehicle fleet 50% electric by 2025; fully electric by 2028.
Building One retrofit in progress to be fossil-fuel-free by 2025.
Initiated largest solar plus storage system at JFK Airport.
First U.S. airport agency to adopt Paris Climate Agreement commitments.
Electric-truck charging stations and Tier 4/zero-emission material-handling equipment phasing.
Inclusion & Diversity
48% Women
Women in Management
Women hold 48% of Board-appointed management positions within the organization.
5% Target
Annual Female Leadership Goal
An annual target to increase female representation in senior leadership by 5% has been set.
20% Higher Promotion
Mentorship Program Success
Participants in the mentorship program, 60% of whom are women, have a promotion rate 20% higher than average.
98% Pay Gaps Corrected
Gender Pay Equity Review
A comprehensive gender pay equity review in 2024 identified and corrected 98% of pay gaps.