Data Analyst Rail/Transit

About the Role

NRC supports multiple US clients from its strategic locations. The company is seeking a Data Analyst for its Seattle location. This role will provide support to internal project teams and clients to extract, compile, analyze, and visualize data to inform decisions driving improvement in transit asset management. Creating impactful PowerPoint presentations is a significant part of the role. Initial client work will involve Sound Transit and King County Metro staff, focusing on data related to work orders, inventory, training data, and project dashboards.

Key Responsibilities

• Compile data from client systems including Trapeze EAM, Maximo EAM, and various LMS / EAM / ERP systems for training and inventory data.
• Perform data mapping to support data migration and data conformance evaluation.
• Develop data definition/dictionaries with SMEs.
• Evaluate data quality against agency data quality metrics.
• Develop data standards through partnering with data governance programs.
• Communicate remediation plans to the business and develop plans to support next steps for data remediation.
• Develop reference data and taxonomies.
• Provide feedback on data remediation recommendations.
• Extract and organize data for analysis and trending; compare ERP/EAM program needs and requirements.
• Ensure data quality and compliance with applicable state and federal laws and regulations.
• Design and build dashboards in Excel and Power BI for internal and external use.
• Prepare PowerPoint presentations for internal and external use.
• Assist the Client, Project Manager, or project team as required.

Requirements & Tech Stack

• Highly skilled in Power BI, Excel, and PowerPoint.
• Experience in MS Co-Pilot.
• Visual storytelling skills to make data easy to understand.
• Ability to work independently with clients.
• Experience with EAM / CMMS applications is strongly preferred.
• Previous experience with ERP / LMS / GIS applications is desirable but not essential.

Qualifications

• Recent graduate or possess a bachelor’s or master’s Degree or equivalent in a relevant field.
• Passion for data and its ability to tell a story.
• Strong analytical and critical thinking skills.
• Strong formal report, presentation, and note writing skills.
• Proficiency in spreadsheet manipulation.
• Great attention to detail.
• Excellent communication and writing skills.
• Excellent listener.
• Eligible to work in the United States without the need for employer-sponsored work authorization.