Job description Data Platform Engineer Location: London or Newcastle with a minimum 2 days a week office attendance Contract Type: Permanent Full Time Salary: London c£70,000 Newcastle c£61,250 plus civil service employer pension employer contribution of 28.9% The deadline for applications is 11.59 pm Sunday 23rd July. We will be holding interviews WC 31st Aug. Nationality Requirement
Nationality Requirements
- UK Nationals
- Nationals of Commonwealth countries who have the right to work in the UK
- Nationals from the EU, EEA or Switzerland with (or eligible for) status under the European Union Settlement Scheme (EUSS)
Applicants must already meet the nationality requirements outlined above. Please be aware that we do not provide sponsorship for work visas for this position. Applicants must already meet the nationality requirements outlined above. If you have any questions regarding your eligibility, please contact the HR Service desk ( ) should you have any questions on your nationality eligibility.
About the National Audit Office
The National Audit Office (NAO) is the United Kingdom's main public sector audit body. Independent of government, we have responsibility for auditing the accounts of various public sector bodies, examining the propriety of government spending, assessing risks to financial control and accountability, and reviewing the economy, efficiency and effectiveness of programmes, projects, and activities. We report directly to Parliament, through the Committee of Public Accounts of the House of Commons which uses our reports as the basis of its own investigations. We employ approx. 1,000 people, most of whom are qualified accountants, trainees, or technicians. The organisation comprises two service lines: financial audit, and value for money (VFM) audit and has a strong core of highly talented corporate teams. The NAO welcomes applications from everyone. We value diversity in all its forms and the difference it makes to our organisation. By removing barriers and creating an inclusive culture all our people can develop and maximise their full potential. As members of the Business Disability Forum and the Disability Confident Scheme we guarantee to interview all disabled applicants who meet the minimum criteria. The NAO supports flexible working and is happy to discuss this with you at application stage.
Context and main purpose of the job
This is a new vacancy created within NAO's Digital Services (DS) to expand the data team within the Audit Technology & Data pillar, with responsibility for designing, building, and maintaining the infrastructure that enables robust data ingestion process, storage, and access across the organization. This role supports the development and continual improvement of NAO data & technology service composition and provision, enabling scalable and reliable data solutions. In this capacity, you will build and optimise data pipelines, integrate diverse data sources, and ensure the efficient movement of data across systems. You will work closely with analytics engineers, data scientists, and other stakeholders to ensure data is accessible, high-quality, and fit for purpose. Your work will underpin the NAO's ability to derive insights and automate processes using corporate and client data. In this role, you will:
- Design, develop, and maintain scalable data pipelines and ETL processes.
- Integrate structured and unstructured data from internal and external sources.
- Ensure data quality, consistency, and security across systems aligning with the NAO's data strategy.
- Collaborate with analytics engineers and subject matter experts to support data modelling and transformation.
- Work closely with the other digital roles including Cybersecurity, BI, Architecture to ensure effective delivery.
- Monitor and optimise performance of data infrastructure
- Test, monitor, and document data architecture and engineering processes to ensure transparency and maintainability.
This role reports into the Audit Data Platform Lead. This role requires regular attendance at the NAO's office either in Victoria, London, or at the office in Newcastle.
Main Responsibilities
- Building scalable data infrastructure: Design and implement systems that support the ingestion, storage, and processing of large volumes of structured and unstructured data from internal and external sources.
- Developing robust data pipelines: Create automated workflows that extract, transform, and load data into centralised platforms, ensuring consistency, reliability, and performance across all stages.
- Designing and optimising ETL processes: Build and maintain efficient ETL (Extract, Transform, Load) workflows to move data from source systems into usable formats. Ensure these processes are scalable, well‑documented, and aligned with data quality standards.
- Integrating diverse data sources: Connect and harmonise data from various systems (e.g., operational databases, APIs, cloud services) to create unified datasets for analysis and reporting.
- Collaborating across teams: Work closely with analytics engineers, data scientists, and business stakeholders to understand data needs and deliver infrastructure that supports analytical and operational use cases.
- Ensuring data reliability and performance: Monitor data systems for latency, failures, and bottlenecks. Implement performance tuning and system optimisations to maintain high availability and responsiveness.
- Implementing data governance and security protocols: Apply best practices for data privacy, access control, and compliance. Ensure that sensitive data is protected and handled in accordance with regulatory requirements.
- Maintaining technical documentation: Produce and update documentation for data architecture, pipeline configurations, and operational procedures to support transparency and continuity.
- Troubleshooting and incident response: Investigate and resolve data-related issues, from pipeline failures to data integrity concerns. Establish proactive monitoring and alerting systems.
- Supporting data accessibility: Enable self‑service access to clean, well‑organised data for analysts and other users through tools, APIs, or data platforms.
- Keeping pace with technology: Stay informed about emerging tools, frameworks, and methodologies in data engineering. Continuously evaluate and adopt innovations that improve efficiency and scalability.
Key skills / competencies required
- Communicating between the technical and non-technical (Skill level: Awareness) - You can explain why it is important to communicate technical concepts in non-technical language. You understand the types of communication used with internal and external stakeholders and their impact.
- Data Analysis and Synthesis (Skill level: Working) - You can undertake data profiling and source system analysis. You present clear insights to colleagues to support the end use of the data.
- Data Development Process (Skill level: Working) - You can design, build, and test data products based on feeds from multiple systems, using a range of storage technologies and access methods. You create repeatable and reusable products.
- Data Innovation (Skill level: Awareness) - You show awareness of opportunities for innovation with new tools and uses of data.
- Data Integration Design (Skill level: Working) - You deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable, and future‑proof.
- Data Modelling (Skill level: Working) - You understand the concepts and principles of data modelling. You can produce, maintain, and update relevant data models and reverse‑engineer models from live systems.
- Metadata Management (Skill level: Working) - You use metadata repositories to complete complex tasks such as data and systems integration impact analysis. You maintain metadata repositories to ensure accuracy and currency.
- Problem Management (Skill level: Awareness) - You investigate problems in systems, processes, and services, and contribute to the implementation of remedies and preventative measures.
- Programming and Build (Data Engineering) (Skill level: Working) - You can design, code, test, correct, and document simple programmes or scripts under direction. You follow agreed standards and tools.
- Technical Understanding (Skill level: Working) - You understand core technical concepts related to the role and apply them with guidance.
- Testing (Skill level: Working) - You review requirements and specifications, define test conditions, identify issues and risks, and report test activities and results.
Essential Criteria
- Deep, hands‑on experience as a cloud‑based Data Engineer, ideally within Microsoft Azure environments.
- Expert‑level experience designing and delivering ETL/ELT pipelines at scale.
- Strong experience in data modelling, including standardisation, best practice, and semantic layer design.
- Advanced Python skills for data processing, optimisation, and automation.
- Strong SQL expertise, including T‑SQL and PostgreSQL.
- Proven experience implementing and operating medallion architecture patterns.
- Experience with cloud-native Azure data services, including:
- Azure Databricks
- Microsoft Fabric
- Azure Data Factory
- Demonstrable experience in pipeline performance tuning and optimisation.
- Experience working closely with DevOps engineers, with a solid understanding of CI/CD, Infrastructure as Code (IaC) such as terraform.
- Knowledge in Software Development Life Cycle (SDLC) practices, including automated testing (e.g. Pytest).
Desirable / Preferred Experience
- Experience in analytics engineering, including development of semantic data models for reporting and analytics.
- Experience with infrastructure and data governance tooling, such as:
- Power BI
- Microsoft Purview
- Azure Databricks
- Experience in cluster management, parallel computing.
- Experience using industry‑standard ETL, orchestration, and scheduling tools, including:
- Azure Data Factory
- Azure Automation
- Azure DevOps
- Ability to lever multiple programming and scripting languages, including Python and PowerShell, to automate platform operations and engineering workflows.
Experience Requirements
- ETL and Data Pipeline Development: Demonstrated cloud‑based experience in designing, building, and maintaining ETL workflows and deploying data pipelines. Skilled in extracting, transforming, and loading data from various sources into centralised platforms.
- Data Infrastructure and Integration: Proven ability to implement data flows between operational systems and analytics platforms. Experience with cloud‑based data services (Azure preferred) and streaming systems is desirable.
- Database Management and Optimization: Experience managing relational and non-relational databases, including performance tuning, indexing, and query optimisation. Familiarity with database design principles and data warehousing solutions.
- Collaboration and Communication: Ability to work effectively with technical and non-technical stakeholders. Skilled in translating business requirements into technical solutions and supporting cross‑functional teams.
- Problem Solving and Troubleshooting: Capable of identifying and resolving data‑related issues, implementing preventative measures, and contributing to system reliability.