Metropolitan Transportation Authority

Description

Position at MTA Headquarters

Department: MTAHQ - Strategic Initiatives

Location: 2 Broadway, New York, NY 10004

Position Title: Data Science - Service Performance, Emerging Talent Intern

Hourly Rate: $22.00 (Post-Graduate)

OVERVIEW OF DEPARTMENT:

The MTA Data and Analytics Team builds modern data infrastructure, owns the product experience of analytics within the MTA, manages our institution’s Open Data Program, and tackles the agency’s biggest data-driven challenges.

RESPONSIBILITIES:

• Write code to clean, combine, and transform data generated from business operations.
• Design and document algorithmic processes to carry out data transformations.
• Incorporate quality checks in data processes to ensure sustainable accuracy.
• Build Apache Airflow pipelines to deploy data processes as long-term, maintainable data pipelines.
• Update existing data processes to manage input changes, address new business priorities, and improve maintainability.
• Monitor the health of existing data pipelines and help fix them if breakdowns occur.
• Assist in data analyses to answer questions from MTA leadership.
• Assist in the creation of presentation documents (e.g., PowerPoints) for presentation of data findings and products to MTA leadership and other MTA groups.

PROJECTS:

• Migration of legacy data pipelines related to subway and bus performance to Apache Airflow and Python.
• Assist in creation of new pipelines for calculating subway and bus ridership patterns, and subway and bus performance.
• Assist in creation of new pipelines for calculating key MTA-wide datasets on materiel procurement.

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.
• Strong data analytic skills, understanding of analytical methods (e.g., probability and statistics, algorithm design)
• Strong experience in Python or SQL coding.
• Knowledge of and preferably some experience in data engineering. Experience with Apache Airflow especially valuable.
• Familiarity with transit/transportation systems and the MTA organization and functions can be helpful but is not necessary and can be learned as needed.

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: Preferred, but not required: Computer Science, Data Science, Transportation, Urban Science and Informatics, Economics, Statistics, 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.