-
Location
London, United Kingdom
-
Sector:
-
Job type:
-
Consultant:
-
Job ref:
9169
-
Email:
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