ETL/DW Developer

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