Department: Supporter Care and Database Services Location: hybrid – a minimum of 1 day in our Aldgate, London office each week Hours of work: 37.5 hours Annual leave: 33 days (plus eight bank holidays) Interview date: week commencing 17th February in person at our Aldgate, London office Benefits: • enhanced maternity, paternity and adoption leave, and shared parental pay • family-friendly policies • 8% employer pension contribution (Aviva) or opportunity to continue NHS pension • free health cashback plan (Medicash): employee cover plus up to four dependent children • 24/7 virtual GP access (UK registered), plus access to Best Doctors • free, confidential employee assistance programme (Medicash) • access to a wellbeing app, flexible working options including hybrid working, flexible working patterns such as part-time, compressed hours, and more* • learning and development opportunities including bespoke training and access to LinkedIn Learning) • commitment to employee health and wellbeing. We have a Menopause Friendly accreditation and are a Disability Confident employer Background Every three minutes someone in the UK develops dementia: a progressive and complex condition that can be devastating for the whole family. One in two of us will be affected by dementia in our lifetime – either by caring for someone with the condition, developing it ourselves, or both. Dementia UK is the specialist dementia nursing charity that is there for the whole family. Our specialist nurses, known as Admiral Nurses, provide free, expert advice, support and understanding to help families care for their loved one. Every day, Admiral Nurses help families up and down the country to have the best life possible, for as long as possible. Purpose of the job/about the role Join Dementia UK in this exciting new role as a Data Architect and play a key role in maintaining and developing the new Data Warehouse while supporting the administration of the Microsoft Dynamics environments and the integrations that supply and send data from those systems. As Data Architect, you will manage the relationship between the Database Services team and the IT team, ensuring effective communication and successful completion of cross-team initiatives and projects. You will support the administration of the Microsoft Dynamics environments and the integrations that supply and send data from those systems, creating and updating comprehensive documentation for the data architecture and associated data flows. You will also collaborate with the wider Database Services team to identify and implement technical solutions to the evolving requirements of the Fundraising and Engagement department. Staying up to date on new developments and updates released by Microsoft and other software providers, you will leverage these to improve existing processes. Additionally, you will lead in managing and troubleshooting established data pipelines linked to external data platforms and those involved in processing and transforming data into the data warehouse. To succeed in this role, you will be an expert in the Microsoft Azure data platform, specifically Azure Data Factories, with previous experience in developing data warehouses and proficiency in SQL. You will have experience using elements of the Microsoft Power Platform, including Power Automate, Flows, and Power Query, along with knowledge of data privacy and governance concepts and the principles of GDPR. If this sounds like you, join us now and be part of a team dedicated to making a real difference in the lives of those affected by dementia. Our culture In addition to a competitive salary and a generous benefits package, we truly value our people. It’s important for us to create a working environment that looks after our workforce to support them in achieving their full potential. You will become part of a diverse and dedicated team who are supported to use and develop their skills. We recognise and value the key role you will play in delivering our strategic plans for the benefit of those living with dementia. Our staff have a voice. Representatives from different roles and levels across the organisation positively contribute to and lead on our working groups around health and wellbeing, menopause, and equity, diversity and inclusion. Dementia UK is proud to welcome everyone. We aim for a truly inclusive culture with talented, diverse teams that represent a variety of backgrounds, perspectives, and skills. We celebrate difference and individuality and encourage everyone to join us and be their whole selves always. Dementia UK is a Disability Confident employer. If you would like support to make an application or to tell us you are applying under the Disability Confident scheme, contact [email protected].