Data Engineer

Job Description

Summary of the position This role will work closely with the Head of Data to design and develop scalable data solutions that support the centralisation of company wide data into a governed data warehouse environment, likely built on Azure Data Lake and/or SQL Server. The focus will be on building efficient ELT pipelines, APIs, and database architectures to enable high performance ingestion and storage of data from multiple systems into a single consistent repository that powers business reporting and operational decision making. While the primary focus will be on delivering centralised data infrastructure, the role will also support ad hoc data solution requirements driven by business demand to ensure continuity of BAU operations. Key accountabilities Data Solutions Development & Management Design and implement scalable database and data warehouse solutions Build and manage data ingestion pipelines for batch and real time integration of multiple internal and external sources Define and maintain relational schema and metadata frameworks for consistency and efficiency Support the development of a centralised company data repository to unify reporting and analysis across teams Optimise database structures and queries for performance and scalability. Maintain documentation and version control of all data pipeline and architecture components API and Systems Integration Develop and maintain robust APIs for internal and external data exchange Ensure efficient data flow between operational systems and reporting platforms Support system integrations with CRM, finance, operations, and marketing tools as needed Governance Work with IT and compliance officials to enforce access control, encryption, and PII protection across all data solutions Implement and monitor compliance with data protection regulations (e.g. GDPR) Promote and uphold data quality, governance, and security standards Advisory & Transitional Support Act as a subject matter expert on best practices in data engineering and cloud architecture Provide ongoing guidance to internal teams on performance optimisation and scalable solution design Hold DBA responsibilities for the SBR database Skills and Experience | Essential 5 years of experience as a SQL Developer or similar role Strong understanding of system design and software architecture Ability to design and build data infrastructure solutions that are performant and scalable Deliver Data solutions in accordance with UK GDPR Strong proficiency with SQL and its variation among popular databases Skilled at optimising large, complicated SQL statements Strong understanding of API knowledge and data ingestion pipeline creation