Data Analyst

The National Archives is looking for a Data Analyst with in-depth experience in design and data architecture, creating conceptual models and transforming them to logical models and physical schemas and in defining mappings / transformations between data models.
You will work in an open, transparent and collaborative environment, engaging with internal and external communities to share your work and learn new from others, maintaining your understanding of developing technologies that can be applied to archival content enhancement and to enable the re-use of public data., If a person with disabilities is put at a substantial disadvantage compared to a non-disabled person, we have a duty to make reasonable changes to our processes.
If you need a change to be made so that you can make your application, you should:
+ Contact The National Archives via careers@nationalarchives.gov.uk as soon as possible before the closing date to discuss your needs
+ Complete the “Assistance required” section in the “Additional requirements” page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at interview, or if you’re deaf, a Language Service Professional
Feedback will only be provided if you attend an interview or assessment.

Security
Successful candidates must undergo a criminal record check.
People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements
This job is broadly open to the following groups:
+ UK nationals
+ nationals of the Republic of Ireland
+ nationals of Commonwealth countries who have the right to work in the UK
+ nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
+ nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
+ individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
+ Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service
Further information on nationality requirements (opens in a new window)

Working for the Civil Service
The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.
The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

As our Data Analyst, you will have a strong background in organising, managing, enriching and manipulating data, including structured and text-based information. You will have excellent experience of the relevant database technologies and programming languages and be highly skilled in structuring, converting, analysing and exploring data to reveal underlying patterns and stories. You will have the ability to think rigorously about the complex issues involved in data collection and manipulation and will enjoy working with records specialists to support access to the digital archive.
You will remain calm whilst working under pressure, dealing with a wide variety of tasks and will have experience in problem solving using data design. You will see opportunities for improvements and be able to communicate with both technical and non-technical audiences through appropriate medium.
This is an opportunity to work with committed and talented developers, designers, archivists and researchers who share a passion for creating high quality, user-focused digital services for a range of audiences.
Join us here in beautiful Kew, just 10 minutes’ walk from the Overground and Underground stations, and you can expect an excellent range of benefits. They include a pension, the option to work part time or job share and discounts with local businesses (e.g. beauty salons and bars). We also offer wellbeing resources and have an on-site gym, restaurant, shop and staff bar., This is a full time post. However, requests for part-time working, flexible working and job share will be considered, taking into account at all times the operational needs of the Department. A combination of onsite and home working is available and applicants should be able to regularly travel to our Kew site for a minimum of 60% of their work time., You will be asked to provide details of your work experience and write a personal statement. In your personal statement please explain, using examples, how you meet the essential criteria given below. You may draw on knowledge, skills, abilities, experience gained from paid work, domestic responsibilities, education, leisure interests and voluntary activities. Please note selection for interview will largely be based on the information you provide in this section.
SC-level Security Clearance or willingness to obtain SC clearance may be required for this role and requires that you have lived in the UK for the last 3 years. The length of required residency may depend on individual circumstances., + Data technologies: Excellent skills in pattern analysis with a broad knowledge and experience of relevant technologies for encoding, cleansing, manipulating and analysing complex structured and unstructured data. For example, data encoded in XML, CSV, JSON; programmatic techniques in Python, Shell scripting, XSLT, SQL.,
+ ETL Processes: Knowledge of how to extract data from various sources, including databases, APIs, and flat files. Demonstrable ability to clean, format, and transform data to meet the requirements of the target system. Skills in loading transformed data into target destinations or data models and vocabularies. Familiarity with relevant tools (for example, Talend, Informatica, Stitch, Pentaho).
+ Data Migration Techniques: Understanding of different data migration strategies, including full migration, incremental migration, and real-time migration. Experience of planning and executing data migration projects, ensuring minimal downtime and maintaining data integrity.
+ Problem-Solving: Ability to identify and resolve issues that arise during the ETL and data migration processes. Experience in debugging and optimising ETL workflows for better performance, demonstrating a proactive and solutions focused approach to problems.
+ Data Governance: Understanding of data governance practices, including data quality; reference and master data; data interoperability. An appreciation of how data governance works with other governance structures within the organisation.
+ Communication and relationships: Strong communication and relationship building skills, able to communicate effectively with technical and non-technical stakeholders, support and host discussions within a multidisciplinary team, with potentially difficult dynamics, be an advocate for the team externally, and can manage differing perspectives
+ Approach to work: Exceptional accuracy and attention to detail. Proactive and tenacious in solving problems. Strong organisational skills, motivated to work both independently and as a project team member. Demonstrable ability to prioritise tasks and deliver high quality work to agreed deadlines. A commitment to developing new skills and sharing your expertise with others.
Desirable criteria:
+ Practical experience and knowledge of a range of database technologies (for example:, RDBMS, triple stores / linked data, graph databases)
+ A strong focus on meeting user needs
+ Experience or awareness of Agile methodologies
+ Ability to manage projects (such as data migration projects), including planning, execution, and monitoring progress
+ Good understanding of the value of records and archives

Archives are the homes for our collective memories, past and future. The National Archives is the archive of government, archives sector lead and one of the world’s leading archives.
We play a crucial role. Archives Inspire, our business strategy, sets the ambition to change how people think about archives. It identifies digital as our biggest strategic challenge as well as presenting us with huge opportunities to rethink how we provide access to our digital records.

Alongside your salary of £36,000, The National Archives contributes £10,429 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
Generous benefits package, including pension, sports and social club facilities, onsite gym, discounted rates at our on-site cafe and opportunities for training and development.
Any move to The National Archives from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax-Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk