Metro College Intern - (TTDV) Technical Training and Development - Analytics Dashboard Intern

WMATA; Washington (District of Columbia); On-site; USD 25,000 - 39,000; Part time

Job summary

WMATA is seeking a college intern for the Technical Training & Development team to support the Maintenance Training group. You will develop dashboards, clean datasets, and create reusable reporting templates to track compliance and measure performance.

Proficiency in Excel, SQL, and BI tools will help inform executive decisions. The internship provides hands-on transit industry work experience across departments and is designed for summer employment up to 13 weeks, with supervision by a senior

Qualifications

• Current enrollment in a college or graduate program.
• Interest in data analytics and reporting.
• Commit to a summer internship up to 13 weeks.

Responsibilities

• Compile, review and analyze data for reports.
• Create dashboards and visual representations of data.
• Assist in preparing management and operations reports.
• Support trainings and meetings as assigned.

Skills

Excel

SQL

Power BI

Tableau

Data visualization

Education

Currently pursuing bachelor’s degree

Job description

Marketing Statement

Join our forward-thinking Technical Training & Development team! We're seeking a detail-oriented college intern. In this role, you’ll support our Maintenance Training team by developing dashboards, cleaning datasets, and creating reusable reporting templates. Your work will help track compliance, measure performance, and provide clear visuals that inform executive decision‑making. If you're eager to apply your technical skills in Excel, SQL, or Power BI/Tableau to real‑world challenges, this is a fantastic opportunity to grow your analytics toolkit in a supportive learning environment.

Job Description

This is an introductory, preparatory and training opportunity for college and graduate students designed to provide hands‑on and practical transit industry work experience. Areas include but are not limited to: Bus and/or Rail Operations, Safety/Emergency Management, Engineering, Police, Information Technology, City/Urban Planning and General business functions. The assignments are on a temporary basis not to exceed thirteen (13) weeks of summer employment. Student interns may rotate to various departments based on their major in college/university and/or the respective departmental assignment. The student intern is supervised by an appropriate Executive or designee.

Principal Job Duties

• Duties will vary dependent on the assigned department. General duties may include activities in which the student intern:
• Compiles, reviews and analyzes data. Operates a personal computer to verify, input and correct data required for producing reports.
• Researches data for and assists in the preparation of management, operations, technical and administrative reports. Utilizes management memoranda, fiscal and operations reports and data to complete assignments.
• Produces tangible work product specific to the assigned department to include presentations, reports, correspondence, graphic representation of data and/or project plans.
• Reviews reports to identify problems based upon standard criteria and guidance from supervisors; recommends solutions as instructed.
• Participates in training sessions related to various functions performed by department to which assigned; attends appropriate Authority, departmental and office meetings, etc., in order to gain exposure to transit functions.
• Participates in and/or leads departmental meetings, working sessions, etc.

Other Duties

• Maintains and promotes awareness and accountability with safety policies and procedures while performing job functions. Promotes a positive safety culture and encourages reporting of safety concerns consistent with our Agency Safety Plan, other regulatory requirements within the Safety Management System and just culture principles.

The functions listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision.