(#obC2yfw7) Summer Intern, E-ZPass Data Analytics

Austin Community College; New York (NY); On-site; USD 24,893 - 41,755; Full time

Job summary

An educational institution in New York is offering a Summer Intern position in E-ZPass Data Analytics. This intern will engage in data analysis, create Power BI visuals, and automate workflows using Microsoft tools. Candidates must be enrolled in relevant college programs and have familiarity with SQL and analytical skills. This full-time internship allows for remote work one day a week. Applications open for a 12-week term starting May 28, 2026.

Qualifications

• Enrollment at a college or university required.
• Major in relevant field such as Business Administration or Data Science.
• Beginner to intermediate SQL skills preferred.

Responsibilities

• Conduct data analysis using Excel and Oracle SQL.
• Create visuals using Power BI based on stakeholder requirements.
• Automate workflows with Microsoft Power Automate or Python.

Skills

SQL skills

Microsoft Office proficiency

Analytical skills

Communication skills

Education

Enrollment at a college or university

Major in Business Administration, Computer Sciences, Information Systems, Data Science, Operations Research

Tools

Excel

Oracle SQL

Power BI

Microsoft Power Automate

Job description

Summer Intern, E-ZPass Data Analytics

E-ZPass Customer Service is looking for a Data Analyst intern to join their team! The E-ZPass Customer Service team works closely with customers and non-revenue account holders who use Port Authority bridges and tunnels. Our team’s mission is to ensure that customers have a positive experience when contacting us. The team works to successfully resolve any outstanding issues that may occur with E-ZPass accounts and Toll Bills.

Responsibilities

• Complete ad-hoc data analysis tasks ranging from: gathering, cleaning, and validating data outputs using Excel and Oracle SQL.
• Create Power BI visuals after gathering stakeholders’ requirements.
• Maintain and improve existing Microsoft Power Automate workflows.
• Automate workflows using Microsoft Power Automate or python.
• Maintain and improve existing team’s financial model
• Create various new data collection processes

Minimum Qualifications

• Enrollment at a college or university at the time of the internship
• Major in Business Administration, Computer Sciences, Information Systems, Data Science, Operations Research, or related field.
• Beginner to intermediate SQL skills

Desired Qualifications

• Proficient in technology and basic Microsoft Office platforms
• Working knowledge of databases
• Some knowledge of Microsoft Power Automate and Powe Apps
• Excellent analytical and research skills
• Familiarity with metrics and KPIs is a plus
• Excellent written and oral communication skills
• The start date will be Thursday, May 28, 2026
• The internship will last approximately 12 weeks, ending on Friday, August 21, 2026
• This is a full-time internship (5 days per week at 7.25 hours per day)
• 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.

Selection Process

• Only applicants under consideration will be contacted
• If selected to move forward, the hiring team will reach out directly to schedule 1-2 interviews
• Different internships will have different timelines for interviews
• The hourly rate range is $18.07 to $30.31 (the exact rate will be determined by internship type and rising school year)
• Ability to opt in to the New York State and Local Retirement System