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 ar