Data Architect

Salary: Starting from £45,000.00 (depending on experience)

Working hours: 35 hours per week

Duration: Permanent 

Location:Remote

About the role

Lloyd & Whyte, who are proudly part of Benefact Group, are looking for aData Architectto join ourData Analysisteam. This role will be remote but the ideal candidate will be willing to commute to the Taunton or South Ockendon office on occasion, where required.

The ideal candidate will work alongside the widerData Analysisteam to develop, populate, and maintain a Data Warehouse (DWH), enabling the business to maximise the use of this data to support operational plans and decision making in support of the business’s vision.

Why join us?

Join a collaborative and inclusive culture that’s committed to making a difference and building a more sustainable future. Ranked amongst the UK's top 50 Best Large Companies to Work For in 2024, we offer fantastic career and development opportunities within a rapidly growing, innovative Group—where all profits go to charity and good causes.

What you'll be doing 

• 
  
• Achieve individual objectives and key performance indicators and maintain own technical competence with in-depth knowledge sufficient to fulfil the role
  
• Continually expand knowledge of SQL Server and its related tools
  
• Create and modify DWH objects, such as tables and views; Develop, and maintain, ETL processes to update the data within the DWH
  
• Performance tuning of the DWH, such as indexing, for both the updating and consumption of data within it
  
• Monitor automated tasks failed on the SQL Server estate, and review or escalate within the team as necessary
  

What you'll need to have 

• 
  
• Strong knowledge of data warehouse development, SQL Server, the T-SQL dialect and SSIS development and deployment
  
• Inquisitive and prepared to challenge and investigate anomalies in data
  
• Organised, resourceful, deadline driven and supportive of the wider team
  
• Highly communicative, Quality orientated, Flexible, pragmatic, and approachable
  
• Highly focused on project delivery within agreed timescales
  

What makes you stand out 

• 
  
• Level 3 qualified in a relevant field
  
• Experience in / knowledge of the insurance industry
  

What we offer

• 
  
• 
  28days annual leave plus bank holidays
  
• Your birthday off
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
• Group Personal Pension
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
• Bonus scheme
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
• A holiday buy scheme 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
• An array of health and wellbeing benefits, company cash plan, income protection and life assurance
  
• Enhanced sick pay and parental leave
  
• Support and funding toward study and professional qualifications
  
• Paid time off for volunteering
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

Lloyd & Whyte offer a range of specialist insurance services to a variety of clients. Our specialisms range from niche scheme insurance for Healthcare professionals to expert insurance for commercial motor vehicles and professional broker-to-broker insurance services. We also have a wide range of personal insurance services that cover homeowners from standard houses through to thatch & listed character properties and high value homes. The Lloyd & Whyte Group is split into five different client divisions which include multiple companies and brands.

Benefact Groupis a unique international financial services Group made up of over 30 businesses. We are owned by a charity and have been the 3rd largest UK corporate donor over a decade*, having given away £250 million since 2014. We have ambitious plans to become the UK’s number one corporate donor, with strategic objectives in place to double the Group’s size.

We believe it’s essential to attract, empower, grow and reward talented people, offering fantastic opportunities for career and personal development. Our giving ethos, 135-year history and the diversity of what we do, has enabled us to build a culture of kindness, great ambition, and of passionate people driven to do better and be better.

At Benefact Group, we are committed to creating an
inclusive culture and building an environment where each and every one of us
feels valued and respected. We are a community made up of people with a
range of different backgrounds, abilities, perspectives, beliefs and interests
and we value the strength this brings to us as a Group. We welcome applications
from everyone.

If you need any additional support during the
recruitment process, then please let us know.

*Directory of Social Change’s UK Guides to Company Giving 2017-26