Database Administration, Emerging Talent Intern

Position at New York City Transit

Department: NYCT - Subways

Location: 130 Livingston, Brooklyn, NY

Position Title: Database Administration, Emerging Talent Intern

Hourly Rate: $19.00 (Undergraduate)

OVERVIEW OF DEPARTMENT:

The Department is Subways is responsible for the operations and maintenance of the subway infrastructure system. This Division is responsible for Construction Projects in that system with given budget and schedule. The information reported and managed is focused primarily on construction: time management, job progress, construction activities, employee assignments, and schedule. Assignment will help managers improve operations.

RESPONSIBILITIES:

• Learn and apply spreadsheet (MS Excel) and database (MS Access) skills for use in construction. Support in the following areas:

1. Learn the existing database and spreadsheets in use

2. optimize and improve existing database and spreadsheets

3. trouble shoot User issues encountered during use

4. develop new objects in Excel and Access

• Understand how data is collected, managed, and assessed.
• Updating various databases and spreadsheets. Review and assess data for quality and accuracy
• Support in preparing and developing reports, graphs and charts and present your work to managers
• Learn basics in Transit operations and construction
• Interact with end Users. Provide help desk support and trouble-shooting support
• Opportunity to learn Enterprise Asset Management (EAM) -SAP based software.
• General office duties (data entry, answering phones, mailroom, copying, etc.)

PROJECTS:

As assigned, the intern may contribute to the following projects:

• • Assigned multiple databases and spreadsheets used in project management and construction.

1. Construction Projects

2. Financial Projects

3. Asset Condition Projects

• Interns will be support multiple projects in improving User experience and decision-making.

1. demonstration and presentation of these projects to end-user.

2. verifying and auditing User entries

3. Support in handling trouble-calls

• support in developing new spreadsheets and databases as requested by stakeholder

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.
• Intermediate knowledge in MS Excel and MS Access

REQUIRED EDUCATION:

• Matriculated in an undergraduate program in good standing with at least 2.5 GPA
• Major(s) Preferred: Computer Science (Database), Mathematics, Data Science, Accounting, Finance, 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.