MTA Headquarters is looking to analyze and track inventory trends and performance to support Metro North's Material Management goals and initiatives by assisting in the designing, producing, and publication of reports.
Requirements
- Minimum two years of experience in PeopleSoft and MS Access and/or comparable applications Query building.
- Knowledge of inventory & procurement principles, systems and government procurement regulations
- Knowledge of Microsoft Office Suite and/or comparable applications
- Knowledge of Forecasting Practices, Procedures and systems
- Knowledge of Statistical Analysis techniques and their application to trend analysis
- Familiarity with Power BI, Tableau, and similar tools
- Associate’s Degree in Computer Science, Statistics, Mathematics, or related field.
Responsibilities
- Prepare and distribute various statistical reports on both a scheduled and on demand basis ensuring accurate analysis for replenishment of stock inventory is performed efficiently utilizing historical trends to assist in predicting future demand trends for inventory.
- Develop, design and prepare data to create Key Performance Indicators (KPIs) reporting for the Material Management area providing guidance to inventory investment.
- Gather and disseminate data for the department’s internal forecast to produce quarterly Board reports, providing visibility for budgetary cash flow preparation.
- Manages and directs the analytical computation of all transactional data to assist and support Material Planning in forward forecast efforts. This includes the oversight, creation and modification of hundreds of queries in support of the MM&D department.
- Manages “Gatekeeper” efforts for PeopleSoft Procurement module security ensuring integrity of data and enforcement of standard protocol.
- Has direct management responsibility for the creation and upkeep of Metro-North RR’s Materials Catalog within PeopleSoft which has in excess of 41,000 individual stock keeping units, SKU’s, ensuring standardization.
- Manages the preparation and maintenance of requirements for Capital Programs for the rehabilitation of Fleet assets.
Other
- Superb problem solving, analytical, interpersonal, and administrative skills
- Strong ability to operate effectively in high pressure situations; must be flexible and adapt to change
- Strong ability to exercise a high level of independent judgment and decision making
- Working knowledge of products and materials procurement terms and conditions, private or public sector purchasing (i.e. MTA Agency, NYS, NYC) and governmental regulations related to discipline (FRA, FTA)
- Detail oriented with strong organizational skills
