Data Engineer Historic Royal Palaces is the independent charity that looks after the Tower of London, Hampton Court Palace, Kensington Palace, the Banqueting House, Kew Palace and Hillsborough Castle & Gardens. Departments: Corporate Planning Home Palace : Hampton Court Palace Status: Established/Permanent Salary: £50,630 Salary Rate: Per Annum Days/Hours of work: Full time, 36 hours per week, Monday - Friday About the role and about you We are the independent charity that loves and looks after six of the most wonderful palaces in the world. The palaces are the setting for the stories that shape us all, and we’re bringing them to people in ways that mean more to them. We want everyone to find themselves in the spaces and stories we share. Historic Royal Palaces (HRP) is embarking on an ambitious transformation to harness the power of data and analytics to enhance decision-making, strategic planning, and operational effectiveness. As part of this vision, we are recruiting for four key roles that will play a crucial part in shaping the future of data at HRP: Senior Data Manager, Data Engineer, Business Intelligence Analyst, and IT Business Analyst/Project Manager. Together, these roles will help HRP transition towards a more data-driven culture, ensuring that data is accurate, accessible, and aligned with our strategic goals. If you are passionate about data, collaboration, and driving meaningful impact through insights, we invite you to explore these exciting opportunities As part of this pioneering team, the Data Engineer will play a key role in shaping and driving data transformation efforts, including the implementation of a new data operating model, the development of a data warehouse, and the mainstreaming of advanced analytics. By helping to establish the foundations of HRP’s long-term analytics strategy, you will be at the forefront of efforts to develop a culture of data-driven decision-making across the organisation. About the role The Data Engineer will manage the development, optimisation, and maintenance of HRP's data infrastructure, including the data warehouse, ETL/ELT processes, and supporting advanced analytics workflows. The role holder will be responsible for designing scalable data pipelines that ensure the seamless ingestion and transformation of data to support all reporting, analytics, and custom data models. To succeed in this role, the roleholder will: Design, build, and maintain ETL/ELT pipelines to integrate data from multiple systems. Lead the implementation and optimisation of the data warehouse, ensuring high performance and scalability. Contribute to the design and evolution of the data warehouse architecture, working closely with the data manager to ensure alignment with organisational needs. Collaborate with the Data Manager and Analyst to enforce data governance standards and develop advanced analytics models. Continuously test and optimise data pipelines, applying best practices in CI/CD. Manage the data infrastructure codebase using version control systems like GitHub. Benefits include Hybrid working Enhanced holiday entitlement Generous Employers Pension Contributions (up to 11%) Annual Pay reviews & Bonuses Critical Illness Cover & Life Assurance Family friendly policies and benefits Staff discounts and membership to all palaces Person Specification Essential Skills: Technical Expertise Strong proficiency in SQL and Python, with proven experience developing and optimising ETL/ELT pipelines in large-scale environments. Experience with data warehousing tools (e.g. Snowflake, Amazon Redshift Azure Synapse) and cloud platforms like Azure, AWS, or GCP. Proactiveness & Logical Thinking Able to bring structure and logical processes to unstructured data environments, designing efficient data solutions that align with business needs. Self-starter who can work independently to identify areas for improvement in data pipelines and infrastructure. Experience: Minimum of 3 years' experience in a data engineering role, with responsibility for managing large data ecosystems. Proven experience with data pipeline performance tuning and data infrastructure optimisation. Closing date: 23:55pm2nd March 2025 If Applicable: We have adopted a hybrid model of part working from home and part working from site, we are open to discussing what best works for individuals and their work life balance whilst also delivering the business requirements. Historic Royal Palaces is an equal opportunities employer and truly values a diverse workforce. Applications are welcome from candidates regardless of their background. REF-219796