Fall 2026/Spring 2027 - Data Analytics Intern - 90413629 - Philadelphia

Your success is a train ride away!

As we move America's workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees.

Are you ready to join our team?

Our values of 'Do the Right Thing, Excel Together and Put Customers First' are at the heart of what matters most to us, and our Core Capabilities, 'Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security' are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future.

Job Summary:

The central Project Controls organization is seeking a highly motivated, creative, and analytical student to join our team as a Data Analytics Intern. In this role, the intern will support the development and maintenance of interactive dashboards, reports, and data visualization tools that enable data-driven decision-making across Capital Delivery. Working closely with the Project Controls Data Analytics team, the intern will analyze data, support reporting initiatives, identify opportunities for process improvements, and help implement enhancements through automation and data-driven solutions. This role requires experience with Power BI or other data visualization tools.

Essential Function:

• Assists in developing and maintaining Power BI dashboards, visualizations, and reports to support data-driven decision-making.
• Compiles and validates data from multiple sources to ensure reporting accuracy and consistency.
• Supports the preparation of recurring and ad hoc reports, metrics, and analytical summaries for management and project stakeholders.
• Identifies data trends, anomalies, and opportunities for process improvements through analysis and visualization techniques.
• Assists with the development of automated reporting and data management solutions using Excel, Power BI, SQL, Python, or other analytics tools.
• Participates in team meetings and contributes to data analytics, reporting, and continuous improvement initiatives.

Minimum Qualifications:

• Must be actively pursuing a degree at an accredited educational institution.
• Must be actively pursuing an undergraduate/graduate degree in Engineering (Civil, Industrial, Systems, Mechanical, Electrical), Construction Management, Applied Mathematics, Business Analytics, Data Science, Computer Science, or a related field from an accredited college or university.
• Experience in creating visually appealing and user-friendly dashboards in Power BI or other visualization tools.
• Must have at least 3 years of academic undergraduate studies completed or a junior status at minimum.
• Must have a cumulative GPA of 2.8 or higher.
• Available to work a minimum of 30 hours per week between the days/hours: Monday - Friday, 8am-5pm.

Preferred Qualifications:

• Strong analytic and problem-solving skills.
• Creative out-of-the-box thinking and a keen interest in using data to identify trends.
• Strong written and verbal communication skills.
• Advanced Excel skills, including data modeling, complex automation using macros and VBA, and a strong understanding of Excel functionality and capabilities.
• Experience with cleaning, restructuring, and summarizing data.

PAY TRANSPARENCY:

The hourly range is $18.00 per hour - $35.00 per hour. Pay is based on factors including school year, program of study, etc. In addition, paid internships include Amtrak rail pass privileges as a part of the experience along with one (1) PTO day per academic year.

Requisition ID:166998

Work Arrangement:06-Onsite 4/5 Days Click here for more information about work arrangements at Amtrak.

Relocation Offered:No

Travel Requirements:Up to 25%

You power our progress through your performance.

We want your work at Amtrak to be more than a job. We want your career at Amtrak to be a fulfilling experience where you find challenging work, rewarding opportunities, respect among colleagues, and attractive compensation. Amtrak maintains a culture that values high performance and recognizes individual employee contributions.

Amtrak is committed to a safe workplace free of drugs and alcohol. All Amtrak positions requires a pre-employment background check that includes prior employment verification, a criminal history check and a pre-employment drug screen.

Candidates who test positive for marijuana will be disqualified, regardless of any state or local statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use. Amtraks pre-employment drug testing program is administered in accordance with DOT regulations and applicable law.

In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions.

In accordance with federal law governing security checks of covered individuals for providers of public transportation (Title 6 U.S.C. §1143), Amtrak is required to screen applicants for any permanent or interim disqualifying criminal offenses.

Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience.

Amtrak is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race/color, to include traits historically associated with race, including but not limited to, hair texture and hairstyles such as braids, locks and twists, religion, sex (including pregnancy, childbirth and related conditions, such as lactation), national origin/ethnicity, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.