Data Architect

Ecclesiastical Insurance Group; South Ockendon; Remote; GBP 45,000 - 60,000; Full time

Job summary

A leading company is seeking a Data Architect to enhance their Data Analysis team. With a focus on developing and maintaining a Data Warehouse, you will play a crucial role in leveraging data to support operational decisions. The role offers a collaborative culture and great opportunities for career growth.

Benefits

28 days annual leave plus bank holidays

Your birthday off

Health and wellbeing benefits

Enhanced sick pay and parental leave

Support for professional qualifications

Qualifications

• Strong knowledge of data warehouse development, SQL Server, T-SQL, and SSIS.
• Inquisitive and prepared to investigate data anomalies.
• Organised, resourceful, and deadline-driven.

Responsibilities

• Develop, populate, and maintain a Data Warehouse.
• Create and modify DWH objects and ETL processes.
• Monitor automated tasks in SQL Server and escalate issues.

Skills

SQL Server

Data Warehouse Development

T-SQL

SSIS

ETL Processes

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