Data Analyst, Emerging Talent Intern (Fall)

Metropolitan Transportation Authority • Brooklyn, NY

7d • Onsite

About The Position

This internship position is with the New York City Transit Department, specifically within the Power Department, which is responsible for maintaining and managing the electrical and third rail systems that supply traction power to the New York City Transit network. The intern will support the MTA's mission to improve operational efficiency, safety, and service reliability by developing automation tools, applications, and business intelligence solutions. This work aims to modernize workflows, reduce manual processes, and enhance data visibility across the Power Department. The internship is located at 130 Livingston Street, Brooklyn, 11201, and all positions are onsite requiring regular, in-person attendance.

Requirements

• Proficiency in Microsoft Office Suite is a must.
• Organizational, analytical and communication skills.
• Ability to work well under pressure and prioritize tasks effectively.
• Keen eye for detail.
• Ability to work independently while being an active team player.
• Matriculated in an undergraduate program in good standing with at least 2.5 GPA.
• Authorized to work in the United States at the time of application.

Nice To Haves

• Major(s) Preferred: Information Technology, or related field.

Responsibilities

• Perform administrative tasks assigned by management to support daily departmental operations.
• Assist in creating and updating Standard Operating Procedures and departmental manuals as directed.
• Develop automation processes using Microsoft Power Automate to streamline workflows and improve efficiency.
• Design and maintain interactive dashboards in Power BI to visualize key performance metrics and operational data.
• Assist in creating and managing database applications to support departmental data needs.
• Analyze, clean, and format data in Excel or other applications to ensure data accuracy and consistency.
• Troubleshoot and resolve data-related issues in coordination with management and system operators.
• Assist in record retention and storage of important departmental documents and take notes during department meetings for documentation purposes.

What This Job Offers

• Career Level: Intern
• Education Level: Associate degree