Lead Data Analyst - 90336003 (Remote Option)

Date: Jun 23, 2022

Location: N/A, US

Company: Amtrak

Your success is a train ride away.

Amtrak connects businesses and communities across the country and we move America’s workforce toward the future. 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 the result of our employees.

Are you ready to join our team?

The Lead Business Analyst role will be a key contributor on a team introducing a data driven approach towards managing performance. This approach will have 4 primary areas of focus: Leads creation/maintenance of our analytical toolkits, creation of business processes to monitor performance, leads matrix initiatives to address performance opportunities and leads ad-hoc analysis. Initially the role will be primarily focused on building our analytical foundation with a focus on data aggregation, analytic tools selection and creating reports focused on data sense making that heavily utilize data visualization. With the foundation in place, the role will pivot towards developing reporting and interactive data for our state partners and internal stakeholders. While this role will have a significant design aspect – the function will also be responsible for the coding and maintenance of their work product and will be the go-to resource for understanding the underlying data.




  • Primary contributor to the creation of the departmental data foundation, this will require becoming an expert on multiple datasets across ops, commercial and finance
  • Develop/maintain repository of self-service performance reports for a variety of stakeholders
  • Go to person for team’s more complex data needs
  • Create tools that can be used to identify performance improvement opportunities
  • Participate in performance management sessions to seed ideas for tool creation – then create it
  • Conduct ad-hoc analysis as needed – some of which may address business opp. vs. performance opp.
  • Working closely with the finance team, create financial models that allow stakeholder what-if analysis
  • Develop scalable tools and techniques to evaluate data and report results.
  • Identify opportunities and hypotheses for problem solving
  • Perform deep-dive analysis to supplement topline results and create a decision support framework.
  • Create visualizations to communicate business results for stakeholder review.
  • Conduct data validation and integration of data from internal Amtrak data sources as well as third-party sources.
  • Meet with stakeholders to formulate objectives and ensure tracking is in place to support these objectives.
  • Work with IT to design, enhance, and troubleshoot the data and applications used by stakeholders.




  • BA/BS in business, computer science or quantitative field
  • Demonstrated experience SQL
  • Demonstrated experience Python or R
  • Demonstrated advanced experience in Excel
  • Demonstrated experience in an analytical role and creating analytical models
  • Demonstrated experience solving business problems
  • Demonstrated experience with data visualization
  • Strong analytical and commercial skills are the priority.   
  • Strong data manipulation skills – expert level knowledge in excel and experience writing SQL. Experience with Tableau or other visualization tools a plus
  • Coding experience in a data analytics environment with Python or R
  • Technical fluency and an understanding of database structures
  • Takes ownership of opportunities and creates solutions
  • Effective communicator with the ability to distill complexity into plain language
  • Experience creating an approach / framework for addressing complex problems
  • Strong analytical skill set to identify root causes
  • Highly skilled communicator, that will utilize a variety of written and verbal mediums
  • Highly skilled interpersonal skills – will work across internal and external stakeholders who have expertise in all aspects of passenger rail
  • Highly skilled at organizing projects
  • Highly outcome oriented
  • Experience with query and reporting tools such as Business Objects




  • BA/BS in business, computer science or quantitative field
  • Masters in business, computer science or quantitative field
  • 3+ years work experience
  • 2+ years experience SQL
  • 2+ years experience Python or R
  • 2+ years advanced experience in Excel
  • 2+ years experience in an analytical role
  • 2+ years experience creating analytical models
  • 2+ years experience solving business problems
  • 2+ years experience with data visualization
  • Working knowledge of Business Objects, Tableau, and Salesforce’s data models as well as Enterprise Data Warehouses
  • Experience in statistical analysis 
  • Experience in data mining 
  • Relevant work experience in the transportation industry



  • Must have excellent oral and written communication skills.

Requisition ID:107981
Posting Location(s):N/A
Job Family/Function:Information Technology 
Relocation Offered:Yes 
Travel Requirements:Up to 25% 

Amtrak employees power our progress through their performance.

We want your work at Amtrak to be more than a job – we want it to be a fulfilling experience where you find challenging and rewarding opportunities, respect among colleagues, competitive pay, benefits that protect you and your family and a high performance culture that recognizes and values your contributions and helps you reach your career goals.

All positions require pre-employment background check verification, a pre-employment drug screen and proof of full vaccination against COVID -19. Amtrak is committed to a safe workplace free of drugs and alcohol and performs pre-employment substance abuse testing. Marijuana, notwithstanding any statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use.  Candidates who engage in the usage of marijuana will not be qualified for hire.   Successful applicants for employment with Amtrak must be fully vaccinated against COVID-19 by the date of hire as a condition of employment, subject to requests for accommodation.  Fully vaccinated means 14 days have elapsed since receiving the second dose of the Pfizer or Moderna vaccine or 14 days since receiving the Johnson & Johnson vaccine.

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.

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.

POSTING NOTES: Information Technology || Corporate Jobs