Data Analyst at Network Rail DFTO, Remote, 2 Months, £Contract Rate

Network Rail is at the heart of revitalising Britain's railway. From Crossrail - Europe's largest civil engineering project - to investment in world-class stations and major programmes of electrification, we are involved in some of the most ambitious and diverse ventures that this country has ever seen. We at Network Rail are dedicated to becoming one of Britain 's best employers and believe this starts with placing the candidate at the heart of everything we do!

As a Data Analyst, your main responsibilities will be:

• Provide dedicated resource to undertake organisational structure data cleansing across nine Train Operating Companies (TOCs), DFTO, RDG, and a light-touch review of Network Rail.
• The objective is to identify and resolve organisational structure anomalies, ensuring the baseline workforce data accurately reflects current organisational arrangements.
• Review organisational structure data and associated organisation chart visualisations across: 9 TOCs, DFTO, Rail Delivery Group (RDG),Light-touch review of Network Rail.
• Identify and log organisational structure issues.
• Engage directly with local organisational subject matter experts within each company.
• Update the underlying organisational structure datasets with approved corrections.
• Maintain alignment between source data, baseline datasets, and organisational chart outputs.
• Validate changes following implementation to confirm issues have been resolved.
• Ensure auditability of all amendments made during the cleansing process.

Essential: 

• Strong ability to analyse large workforce datasets, identify organisational structure anomalies, and implement accurate data corrections to improve data quality.
• Proficient in Pivot Tables, XLOOKUP/VLOOKUP, complex formulas, data reconciliation, and validation techniques for managing and analysing large datasets.
• Experience using Qlik tools to review organisational structures, validate workforce data, and ensure consistency between datasets and reporting outputs.
• Understanding of organisational hierarchies, reporting lines, and organisation charts to maintain accurate workforce and structural data.
• Ability to collaborate with SMEs, maintain audit trails, document changes, and ensure all amendments comply with data governance standards and quality controls.

Please be aware that this role can only be worked within the UK and not Overseas.

DFTO is an equal opportunity employer and values diversity. They welcome applications from everyone.

Disability Confident

As a member of the Disability Confident Scheme,DFTOl guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

Armed Forces Covenant

DFTO guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

In applying for this role, you acknowledge the following this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different.