Database Developer

Job Specification: Database Developer / Administrator (grow into Data Architect)

Key Purpose

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.

Responsibilities

• Achieve individual objectives and key performance indicators as set and agreed

• 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

• Maintain own technical competence with in-depth knowledge sufficient to fulfil the role

Skills & Behaviours

• Demonstrate our values of Fun, Supportive, Professional, Working in Partnership and Ambitious

• Knowledge in data warehouse development

• Strong knowledge of SQL Server, the T-SQL dialect

• Understanding of 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 with great attention to detail

• Flexible, pragmatic, and approachable

• Highly focused on project delivery within agreed timescales

Qualifications& Experience

• Level 3 qualified in a relevant field

• Experience in / knowledge of the insurance industry