Transit Data Analyst — Dashboards & Data Quality

Network Rail Consulting; Seattle (WA); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive pay

Healthcare insurance

Vacation leave

401K with employer matching

LifeMart discount

Job summary

Network Rail Consulting is hiring a Data Analyst in Seattle, WA for a hybrid role supporting client project teams. You will help strengthen transit asset management by extracting, compiling, analyzing, and visualizing data, with the ability to turn findings into clear dashboards and presentations for both internal and external audiences.

You will partner with SMEs, develop data definitions, assess data quality, and design Power BI dashboards and Excel templates for internal and external

Qualifications

• Recent graduate with a Bachelor’s or Master’s Degree (or equivalent) in a relevant field.
• Highly skilled in Power BI, Excel, and PowerPoint.
• Excellent communicator and writer with strong presentation and documentation skills.
• Experience with MS Co-Pilot.
• Strong visual storytelling ability to make data easy to understand.
• Ability to work independently with clients.
• EAM/CMMS experience strongly preferred.
• ERP/LMS/GIS applications desirable.

Responsibilities

• Compile data from client systems including Trapeze EAM, Maximo EAM, and LMS/ERP sources.
• Perform data mapping to support data migration and conformance evaluation.
• Develop data definitions/dictionaries with SMEs.
• Evaluate data quality against metrics and propose remediation plan.
• Partner with data governance to develop data standards.
• Create reference data and taxonomies for consistency.
• Extract, organize, and analyze data for trending and ERP/EAM comparisons.
• Support recommendations with data remediation feedback.
• Ensure data quality and compliance with state and federal laws.
• Design and build dashboards in Excel and Power BI for internal/external use.
• Prepare PowerPoint presentations for audiences.
• Assist client/project team as required.

Skills

Power BI

Excel

PowerPoint

MS Co-Pilot

Communication

Independent work with clients

EAM/CMMS experience

ERP/LMS/GIS familiarity

Education

Bachelor’s or Master’s Degree (or equivalent)

Tools

Trapeze EAM

Maximo EAM

LMS

EAM

ERP

Excel

Power BI

PowerPoint

MS Co-Pilot

CMMS

Job description

Network Rail Consulting is hiring a Data Analyst in Seattle, WA for a hybrid role supporting client project teams. You will help strengthen transit asset management by extracting, compiling, analyzing, and visualizing data, with the ability to turn findings into clear dashboards and presentations for both internal and external audiences.

You will partner with SMEs, develop data definitions, assess data quality, and design Power BI dashboards and Excel templates for internal and external