Purpose of Job:

To administer, support, amend and create ETL processes to load client data into the Data Warehouse or any other appropriate structure
To schedule, monitoring and auditing of the current and future ETL processes
Aid Design of Data Warehouse solutions for existing and new requirements
Work with the Analytics Team & IT to create Data Warehousing Standards and Guidelines
Work with Analytics team and Business to understand and fix performance issues with end user reports or ETL processes

Education, Skills and Experience

· Ideally computer sciences or technology related degree, but not essential if relevant prior experience

· Insurance sector experience essential

· Understanding of KPIs particularly for performance management

· 5 Years + T-SQL experience

· 3 years + Experience in SSIS, SSRS and SSAS

· MS SQL Server 2012 and up essential

· Experience of Partitioning and Indexing for Multidimensional Schemas important

· Experience of Data Warehousing using Kimball methodology / Star Schema

· Worked within the AGILE methodology

· The ability to use and support the Microsoft office suite of products to create and edit documents, spreadsheets, emails.

· Experience of designing logical and innovative solutions to complex problems within Analytics to aid business performance

ETL/DW Developer