Data Architect

Ecclesiastical Insurance Group; Taunton; Remote; GBP 45,000 - 65,000; Full time

Job summary

A leading company in the UK is seeking a Data Architect for their Data Analysis team. This remote role involves developing and maintaining a Data Warehouse to enhance operational decision-making. With a collaborative culture that values diversity and career growth, this position also offers extensive benefits and a focus on community contribution.

Benefits

28 days annual leave plus bank holidays

Your birthday off

Health and wellbeing benefits

Enhanced sick pay and parental leave

Support for study and professional qualifications

Paid time off for volunteering

Qualifications

• Strong knowledge of data warehouse development, SQL Server, T-SQL, and SSIS.
• Organised, resourceful, and deadline-driven with good communication skills.
• Experience in the insurance industry is a plus.

Responsibilities

• Develop and maintain Data Warehouse (DWH) processes and structures.
• Monitor SQL Server tasks and ensure performance tuning.
• Achieve individual objectives and key performance indicators.

Skills

Data Warehouse Development

SQL Server

T-SQL

SSIS Development

Performance Tuning

Inquisitive

Education

Level 3 qualification in a relevant field

Job description

Social network you want to login/join with:

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