Database Administrator MS Access (User Support and Developer), Emerging Talent Intern (Spring)

New York City Transit; United States; On-site; USD 22,000 - 31,000; Full time

Job summary

New York City Transit is seeking an undergraduate Database Administrator Intern to support the Department of Subways at 130 Livingston St, Brooklyn, NY. The role emphasizes hands-on work with MS Excel and MS Access to manage construction data, generate basic reports, and assist with data entry and quality checks in an onsite environment.

You will learn the existing databases, optimize spreadsheets, troubleshoot user issues, and develop new objects in Excel and Access.

Qualifications

• Proficiency in MS Excel and MS Access, with ability to build and optimize spreadsheets and databases.
• Strong report writing and communication skills.
• Organizational and analytical abilities with attention to detail.
• Ability to work under pressure and prioritize tasks independently and in a team.

Responsibilities

• Learn and apply spreadsheet and database skills (Excel and Access) for construction data.
• Learn the existing database and spreadsheets in use.
• Optimize and improve existing databases and spreadsheets.
• Troubleshoot user issues encountered during use.
• Develop new objects in Excel and Access.
• Update various databases and spreadsheets; review data for quality and accuracy.
• Support in preparing and developing reports, graphs and charts for managers.
• Interact with end users; provide help desk support.
• Learn Enterprise Asset Management (EAM SAP-based software).
• Understand how data is collected, managed, and assessed.
• General office duties (data entry, phones, mailroom, etc.).
• Projects: optimize databases/spreadsheets for project management and construction; support user experience improvement and decision-making; present projects to end-users.

Skills

Report writing

Analytical skills

Communication

Organizational skills

Time management

Team player

Detail oriented

Education

Undergraduate GPA 2.5+

CS/Database or related field

Math/Data Science/Accounting/Finance

Tools

MS Excel

MS Access

Job description

Description

Position at New York City Transit

Department: Department of Subways

Location: 130 Livingston St., Brooklyn, NY 11201

Position Title: Database Administrator MS Access, Emerging Talent Intern

Hourly Rate: $19.00 (Undergraduate)

All internship positions are onsite and require regular, in-person attendance at the designated work location, with a minimum of 20hrs per a week.

OVERVIEW OF DEPARTMENT:

The Department is Subways is responsible for the operations and maintenance of the subway infrastructure system with this division 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.

RESPONSIBILITIES:

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

• Learn the existing database and spreadsheets in use

• Optimize and improve existing database and spreadsheets

• Trouble shoot User issues encountered during use

• Develop new objects in Excel and Access

• 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.

• Interact with end Users. Provide help desk support and trouble-shooting support.

• Learn Enterprise Asset Management (EAM) -SAP based software.

• Understand how data is collected, managed, and assessed.

• General office duties (data entry, answering phones, mailroom, copying, etc.).

PROJECTS:

• Optimize and improve multiple databases and spreadsheets used in project management and construction.

• Construction Projects

• Financial Projects

• Asset Condition Projects

• Support user experience improvement and decisiion-making.

• Demonstration and presentation of these projects to end-user

• Verifying and auditing User entries

• 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, precisely in MS Excel and MS Access.
• The candidate should have effective report writing.
• 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: Computer Science (Database), Mathematic, 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.