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

Washington Metropolitan Area Transit Authority (WMATA); Hyattsville (MD); On-site; USD 21,000 - 30,000; Part time

Job summary

Washington Metropolitan Area Transit Authority (WMATA) is offering a college internship with the Technical Training & Development team. You will support the Maintenance Training group by creating dashboards, cleaning datasets, and developing reusable reporting templates to track compliance and measure performance.

The role emphasizes hands-on experience with Excel, SQL, and Power BI/Tableau to produce visuals that inform executive decisions in a supportive learning environment.

Qualifications

• Enrolled in a college or university pursuing a degree related to analytics or data management.
• Must have completed freshman year and be entering sophomore year; minimum GPA 2.8.
• Ability to work up to thirteen weeks during the summer.
• Proficiency with Excel, SQL, and data visualization tools is expected.

Responsibilities

• Assist in compiling, reviewing and analyzing data for reports.
• Develop dashboards and reusable reporting templates to track compliance and performance.
• Clean and organize datasets to support accurate analytics.
• Create visualizations and presentations for executive decision-making.
• Participate in training sessions and department meetings to gain exposure to transit functions.

Skills

Analytical thinking

Effective communication

Team collaboration

Education

Pursuing degree in data analytics or related field

Tools

Excel

SQL

Power BI

Tableau

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.

Knowledge

• Knowledge of personal computers and other standard office equipment.
• Knowledgeable of computer software, specifically spreadsheets, word processing and databases.

Skills

• Skilled with analyzing numerical data and to prepare reports.

Abilities

• Ability to research methodology.
• Ability to communicate effectively at all levels.
• Ability to establish and to maintain effective working relationships with co‑workers and the public.

Machine, Tools, Equipment, Software, Hardware Required

• Personal computer
• Microsoft Office Suites
• Office equipment

Supervisory Responsibility

Not responsible for supervising others.

Qualifications

Minimum Education

• Graduation from high school or the possession of a high school equivalency certificate. Applicant must be attending an accredited college or university pursuing a degree in a discipline deemed appropriate for the position intern is seeking.
• The intern's major or area of concentration must be aligned with the academic and functional requirements of the position for which the intern's major or area of concentration must be aligned with the academic and functional requirements of the position for which the student had applied.
• Must have completed their freshman year and be entering their sophomore year of college.
• The intern must possess a minimum cumulative 2.8 GPA.
• In cases where the internship is a progressive internship offering the consecutive summer opportunities through graduation, the intern must receive a favorable performance evaluation for the prior summer in order to be considered for each subsequent summer.

Minimum Experience

• N/A

Minimum Certification/Licensure

• N/A

Preferred Qualifications

• N/A

About Us

The Washington Metropolitan Area Transit Authority (WMATA), known as Metro, is the region’s leading public transportation provider. Serving a 2,054-square‑mile jurisdiction, Metro operates six rail lines, 98 stations, 126 bus routes, and Metro Access, a shared‑ride paratransit service. As one of the nation’s busiest transit systems, Metro connects communities, supports economic growth, and provides safe, reliable transportation.

Evaluation Criteria

• Skills and/or behavioral assessment
• Personal interview
• Verification of education and experience (including certifications and licenses)
• Criminal Background Check (a criminal conviction is not an automatic bar to employment)
• Medical examination including a drug and alcohol screening (for safety sensitive positions)
• Review of a current motor vehicle report

Closing

WMATA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or any other status protected by applicable federal law.
This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job descriptions are available upon confirmation of an interview.