Data Architect

Benefact Group; London; Remote; GBP 45,000 - 55,000; Full time

Job summary

A leading company in the financial services sector is seeking a Data Architect to join their Data Analysis team. This remote role involves developing and maintaining a Data Warehouse and applying strong technical skills in SQL Server and ETL processes. With strong growth ambitions, the company offers comprehensive benefits and a collaborative culture.

Benefits

28 days annual leave plus bank holidays

Birthday off

Health and wellbeing benefits

Paid time off for volunteering

Qualifications

• Strong knowledge of data warehouse development, SQL Server, T-SQL, SSIS.
• Inquisitive and prepared to challenge data anomalies.
• Highly communicative and project delivery focused.

Responsibilities

• Develop, populate, and maintain Data Warehouse.
• Create and modify Data Warehouse objects; develop ETL processes.
• Performance tuning of the Data Warehouse.

Skills

Data warehouse development

SQL Server

T-SQL

SSIS development

Education

Level 3 qualification in a relevant field

Job description

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 ofBenefact Group, are looking for a Data Architect to join our Data Analysis team. This role will be remote but the ideal candidate willbe willing to commute to the Taunton or South Ockendon officeon occasion, where required.

The ideal candidate will work alongside the wider Data Analysis team 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.

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 ofdata warehouse development, SQL Server, the T-SQL dialect andSSIS 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
• An array of health and wellbeing benefits, company cash plan, income protection and life assurance
• Enhanced sick pay andparental leave
• Support and funding toward study and professional qualifications
• Paid time off forvolunteering

Lloyd & Whyteoffer 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 Group is 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 aninclusive culture and building an environment where each and every one of usfeels valued and respected. We are a community made up of people with arange of different backgrounds, abilities, perspectives, beliefs and interestsand we value the strength this brings to us as a Group. We welcome applicationsfrom everyone.

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

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

Please note that if you are NOT a passport holder of the country for the vacancy you might need a work permit. Check our Blog for more information.

Bank or payment details should not be provided when applying for a job. Eurojobs.com is not responsible for any external website content. All applications should be made via the 'Apply now' button.

Created on 30/06/2025 by TN United Kingdom