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 keywordsHiring at Amtrak
Open senior roles RoleStack tracks right now, posted in the last 30 days.
More open roles at Amtrak
- Sr Project Mgr (Capital Delivery) - 90373327 - Philadelphia $94k–$122k
- Principal Project Mgr - Alternate Delivery Methods- 90360099 - Washington $113k–$147k
- Principal Technologist - 90335753 - Remote $113k–$147k
- Sr Engineer - Design Review - 90417335 - Philadelphia $104k–$134k
- Principal Software Engineer (Java) - Washington DC, Philly, Wilmington, Chicago $125k–$161k
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.