MS Access Intern: Data & Reporting for Transit Projects

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

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.