Data Analyst, Emerging Talent Intern
Description
Department: Department of Subways, NYCT
Location: 333 West 53rd Street, New York, NY 10019
Position Title: Data Analyst, Emerging Talent Intern
Hourly Rate: $19.00 (Undergraduate)
OVERVIEW OF DEPARTMENT:
The Power Department is responsible for maintaining and managing the electrical and third rail systems that supply traction power to the New York City Transit network. It ensures safe, reliable, and continuous electrical service for train operations across the system. The Electrical oversee substations, cable systems, and maintenance, while the Third Rail focuses on maintaining and upgrading the third rail used to power trains. Together, these divisions handle critical repairs, capital projects, and emergency responses to sustain system reliability
RESPONSIBILITIES:
The Emerging Talent Intern will work on specially assigned projects focused on developing applications, automation processes, and business intelligence tools to help improve departmental operations.
- 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.
PROJECTS:
- Automation Development Project - Hands-on experience in creating applications, automation workflows, and business intelligence dashboards using tools like Power BI, Power Automate, and SharePoint.
- Data Visualization Project - Practical knowledge in analyzing operational data to identify trends, improve efficiency, and support data-driven decision-making.
- SharePoint Optimization Project - Exposure to real-world project planning, coordination, and communication within a large public transit organization, working alongside engineers, analysts, and management teams.
REQUIRED QUALIFICATIONS:
- Proficiency in Microsoft Office Suite is a must.
- The candidate should possess organizational, analytical and communication skills.
- The candidate should be able to work well under pressure and prioritize tasks effectively.
- The candidate should have a keen eye for detail and be able to work independently while being an active team player.
REQUIRED EDUCATION:
- Matriculated in an undergraduate program in good standing with at least 2.5 GPA
- Major(s) Preferred: Information Technology, or related field.
All applicants must be authorized to work in the United States at the time of application. Students’ transcript must be submitted.
Equal Employment Opportunity
MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities. The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.