Lead Data Analyst - Forecasting - 90402617 - Washington/Philadelphia

National Railroad Passenger Corp
  • Washington, DC
  • $94,300–$122,256 Per Hour
4 days ago

Job Description

Your success is a train ride away!

As we move America's workforce toward the future, Amtrak connects businesses and communities across the country. 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 due to our employees.

Are you ready to join our team?

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 out of Washington DC or Philadelphia, PA.

Job Summary

The Lead Forecasting Analyst transforms complex data into actionable insights that inform business decisions and improve operational performance. As a subject matter expert, this role leads demand forecasting projects, partners with cross-functional teams, and develops scalable reporting tools. The analyst blends internal and external data sources to identify trends, evaluate strategic options, and support decision-making across the organization. This role operates with limited oversight and may coach junior analysts.

Duties include supporting the maintenance and application of travel demand forecasting models and tools along with business analytics pertaining to demand, addressing Amtrak ridership, ticket revenue, passenger miles, service levels, and high-level pricing changes as well as competing modes of travel.

Essential Functions

  • Lead the development of ridership and ticket revenue projections and market demand information to guide operating decisions and capital investments, utilizing Amtrak's econometric forecasting analytics / models
  • Develop dashboards, reports, and visualizations using BI tools (e.g., Tableau, Power BI, SQL).
  • Integrate and analyze internal and external data sources to assess market, customer, and/or operational trends.
  • Collaborate with business partners to model outcomes of proposed strategies and provide data-driven recommendations.
  • Contribute to data governance, may mentor junior analysts, and promote analytical best practices.
  • Collaborate closely with team members and other Amtrak groups
  • Other duties as assigned

Minimum Qualifications

  • Bachelor's Degree in engineering, data science, economics, statistics or a related field or equivalent combination of education, training and/or relevant experience.
  • Plus 6 years of relevant work experience.

Preferred Qualifications

  • Master's Degree or equivalent combination of education, training and/or relevant experience.
  • Plus 8 years of relevant work experience.

Knowledge, Skills, and Abilities

  • Data Analysis Expertise: Proficient in SQL, Tableau, and statistical tools; strong understanding of BI frameworks and data modeling.
  • Business Acumen: Ability to connect data insights to business strategy and operational goals.
  • Communication: Skilled in presenting complex findings to non-technical audiences and influencing stakeholders.
  • Project Leadership: Capable of managing analysis projects independently and coordinating across teams.
  • Collaboration & Mentorship: Works effectively with cross-functional teams and may support development of junior staff.

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:167060

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

Numbers & Facts

LocationWashington, DC
Salary$94,300–$122,256 Per Hour

Skills

  • Analysis Skillsunmatched
  • Business Analysisunmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Business Modelunmatched
  • Business Operationsunmatched
  • Business Skillsunmatched
  • Business Strategyunmatched
  • Candidate Screeningunmatched
  • Candidate Testingunmatched
  • Coachingunmatched
  • Code of Federal Regulationsunmatched
  • Communication Skillsunmatched
  • Cross-Functionalunmatched
  • Customer Relationsunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Scienceunmatched
  • Decision Supportunmatched
  • Demand Forecasting/Planningunmatched
  • Economicsunmatched
  • Federal Laws and Regulationsunmatched
  • Forecastingunmatched
  • Investment Capitalunmatched
  • Leadershipunmatched
  • Legalunmatched
  • Market Analysisunmatched
  • Market Trend Analysisunmatched
  • Mentoringunmatched
  • Operational Improvementunmatched
  • Options Analysisunmatched
  • Performance Managementunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Pricingunmatched
  • Process Improvementunmatched
  • Project/Program Coordinationunmatched
  • Project/Program Managementunmatched
  • Public Transportunmatched
  • Regulationsunmatched
  • Reporting Dashboardsunmatched
  • Reporting Skillsunmatched
  • Revenue Forecastingunmatched
  • SQL (Structured Query Language)unmatched
  • Safety/Work Safetyunmatched
  • Scalable System Developmentunmatched
  • Staff Developmentunmatched
  • Staff Requirementsunmatched
  • State Laws and Regulationsunmatched
  • Statisticsunmatched
  • Tableauunmatched
  • Test Programunmatched
  • Trend Analysisunmatched
  • Willing to Travelunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder