Lead Equipment Data Analyst - 90371568 - Wilmington

Date: Apr 3, 2024

Location: Wilmington, DE, US, 19802

Company: Amtrak

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.


The Lead Equipment/Rolling Stock Analyst inputs and analyzes availability and reliability data related to equipment and Rolling Stock. This position generates equipment reports on a recurring basis in accordance with IMCS processes and will provide additional reporting as needed. The position will utilize, MAXIMO, Tableau, and other available programs to document equipment maintenance and repair history. In addition, the Lead  Equipment/Rolling Stock Analyst will work with IMCS managers daily to ensure equipment failures, repairs, and inspections are documented. The Lead Equipment/Rolling Stock Analyst will frequently interact with staff, provide reports and updates on fleet status.  



  • Develop, maintain, and publish daily reports identifying unusual occurrences, daily accidents/incidents, equipment status and failure, and material requests. 
  • Develop, maintain, and publish RWE/Freight Services monthly report identifying equipment failure summary, equipment maintenance, and repair history (for the month), completed FRA accident/incident reports.  
  • Monitor, maintain, and produce reports for LCCAS (Limits Collision Compliance System), Samsara GPS database, for Annual One-Time Audit requests and Compliance. 
  • Extract data using special tools and software, respond to data-related queries, set up processes to make data more efficient, analyze and interpret trends from the data, and report trends to add business value and drive continuous improvement. 
  • Coordinate communications and dissemination of reporting data and tracking to all stakeholders.



  • Bachelor of Science Degree in Business Administration, Construction Management, related field or equivalent combination of education, training, and work experience.
  • Demonstrated experience in statistical analysis, trend analysis and with on-time performance reporting and customer service feedback reporting 
  • Demonstrated experience working with multiple data sources and the consolidation of information into one reporting environment. 
  • Experience working with Amtrak’s MAXIMO, ARROW, Tableau, or other comparable industry reporting systems. 
  • Several years of experience working in the Engineering Mechanical, Transportation, or Planning departments or a related operations field.
  • Demonstrated skills using PC-based spreadsheets (Microsoft Excel, Access), Microsoft Word, and PowerPoint. 
  • Working knowledge of EAM systems including Maximo, ARROW,  or others. 
  • Excellent written and verbal communication skills. 
  • Must be able to interface with all levels of employees and both external and internal customers.  
  • Demonstrated experience in all facets of Roadway Equipment inspection, maintenance, and construction, as well as working knowledge of other crafts.  
  • Must be able to effectively supervise in a demanding environment with frequently changing priorities and high volume of Purchase Requisitions. 
  • Strong decision making and critical thinking skills



  • Master of Science Degree in Business Administration, Construction Management, or related field with a minimum of 6-9 years’ experience in purchase or materials planning or related field. 
  • In lieu of education, a minimum of 12 years of relevant work experience, or equivalent combination of education, training, and work experience. 
  • Excellent analytical skills, including use of statistical analysis techniques. 
  • Demonstrated ability to effectively coordinate with the IMCS Roadway Equipment and Freight Services team, and other departments to gather and verify the accuracy of data.  



  • Combination of office and field environment working in all weather conditions. 
  • Constantly or frequently uses a computer keyboard, monitor, and mouse to perform a variety of tasks. 
  • Constantly or frequently sits, stands, or walks; may lift, carry, push, or pull objects of various weights; may reach, kneel, crouch, bend, or twist to perform administrative tasks (e.g., filing, retrieving materials from desks and bookcases, moving around an office setting). 
  • Travel:  25%. 



Must have excellent oral and written communication skills.


The salary/hourly range is $94,300-$122,256. Pay is based on several factors including but not limited to education, work experience, certifications, etc. Depending on an employee’s assigned worksite or location, Amtrak may consider a geo-pay differential to be applied to the employee’s base salary. Amtrak may offer additional incentive and pay programs to recognize and reward our employees, including a short-term incentive bonus based upon factors such as individual and company performance that is commensurate with the level of the position and/or long-term incentive plan compensation. In addition to your salary, Amtrak offers a comprehensive benefit package that includes health, dental, and vision plans; health savings accounts; wellness programs; flexible spending accounts; 401K retirement plan with employer match; life insurance; short and long term disability insurance; paid time off; back-up care; adoption assistance; surrogacy assistance; reimbursement of education expenses; Public Service Loan Forgiveness eligibility; Railroad Retirement sickness and retirement benefits; and rail pass privileges. Learn more about our benefits offerings here.

Requisition ID:160785
Posting Location(s):Delaware
Job Family/Function:Research & Strategy 
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. Amtrak's 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 EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, 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.