EAM Analyst, Emerging Talent Intern (Spring)

Metropolitan Transportation Authority (MTA); New York (NY); On-site; USD 26,000 - 29,000; Full time

Job summary

Metropolitan Transportation Authority (MTA) is seeking an EAM Analyst, Emerging Talent Intern for its Department of Subways in New York, onsite only.

Responsibilities include data analysis, creating data transformation scripts using SQL, and assisting with project management to push initiatives forward.

Qualifications require data-related majors with GPA thresholds, strong Microsoft Office skills, and the ability to work under pressure while collaborating with stakeholders.

Qualifications

• Must be enrolled in an undergraduate program in good standing with GPA 2.5 or higher, or graduate program with GPA 2.8+.
• Preferred majors include Data Science, Data Engineer, IT Systems, Statistics, CS, Math.
• Proficiency in Microsoft Office Suite is required.
• Strong organizational, analytical and communication skills.

Responsibilities

• Demonstrate data analysis skills to support DOS assets tracking.
• Create scripts for data transformation and use SQL queries.
• Assist in project management to move initiatives forward.
• Troubleshoot EAM application issues and provide customer service.
• Collaborate with stakeholders to identify EAM solution opportunities.
• Maintain defect identification and production issue resolution processes.
• Document and uphold software implementation standards.
• Make strategic recommendations based on findings.

Skills

Data analysis

SQL

Problem solving

Communication

Organization

Education

Undergraduate GPA 2.5+

Graduate GPA 2.8+

Preferred majors: Data Science, Data Engineer, IT Systems, Statistics, CS, Math

Tools

Microsoft Office

Job description

Description

Department: Department of Subways

Location: 2 Broadway, New York, NY 10004

Position Title: EAM Analyst, Emerging Talent Intern

Hourly Rate: $19.00 (Undergraduate), $21.00 (Graduate)

All internship positions are onsite and require regular, in-person attendance at the designated work location.

OVERVIEW OF DEPARTMENT

The EAM (Enterprise Assets Management) team are responsible for supporting the Department of Subways (DOS) operations by tracking major assets. Interns will be engaged in learning how assets are stored, maintained, repaired and replaced in the vast subway system.

RESPONSIBILITIES

• Data Analysis skills.
• Create software scripts for data transformation and utilize SQL Queries.
• Project Management, manage tasks to move projects and initiatives forward.
• Troubleshooting EAM application, problem-solving and customer service.
• Collaborate with stakeholders to identify opportunities where EAM solutions can support organization needs.
• Maintain a process for identifying defects and troubleshooting production reported issues collectively with the team implement solutions.
• Document and uphold standards for software implementation.
• Make strategic recommendations based on findings.

PROJECTS

• EAM Process Improvement for Track Construction
• Facilities & Station Maintenance EAM Planning & Restructuring and Improvement Project
• Stations Data Quality Analysis Project

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 AND/OR matriculated in a graduate program in good standing with at least 2.8 GPA
• Major(s) Preferred: Data Science, Data Engineer, IT Systems, Statistics, Computer Science, Business Management, Math 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.