Estimated Length: 12 months  Avg. 35 hours per week based on SME availability for meetings and other requirements

Requirements

• A minimum of 4 yrs. experience with data cleansing
• A minimum of 4 yrs. experience with INFOR Enterprise Asset Management implementation and database load processes and requirements.
• Knowledge of asset inventory and maintenance management data systems. Preferably Railroad Power asset management systems.
• Experience utilizing ETL (Extract, Transform and Load) tools

RESPONSIBILITIES
• Perform extensive data validation/quality assurance analysis within large datasets.
• Data analysis, standardization, manipulation, and enhancement to equipment master data records will be in accordance with INFOR data standards without customizations.
• Collaborate with the Metro-North Railroad Enterprise Asset Management team and Power Department SMEs to Resolve asset data gaps or anomalies.
• Analyze and translate business requirements and technical specification documents.
• Support Asset Hierarchy Structure development/refinement as needed to meet asset owner’s performance and reporting requirements.
• Report to MNR EAM department head and interact daily with EAM personnel and Power dept SMEs. Good communication skills at all levels is paramount. Will need to work around Power department schedules as their daily work priorities change.
 

RISKS 
• Describe the type of work consultant: Desk work only
• whether any work will be performed within 50 feet of track right-of-way (yes or no) NO
• Whether the work may involve areas with environmental risks (lead, asbestos) -- substantial or minimal (yes or no). NO
 

DELIVERABLES & DUE DATES
• A Complete and formatted Power Equipment Load Sheets to support INFOR data migration.
• Preventative Maintenance Plan populated templates per Power Asset Classes.
 

QUALIFICATIONS EXPERIENCE & EDUCATION
• Bachelor’s degree in Engineering, Computer Science, or closely related field.
• Minimum 4 yrs. experience as a Data Analyst.
• Knowledge of asset inventory and maintenance management data systems. Preferably Railroad Power systems.
• Minimum 4 yrs. experience with INFOR Enterprise Asset Management implementation and data load processes and system configuration requirements for both point based and linear assets.
• Experience utilizing ETL (Extract, Transform and Load) tools i.e. Microsoft Visual Studio for creating ETL packages for data migration.
• Proficiency using Microsoft Office 2013 (Word, Excel, PowerPoint), MS PowerBI and AcrGIS.
• Proficiency using Microsoft Visual Studio ELT tool.

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer