Lead Data Analyst (Safety & Security) - 90301903 - DC/Wilmington/Philadelphia/Chicago

As we move America’s workforce toward the future, our goal is to connect businesses and communities across the country. The safety of our passengers, our more than 20,000 colleagues, the public and our operating environment is our priority, and the success of our railroad is due to your efforts

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.

This position can be based in Washington DC; Wilmington, DE; Philadelphia, PA; or Chicago, IL.

Job Summary

At Amtrak, safety is more than a priority; it’s a commitment. As Lead Data Analyst for Safety & Security, you will transform complex data into strategic insights that directly shape decisions impacting millions of passengers and employees. By partnering across safety, security, and operational teams, you’ll lead advanced analytics that drive risk mitigation, optimize resource deployment, and enhance safety outcomes nationwide. Your work will empower leadership with clear, data-driven narratives and foster a culture of analytical excellence throughout the organization.

Essential Functions

- Lead advanced analysis of historical and real-time data to identify safety and security trends, forecast emerging risks, and inform strategic decision-making, long-term planning, and proactive risk mitigation

- Develop and maintain scalable dashboards and models using tools like PowerBI, Databricks, Python, and SQL

- Leverage AI tools and continuously enhance data processes and methodologies to automate workflows, accelerate safety and security analysis, and improve operational efficiency and the quality of insights delivered to stakeholders

- Ensure data integrity, compliance, and ethical use of sensitive safety and security information

- Collaborate with and build trusted relationships across cross-functional teams, including, but not limited to, law enforcement, safety, operations, legal, and executive leadership, as well as external partners, to align analytics with organizational goals and support data-driven initiatives

- Translate complex technical findings into clear, actionable insights for non-technical stakeholders

- Provide technical guidance and mentorship to analysts, promoting consistent analytical standards across the team

Minimum Qualifications

- Bachelor’s Degree or equivalent combination of education, training and/or relevant experience.

- Plus 6 years of relevant work experience.

- Successful completion of a personal police background investigation.

Preferred Qualifications

- 8 plus years of relevant experience in data analytics, preferably within safety, law enforcement, or transportation sectors

- Master’s degree in statistics, computer science, data science, or other quantitative field.

- Experience applying statistical forecasting or predictive modeling techniques to safety, security, or operational data.

Knowledge, Skills, and Abilities

- Strong quantitative and analytical skills, with demonstrated expertise in data sourcing, cleaning, wrangling, analysis, and visualization to solve problems efficiently

- Proficiency in BI tools such as PowerBI, SAP Business Objects, SSRS, Tableau, or equivalent

- Advanced skills in Microsoft Excel, including pivot tables and complex formulas

- Experience with Python and SQL, or other relevant programming and querying languages.

- Hands-on experience with Databricks, including building and managing notebooks, data pipelines, and queries in a cloud-based analytics environment

- Experience using AI tools (e.g., Microsoft Copilot, generative AI, or machine learning capabilities) in analytical work, with sound judgment on the responsible use of sensitive data

- Excellent verbal and written communication and comprehension skills, including expert capability to explain analytical findings in clear terms to non-technical audiences and to interact effectively with employees at all levels of the organization

- Critical thinker with excellent decision-making, planning, and prioritization skills who can contribute to challenging assignments and maintain calmness under pressure in a fast-paced environment

The salary/hourly range is $94,300.00 – $122,256.00. 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.

Health and Wellbeing
Financial and Retirement
Work and Family Life Support

Health, Dental, and Vision Insurance
401K with Employer Match
Generous Paid Time Off

Wellness Programs
Railroad Retirement Benefits
Paid Caregiving Days and Backup Care

Health Savings Account
Public Service Student Loan Forgiveness
Fertility and Family Building Benefits

No-cost Personal Health Advocate
Student Loan Assistance
Adoption and Surrogacy Assistance

Medical Plan Opt-out Credit
Tuition and Education Reimbursement
Paid Family Leave

Life Insurance
Rail Pass Privileges

Short- and Long-term Disability Insurance
Employee Assistance Program

No-cost Financial Advisor Sessions
Commuter and Flexible Spending Accounts

Learn more about our benefits offerings here.

Requisition ID: 167582

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. 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 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.