About the role#
This internship focuses on the VENDEVAL workflow within the Procurement department. You will help improve data accuracy, reporting, and system integration for vendor performance evaluations. This is a paid, on-site role based in New York City for the Winter 2027 term.
What you'll do#
- Contact project managers to collect outstanding VENDEVAL evaluations from 2022 to 2024.
- Standardize data across Access, Excel, and Archer to remove duplicates and fix formatting.
- Build Power Automate flows to process data, send notifications, and track overdue evaluations.
- Create weekly analytic dashboards to show evaluation status and progress.
- Organize digital files and build structured filing systems.
- Test reporting integrity, verify data accuracy, and troubleshoot automation functions.
- Maintain Access databases, run SQL queries, and support reporting modules.
- Design workflow algorithms to route evaluations based on status and contract year.
What you'll need#
- Current enrollment in an undergraduate program with at least a 2.5 GPA.
- Majors in Computer Science, Business Administration, or related fields.
- Proficiency in Microsoft Office Suite and Adobe Acrobat.
- Strong knowledge of Power BI, Power Automate, and Microsoft Access.
- Familiarity with SQL, relational databases, and data cleanup.
- Ability to work independently and as part of a team.
- Strong organizational, analytical, and communication skills.
- Comfort coordinating with project managers and handling follow-ups.
- Ability to manage tasks under pressure and maintain a high level of detail.
Location & details#
- Location: New York, New York.
- Work modality: On-site.
- Term: Winter 2027.
- Commitment: Minimum 20 hours per week.
About Metropolitan Transportation Authority
The Metropolitan Transportation Authority operates a large transit network serving 15.3 million people across New York City, Long Island, southeastern New York State, and Connecticut. It consists of six agencies including subway, bus, and commuter rail systems alongside bridge and tunnel operations. The organization manages the largest bus fleet in the country and provides approximately 2.6 billion trips annually. It is a government agency based in New York City with over 21,000 employees.
How to get in at Metropolitan Transportation Authority
Applying early for a role at the Metropolitan Transportation Authority gives you a distinct advantage before the applicant pool becomes unmanageable. Intern Insider sends an instant alert the moment a role matching your target is published anywhere, so you apply among the first and ensure your materials are seen before the pile grows. Reaching out to the right people often yields better results than submitting to a general queue. Intern Insider surfaces the recruiters behind the company roles so you can reach out directly to ask about the position or a referral, which materially improves your response rates.
