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.

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 Data Ops 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…