Data Analyst Rail/Transit

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

Benefits offered by this job

Healthcare insurance premiums (100% of

Generous vacation leave entitlement

401K with employer matching

LifeMart Employee Discount Program

Job summary

Network Rail Consulting, the international consultancy arm of Network Rail, is seeking a Data Analyst for our Seattle location. You will extract, compile, analyze and visualize data from client systems to support decisions and drive improvements in asset management and transit operations.

You will create impactful PowerPoint presentations and build dashboards in Excel and Power BI for internal and client use.

Qualifications

• Applicants should be a recent graduate or have a bachelor’s or master’s Degree or equivalent in a relevant field.
• You are passionate about data and ways that data can tell a story.
• Strong analytical and critical thinking skills; formal report, presentation and note writing skills; proficiency in spreadsheet manipulation; attention to detail and communication skills.

Responsibilities

• Compile data from client systems including EAM/ERP/LMS to support training and inventory data.
• Perform data mapping to support data migration and conformance evaluation.
• Develop data definition/dictionaries with SMEs.
• Develop data standards through partnering with data governance program.
• Communicate remediation plans and develop steps for data remediation.
• Develop reference data and taxonomies.
• Extract and organize data for analysis and trending and compare ERP/EAM Program needs.
• Ensure data quality and compliance with applicable 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.

Skills

Power BI

Excel

PowerPoint

Data storytelling

Education

Bachelor's or Master's degree in a relevant field

Tools

EAM/CMMS

ERP

LMS

GIS

Job description

Network Rail Consulting (NRC) is the international consultancy arm of Network Rail – the owner and operator of Britain’s mainline rail system. We have been active in the North American, Australian and the Middle East markets since 2013 and have successfully delivered more than 150 consultancy contracts for government, public and privately owned organizations.

Through our consulting services in the United States (US), we are assisting both public agencies and private clients in the transportation sector to accelerate transformation efforts, make step-changes in major program delivery, and achieve leaps forward in areas such as asset management & maintenance, major projects, railway operations, strategic planning and advisory.

Our work is driven forward by our values: agile, always safe, care about people, collaborative, impartial and passionate.

About the Role

NRC supports multiple US clients from our strategic locations in Washington DC, New York City, and Boston, as well as West Coast clients from our offices in California and Seattle.

We are seeking a Data Analyst for our Seattle location.

You will provide support to our internal project teams and our clients to extract, compile, analyze and visualize data to help us make informed decisions that drive improvement in the way that transit assets are managed. Creating impactful PowerPoint presentations is a significant part of the role.

The initial client work will be with Sound Transit and King County Metro staff, focusing on data related to work orders, inventory, training data, and project dashboards.

What will you be doing?

• 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.
• Develop data standards through partnering with data governance program.
• Communicate to business on the remediation plan needed and develop plans to support next steps work on data remediation.
• Develop reference data and taxonomies.
• Extract and organize data for analysis and trending and compares 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.

About You

Applicants should be a recent graduate or have a bachelor’s or master’s Degree or equivalent in a relevant field.

You are passionate about data and ways that data can tell a story. You have strong analytical and critical thinking skills; strong formal report, presentation and note writing skills, proficiency in spreadsheet manipulation; great attention to detail and communication skills.

• Highly skilled in Power BI, Excel, and PowerPoint
• Excellent communicator and writer
• Experience in MS Co-Pilot
• A highly capable visual storyteller that can make data easy to understand
• An excellent listener that can work independently with clients
• Experience with EAM / CMMS applications is strongly preferred.
• Previous experience with ERP / LMS / GIS applications is desirable but not essential.

For the right person, this role presents a fantastic opportunity to develop their career, joining an established and passionate team, with ambitious plans to grow.

We offer benefits such as:

• Competitive compensation packages
• Healthcare insurance premiums (100% paid for by us)
• Generous vacation leave entitlement
• 401K with employer matching contributions
• Access to Employee Discount Program via LifeMart

NRC supports flexible working practices, and we understand that life balance is an important part of our employees' lives. We offer a wide range of flexible work/life balance options such as hybrid (home/office) working, flexible working hours where appropriate.

Candidate must be eligible to work in the United States without the need for employer sponsored work authorization now or in the future

Network Rail Consulting is an Equal Opportunity Employer. We welcome applications from all qualified candidates regardless of age, race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, or veteran status.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.