IT Data Architect
8 hours ago
Newton Abbot
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. 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 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.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.A relevant degree (or equivalent experience gained through progressively responsible data roles); or a formal professional qualification within Data Engineering.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., 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.Strong SQL and T-SQL development skills, including performance optimisation.A solid understanding of relational databases and technologies such as Azure SQL Database.Understanding of data lifecycle management.Knowledge of RBAC and secure data access management principles.Understanding of data ethics, privacy, confidentiality, and regulatory frameworks such as GDPR.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.What you'll get in return Hybrid Working Model - 1 day a week in the office. Pension Model - Company 1.5 X your contribution. Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk