Data Engineer

Your new company

This company is a well-respected charity and registered social landlord dedicated to providing high-quality, affordable homes and supporting thriving communities across South Devon. The organisation now manages over 4,000 homes spanning areas from Dartmoor National Park to the urban centres of Teignbridge, the South Hams, West Devon, Mid Devon, East Devon, and Exeter.

As a non-profit housing provider, they deliver a full range of housing and tenant support services, including property repairs and maintenance, rent management, financial advice, and neighbourhood development initiatives. Its work is focused on raising service standards, adapting to evolving community needs, and helping residents access opportunities that improve their wellbeing and quality of life.

The organisation's vision-"Homes people love, a landlord you can trust"-is reflected in its values of being friendly, accessible, collaborative, and committed to continuous improvement. The business works closely with tenants, partners, and local stakeholders to build sustainable, inclusive communities.

Headquartered in Newton Abbot, the company employs a dedicated team who share a mission to make the South Devon area a better place to live through responsible housing management, investment, and community engagement.

Your new role

The purpose of this role is to lead the development and operation of the organisation's data engineering capability, ensuring that data is efficiently extracted from source systems, transformed through robust ETL/ELT processes, and loaded into well-structured data models that support strategic reporting, analytics, and Business Intelligence.

The post-holder will develop scalable pipelines, improve data quality, enhance data models, and strengthen data governance and standards across the organisation. Through collaboration, knowledge sharing, and the application of modern data engineering practices, the role will drive improvements in organisational data maturity and contribute to the successful implementation of the data strategy.

To work within the Company's Equality and Diversity Policy, Health and Safety Policy, Customer Service and Performance Policies ensuring that these are complied with throughout all activities within the scope of this role to ensure the highest standards of customer care.

Ensure that all activities undertaken are carried out to the highest standards of integrity and professionalism in accordance with the Company's policies and procedures.

Bring your skills, your ideas and your initiative to the role.

What you'll need to succeed

To thrive in this role as a Data Engineer, you'll bring a strong blend of technical expertise, analytical capability, and a commitment to delivering high-quality data solutions that support organisational goals.

Qualifications & Background

You'll have:

A relevant degree (or equivalent experience gained through progressively responsible data roles); or a formal professional qualification within Data Engineering.

Technical Experience

You'll need:

Experience as a Data Engineer or in a similar technical data role. Experience designing, building, and maintaining ETL/ELT pipelines. Hands-on experience with orchestration tools such as SSIS, Azure Data Factory, or similar. Practical experience implementing data validation, exception reporting, reconciliation checks, and data quality rules. Strong ability to transform, cleanse, and manipulate datasets using SQL/T-SQL. Experience producing clear technical documentation, data flows, and specifications. Ability to design and implement dimensional data models (e.g., star schema) including Slowly Changing Dimensions (SCD Type 1/2) for accurate historical reporting.

Desirable:

Experience in the Social Housing sector. Exposure to BI tools such as Power BI or SSRS. Experience with CI/CD, automated testing, or DataOps practices.

Knowledge, Skills & Abilities

You should demonstrate:

Strong SQL and T-SQL development skills, including performance optimisation. A solid understanding of relational databases and technologies such as Azure SQL Database. Strong problem-solving and analytical skills. Awareness of cloud cost optimisation (compute, storage, pipeline efficiency). Understanding of data lifecycle management. Knowledge of RBAC and secure data access management principles. Ability to gather, interpret, and translate stakeholder requirements into technical solutions. Strong organisational skills and the ability to prioritise competing tasks. Understanding of data ethics, privacy, confidentiality, and regulatory frameworks such as GDPR. The ability to explain complex technical concepts to non-technical stakeholders. Willingness to support and upskill colleagues in data engineering concepts. A proactive, self-motivated approach and a commitment to high-quality service delivery. Ability to identify gaps in your own knowledge and seek opportunities for professional development.

Desirable:

Knowledge of Python for data manipulation, profiling, and data quality tasks.

Core Competencies

Customer Focus: You seek to understand stakeholder needs and ensure outcomes meet expectations.

Communication: You keep others informed, build strong relationships, and are approachable and collaborative.

Critical Thinking: You challenge existing processes and contribute new ideas to improve outcomes.

Flexibility & Adaptability: You adopt practical approaches to deliver results in a changing environment.

Leadership & Ownership: You take responsibility for implementing actions that support organisational aims.

Teamwork: You work effectively with colleagues to achieve shared objectives.

What you'll get in return Hybrid Working Model - 1 day a week in the office. Pension Model - Company 1.5 X your contribution.

What you need to do now If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV. If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career. #4774175 - Adam

A relevant degree (or equivalent experience gained through progressively responsible data roles); or a formal professional qualification within Data Engineering.

Technical Experience

You'll need:

Experience as a Data Engineer or in a similar technical data role. Experience designing, building, and maintaining ETL/ELT pipelines. Hands-on experience with orchestration tools such as SSIS, Azure Data Factory, or similar. Practical experience implementing data validation, exception reporting, reconciliation checks, and data quality rules. Strong ability to transform, cleanse, and manipulate datasets using SQL/T-SQL. Experience producing clear technical documentation, data flows, and specifications. Ability to design and implement dimensional data models (e.g., star schema) including Slowly Changing Dimensions (SCD Type 1/2) for accurate historical reporting.

Desirable:

Experience in the Social Housing sector. Exposure to BI tools such as Power BI or SSRS. Experience with CI/CD, automated testing, or DataOps practices.

Knowledge, Skills & Abilities

You should demonstrate:

Strong SQL and T-SQL development skills, including performance optimisation. A solid understanding of relational databases and technologies such as Azure SQL Database. Strong problem-solving and analytical skills. Awareness of cloud cost optimisation (compute, storage, pipeline efficiency). Understanding of data lifecycle management. Knowledge of RBAC and secure data access management principles. Ability to gather, interpret, and translate stakeholder requirements into technical solutions. Strong organisational skills and the ability to prioritise competing tasks. Understanding of data ethics, privacy, confidentiality, and regulatory frameworks such as GDPR. The ability to explain complex technical concepts to non-technical stakeholders. Willingness to support and upskill colleagues in data engineering concepts. A proactive, self-motivated approach and a commitment to high-quality service delivery. Ability to identify gaps in your own knowledge and seek opportunities for professional development.

Desirable:

Knowledge of Python for data manipulation, profiling, and data quality tasks.

Core Competencies

Customer Focus: You seek to understand stakeholder needs and ensure outcomes meet expectations.

Communication: You keep others informed, build strong relationships, and are approachable and collaborative.

Critical Thinking: You challenge existing processes and contribute new ideas to improve outcomes.

Flexibility & Adaptability: You adopt practical approaches to deliver results in a changing environment.

Leadership & Ownership: You take responsibility for implementing actions that support organisational aims.

Teamwork: You work effectively with colleagues to achieve shared objectives.