Data Engineer Location: Cardiff, Remote/Flexible options Available Contract Type: Permanent Salary: £40,000-£45,000 Benefits About the Role: We are looking for a Data Engineer to join our dynamic Data Governance and Engineering Team, a key part of our organisation’s Data Team. This role will be integral to designing, planning, and implementing data structures and pipelines across both on-premises (Microsoft SQL Server) and cloud (Microsoft Azure) environments. You will be at the forefront of our data and analytics journey, contributing to the migration to and development of a new cloud-based data platform. As a Data Engineer, you will mentor junior team members and may occasionally deputise for the Lead Data Engineer in stakeholder engagements. This role offers the chance to work with cutting-edge cloud technologies and advanced analytics within a high-performing, collaborative team. Key Responsibilities: Lead the design and implementation of data engineering projects across on-premise and cloud-based environments, ensuring solutions are robust, efficient, and compliant with architectural and data security standards. Mentor and support Data Engineers within the team to ensure that developed solutions add business value. Collaborate with internal teams, such as Integrated Technology Services (ITS), to ensure that IT components and services align with developed solutions. Stay informed on new data engineering approaches, suggesting improvements that can drive business benefits. Support existing SQL Server data infrastructure, ensuring that it continues to effectively serve the business’s analytics needs. Who You'll Work With: Data Team Integrated Technology Services (e.g., Architecture, InfoSec) Third-party partners Stakeholders across various business functions Qualifications and Experience: Essential: Relevant undergraduate degree (BSc) in computer science, mathematics, or a related discipline, or equivalent experience. Experience in database management, data architecture, or data platform management. At least 2 years of experience working with a cloud-based data stack (e.g., Azure, AWS, GCP). Substantial experience in data pipeline design and management. Strong T-SQL programming skills, including DDL, DML queries, and performance tuning. Familiarity with data security approaches, including permission models and data protection techniques (e.g., encryption, masking). Desirable: Experience with event-driven architecture and cloud performance monitoring. Knowledge of DevOps, CI/CD pipelines, and agile project management principles. Experience in migrating on-premise SQL servers to cloud environments. This is an exciting opportunity to be part of a forward-thinking team driving data innovation. If you’re passionate about data engineering and cloud technologies, we’d love to hear from you