Data Engineer

About the role

We are seeking a Data Engineer to support the digital transformation of the UK Defence Training Estate. You will help design, develop and maintain business intelligence solutions that turn data into actionable insights for our Armed Forces support services.

Key responsibilities

• Design, develop, deploy and maintain business intelligence solutions
• Write and optimise queries to meet data requirements
• Deliver insights through reports and visualisations
• Translate business needs into technical solutions
• Maintain and enhance data platforms and analytics systems
• Build and manage dimensional data models
• Conduct testing, troubleshooting and performance tuning
• Evaluate and improve existing BI systems
• Collaborate with technical teams to integrate systems
• Create and maintain technical documentation

Required profile

• Proven experience in a data‑focused role
• Strong background in data warehousing and dimensional modelling
• Understanding of database management systems, OLAP and ETL frameworks
• Experience with cloud data platforms (ideally Microsoft Fabric)
• Familiarity with Power BI or similar BI tools
• Ability to optimise and troubleshoot query performance
• Strong analytical and problem‑solving skills
• Eligibility for BPSS and SC security clearance (minimum 5 years UK residency)
• Full UK driving licence

Required skills

• Microsoft Fabric (cloud data platform)
• Power BI
• SQL query optimisation
• Data warehousing
• Dimensional modelling
• OLAP
• ETL frameworks
• Database management systems