Data Architect

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

Job summary

A prominent financial services Group is seeking a skilled Data Architect for a remote role within their Data Analysis team. The successful candidate will work on developing a Data Warehouse to enhance operational decision-making. This opportunity promotes personal growth within a socially responsible organization that values inclusivity.

Benefits

28 days annual leave plus bank holidays

Your birthday off

Group Personal Pension

Bonus scheme

Holiday buy scheme

Health and wellbeing benefits

Enhanced sick pay

Support for professional qualifications

Paid time off for volunteering

Qualifications

• Strong knowledge of data warehouse development and SQL Server.
• Experience with ETL processes and performance tuning.
• Ability to monitor and investigate data anomalies.

Responsibilities

• Develop, populate, and maintain a Data Warehouse (DWH).
• Create and modify DWH objects such as tables and views.
• Conduct performance tuning of the DWH for efficient data consumption.

Skills

Data Warehouse Development

SQL Server

T-SQL

SSIS Development

Education

Level 3 qualified 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.

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 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
• 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 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 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