(#oPL1yfwT) Summer Intern, Strategic Analysis & Forecasting

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

Job summary

A public educational institution seeks a Summer Intern for Strategic Analysis & Forecasting within their Aviation Department. This role involves developing data models in Power BI, analyzing aviation data, and creating actionable insights to support facility planning and revenue projections. Ideal candidates are enrolled in a relevant degree program and have strong analytical skills. The internship runs for approximately 12 weeks and allows for limited remote work. Competitive hourly rate from $18.07 to $30.31 depending on qualifications.

Qualifications

• Strong analytical skills and interest in aviation or transportation.
• Capable of working with both qualitative and quantitative data.
• Motivated to learn about data collection and management.

Responsibilities

• Develop data models and dashboards in Power BI.
• Analyze aviation datasets and derive insights.
• Conduct aviation industry research and prepare forecasts.

Skills

Data analysis

Data visualization

Experience with Power BI

Qualitative and quantitative data handling

Education

Enrollment in college or university

Major in related field (Transportation Planning, etc.)

Tools

Microsoft Power BI

Job description

You are viewing a preview of this job. Log in or register to view more details about this job.

(#oPL1yfwT) Summer Intern, Strategic Analysis & Forecasting

The Aviation Department manages five airports at The Port Authority of New York and New Jersey, one of the busiest airport systems in the country. Within the Aviation Department, the Strategic Analysis & Forecasting team sits within the Aviation Strategy unit and oversees Airline Activity Data Collection & Reporting, Airline Activity Forecasting, and Industry Analysis. In this internship, the candidate will be able to apply their data analysis and visualization skills to the aviation industry and support the team’s mission of providing agency and department staff with the analytical tools they need for facility planning, revenue projection, and strategic decision making. This is a great opportunity for the candidate to develop their analytical skills while simultaneously learning about the Aviation business.

Responsibilities

• Develop data models in Power BI to support various data analysis and visualization tasks
• Create dashboards in Power BI to replace PDF reporting for the Unit's Annual Traffic Report and for other internal analytical use cases
• Design surveys for internal and external users to understand usage of current dashboards, reports, and analyses
• Use data analysis and visualization tools to analyze and derive insights from aviation datasets
• Help conduct aviation industry research, data analyses, and prepare activity forecasts

Minimum Qualifications

• Enrollment at a college or university at the time of the internship
• Major in Transportation Planning, Urban Planning, Engineering, Statistics, Information Systems, Data Analytics or related discipline

Desired Qualifications

• Experience with Microsoft Power BI or another related data visualization or dashboard tool
• Experience working with both qualitative and quantitative data
• An interest in data collection, management, and visualization
• Interest in public service, transportation, and/or aviation
• 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