Job Title: Data Engineer Location: Preston, Fulwood Contract Type: Permanent Hours: Monday – Friday 37.5 Hours We are always looking for great talent to join our team and help achieve our ambitious goals and growth. We care about our people, and we care about the future of community health and how CHEC can play an innovative part in making this great, with your help. If you are care focused and looking to join an organisation that is thriving on success, then CHEC is your employer of choice! We have an exciting opportunity to join us as we continue to expand throughout the UK. About the Role The role holder will be accountable for designing, building, and maintaining the data infrastructure and pipelines that enable efficient and accurate data collection, storage, processing, and analysis. The role holder will collaborate with cross-functional teams, including analysts, software engineers and key stake holders to create and maintain data solutions that are crucial in delivering high quality care for our patients. We are looking for someone who can. Design, implement, and optimise data storage systems, including databases, data warehouses, and data lakes, to efficiently handle large volumes of structured and unstructured data. Develop and maintain scalable ETL pipelines to extract, transform, and load data from various sources into the target data systems. Create and manage data schemas, data models, and data dictionaries to facilitate data governance and ensure data consistency and standardization. Develop data integration solutions to enable seamless and secure data flow between different systems. Implement data cleansing, validation, and enrichment processes to ensure data accuracy, completeness, and quality. Work with analysts and software engineers to understand requirements and provide data engineering report. Identify and resolve performance bottlenecks in data pipelines and optimise data processing and query performance. Implement monitoring systems and processes to track data pipeline health, identify issues and ensure timely resolution. Document data engineering processes, data flows, and system configurations to facilitate knowledge sharing and maintain a robust knowledge base. Collaborate with key stakeholders to understand data requirements and provide them with necessary reports, dashboards, and data visualisations. Participate in code reviews, provide construction feedback, and contribute to improving data engineering best practices and standards. What you’ll bring to the role: Some previous experience as a Data Engineer in a fast-paced business or as a Software Engineer with strong database or data platform experience. Experience handling large datasets and complex data pipelines. Experience with big data processing frameworks and technologies. Experience with data modelling and designing efficient data structures. Experience with data integration and ETL (Extract, Transform, Load) processes. Experience in data cleansing, validation, and enrichment processes. Strong programming skills in languages such as Python, Java, or Scala. Knowledge of data warehousing concepts and dimensional modelling. Understanding of data security, privacy, and compliance requirements Proficiency in data integration and ETL tools Strong analytical skills and the ability to understand complex data structures. Capable of identifying data quality issues, troubleshooting problems, and implementing effective solutions. Experience using Microsoft Azure Software Engineering – specifically Python Why work for us? 25 days annual leave plus bank holidays Buy and sell annual leave scheme Refer a friend scheme Company pension Company sick pay scheme Life assurance scheme Bluelight Card- 100’s of discount and cashback options Career development opportunities – dedicated reward framework and multiple learning opportunities Performance review with a training and development plan Great team and working environment