EAM Analyst Intern: Data, SQL & Asset Optimization

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

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.