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

Amtrak

  • Washington, DC ; Wilmington, DE ; Philadelphia, PA ; Chicago, IL
  • Hybrid
  • Senior level
  • 6+ yrs experience
  • Data Analytics
  • Visa: not specified
  • $94k–$122k

The role in 30 seconds

This role leads advanced analytics for Safety & Security at Amtrak, transforming complex historical and real-time data into strategic insights that shape risk mitigation, resource deployment, and safety outcomes. The analyst builds scalable dashboards and models, applies AI and statistical techniques, and partners across safety, security, operations, and legal teams to deliver clear, data-driven narratives to leadership.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • Data platform / ML pipeline
  • Internal tooling / back-office systems
  • Enterprise-scale
  • Regulated environment

Workable stretch

  • B2B enterprise platform / workflow software
  • Growth-stage

Harder transition

  • B2C consumer-facing application
  • Embedded systems / hardware-adjacent
  • Startup / greenfield

Industry: Transportation / public sector safety & security. See your personal match score

What they're really screening for

Must-haves

  • PLUS Bachelor's Degree or equivalent combination of education, training and/or relevant experience
  • CORE 6+ years of relevant work experience
  • PLUS Successful completion of a personal police background investigation
  • CORE Strong quantitative and analytical skills, with demonstrated expertise in data sourcing, cleaning, wrangling, analysis, and visualization
  • CORE Proficiency in BI tools such as PowerBI, SAP Business Objects, SSRS, Tableau, or equivalent
  • PLUS Advanced skills in Microsoft Excel, including pivot tables and complex formulas
  • CORE Experience with Python and SQL, or other relevant programming and querying languages
  • PLUS Hands-on experience with Databricks, including building and managing notebooks, data pipelines, and queries in a cloud-based analytics environment
  • PLUS Experience using AI tools (e.g., Microsoft Copilot, generative AI, or machine learning capabilities) in analytical work, with sound judgment on responsible use of sensitive data
  • CORE Excellent verbal and written communication and comprehension skills, including explaining analytical findings to non-technical audiences and interacting with all levels of the organization

Nice-to-haves

  • CORE 8+ years of relevant experience in data analytics, preferably within safety, law enforcement, or transportation sectors
  • PLUS Master's degree in statistics, computer science, data science, or other quantitative field
  • PLUS Experience applying statistical forecasting or predictive modeling techniques to safety, security, or operational data

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • PowerBI
  • Databricks
  • Python
  • SQL
  • SAP Business Objects
  • SSRS
  • Tableau
  • Microsoft Excel
  • Microsoft Copilot
  • generative AI
  • machine learning

Concepts & phrases

  • Lead Data Analyst
  • Safety & Security
  • advanced analysis
  • real-time data
  • safety and security trends
  • proactive risk mitigation
  • scalable dashboards
  • data integrity
  • cross-functional teams
  • data-driven initiatives
  • technical guidance and mentorship
  • quantitative and analytical skills
  • data sourcing
  • predictive modeling
  • operational efficiency

Words that count as the same thing: "PowerBI" ≈ Power BI, Microsoft Power BI · "BI tools" ≈ Business Intelligence tools, Tableau, SAP Business Objects · "predictive modeling" ≈ predictive analytics, statistical modeling, forecasting models · "data wrangling" ≈ data cleaning, data preparation, data munging · "generative AI" ≈ GenAI, LLM tools, Microsoft Copilot

Check my résumé against these keywords

Hiring at Amtrak

Open senior roles RoleStack tracks right now, posted in the last 30 days.

More open roles at Amtrak

Full job description from Amtrak

From Amtrak's posting. View the original

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.

Show full description Show less

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.

Apply now »

Find similar jobs:

View All Jobs at Amtrak,
Technology Jobs in Washington DC,
SAP Jobs in Washington DC,
ERP Jobs in Washington DC,
Database Jobs in Washington DC

FAQ

How much does a Lead Data Analyst (Safety & Security) - 90301903 - DC/Wilmington/Philadelphia/Chicago at Amtrak make?

The posted pay for this role is $94k–$122k a year.

How much experience do you need?

The posting asks for 6+ years in data analytics. It is a senior-level role.

Does Amtrak sponsor visas for this role?

The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.

Is this role remote?

It is a hybrid role: part remote, part in the office.

What tools and technologies does the posting mention?

PowerBI, Databricks, Python, SQL, SAP Business Objects, SSRS, Tableau, Microsoft Excel, Microsoft Copilot, generative AI, machine learning.