We're looking for a Lead Data Engineer to guide a small team of Data Engineers and Analysts in developing secure, scalable, and high-performing data solutions on the Microsoft Azure platform. This role combines hands-on technical leadership with strategic direction, ensuring the successful delivery of data initiatives that drive analytics, reporting, and business intelligence across the business. Key responsibilities will include: Provide day-to-day guidance and technical support to a small team of Data Engineers/Analysts. Act as a subject matter expert on Azure data tools and best practices, helping analysts translate business needs into scalable data solutions. Foster a collaborative environment that encourages learning, innovation, and cross-functional communication. Assist in prioritising tasks, setting goals, and ensuring alignment with broader data strategy. Design and develop data pipelines for data extraction, transformation, and load (ETL) processes using SQL, SSIS, Azure Data Factory and similar technologies. Construct and maintain audit and other data-tracking assets that create visibility into processes to ensure consistency, accuracy, and timeliness of data. Prepare data flow and lineage documentation to support analysts, change procedures, and automated processes. Integrate data from various sources, including internal databases, external APIs, and third-party data providers. Contribute to activities related to data management including database design, data dictionary management, and troubleshooting. Review and write complex stored procedures and other related TSQL code. Collaborate with cross-functional teams to understand data requirements and designs scalable solutions. Evaluate and improve existing data warehouse and BI infrastructure. Review and test new platforms/technology related to data and data management. There are some essential experience and leadership skills you will need to have: Bachelor's degree in Computer Science, Information Systems, or related technical field. 3 years' experience developing data solutions related to ETL and data engineering. Advanced knowledge of TSQL and related ETL tools including SSIS and Azure Data Factory. Ability to read, write, and debug complex stored procedures and similar code. A passion for automation and operational excellence with the ability proactively identify and resolve issues. Ability to work independently and as part of a team. Analytical mindset and problem-solving skills. Highly organised with excellent attention to detail. Experience of managing people Azure Data Engineer certification