> Markdown version of [/jobs/ext/2229477-lead-data-analyst-forecasting-90402617-washington-philadelphia](https://www.wearedevelopers.com/jobs/ext/2229477-lead-data-analyst-forecasting-90402617-washington-philadelphia). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Analyst - Forecasting - 90402617 - Washington/Philadelphia

- **Company:** Amtrak
- **Location:** Washington, DC, United States
- **Experience:** Expert
- **Salary:** $94,300.0 - $122,256.0
- **Contract:** Contract
- **Skills:** Data Analysis, Data Governance, Power BI, Standard Sql, SQL Databases, Tableau (Software), Statistics Packages
- **Published:** August 25, 2026
- **Apply:** https://careers.amtrak.com/talentcommunity/apply/1422563900/?locale=en_US

## About the Role

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

## Description

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


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Hacking Your Vacation: Using Data for Fun](https://www.wearedevelopers.com/videos/585-hacking-your-vacation-using-data-for-fun)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)
- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)