Lead AnalystThe bipartisan Infrastructure Investment and Jobs Act (IIJA) provides unprecedented levels of investment for intercity passenger rail. Technology will be a strategic differentiator and a key driver of Amtrak’s success.The Lead Analyst will support Digital Technology (DT) Capital Planning (Project Portfolio Management), project management governance, and compliance reporting to ensure successful execution of IIJA funded programs and projects. A successful candidate must have expert level of data and financial analysis skills, excellent communication skills, great attention to details, and a can-do attitude.
Experience to support quality reviews of project status reporting, grants compliance, financial forecasting, and process automation using Microsoft suite of tools, such as Teams, Power BI, and Power Automate is strongly preferred.Key responsibilities include:Manage and execute cost engineering and control activities for large, complex technology projects or portfoliosSupport project status reporting and grants complianceMonitor and track the submission of deliverables by established deadlines; maintain appropriate documentation and artifacts (e.g., crosswalk of grant requirements)Perform portfolio trending analysis, project financial, project status and executive reportingConduct expert level data analysis working with large amount of data sets to quickly extract insightsProvide project management standard, governance, audit, and training supportCollaborate with all levels of stakeholders within DT and with peer organizations such as Finance, Grants, and the Enterprise Project Management OfficeMaintain SharePoint sites, tools, templates, and identify process automation opportunitiesEssential FunctionsCollect, consolidate, and cleanse project performance data from various sourcesAssist in monthly analysis and reporting of cost performance, providing detailed analysis to improve project performance and forecasting and support corporate reporting and grants management.Identify, understand, and remain current on grant requirements, internal policies and procedures, and other regulatory requirementsPerform quantitative analysis to understand project / service performanceDevelop and maintain various systems of records, lists, reports, and presentationsDevelop project management templates, tools, job aids and other knowledgebase documentationsSupport project delivery teams on project stage gating, governance, and other processes to ensure compliance with audit requirementsIdentify continuous process improvement and automation opportunities to increase accuracy and efficiencySupport project capital planning and business case development and prioritizationMay need to run reports from SAP / BPC financial system to facilitate monthly reporting and project spend trackingTranslate business objectives into various reporting views and presentations to facilitate project tracking and monitoringSupport the creation and maintenance of project management best practices, tools, and ways for Amtrak to drive efficiency in order to reduce costs and add value.Minimum QualificationsBA or BS degree in a relevant field5-7 years of experience as a Business Analyst, Market Research Analyst, or in a PMO support role.
Experience with business analysis, business process mapping, project management, and financial reporting preferredMust be an expert user in Excel and comfortable working with large data sets.
Experience with Macro strongly preferredProficiency with Word, PowerPoint, SharePoint, Visio, MS ProjectExperience with Microsoft SharePoint and Teams administration and design a plusExcellent writing skills.