Senior Data Warehouse Developer


  • £60000 - £70000 per annum
  • Posted: 25/11/2016
  • London
  • Job Ref: 775108020
  • Permanent

Job Details

Senior Data Warehouse Developer

£70,000pa

North West London

Online Retailer

Our client is the leading online pet healthcare retailer in the UK, offering a comprehensive catalogue of pet products that range from prescription medicines to premium quality pet foods and accessories. We've acquired several competitors in the last few years and are continuing to grow at an impressive rate. In addition we've received significant investment from venture capitals, in 2013 were recognised as the 10th fastest growing digital company in Europe, we have been in the Top 100 Tech Track of the Sunday Times, and we've also been part of the Tech City Future Fifty, among other accolades. Our team is passionate about changing the face of pet healthcare in Europe, and our people are at the heart of our success. That's where you come in…

This is a fantastic opportunity for a Senior Data Warehouse Developer to join us at an exciting time and develop our capabilities, supporting us in revolutionising the way we look at insights across the company. The successful applicant will be a proactive and analytical-minded professional who has a proven track record of success within a similar position. You'll be able to demonstrate:

Comprehensive data warehouse (DW) analysis and design experience, with full knowledge of data warehouse methodologies and data modelling

Proven experience with Microsoft SQL Server 2012 including developing stored procedure based ETL, enterprise class SSIS, and proficiency with SSDT

Proven experience in providing CDC and MDM solutions with SQL server standard edition

Proven experience with building and deploying SSIS solutions with comprehensive error handling and auditing

Proven experience designing DW architecture for use with Tableau server

Proven experience with report writing, technical requirements analysis, business process modelling/mapping, methodology development, and data modelling

Strong understanding of relational database structures, principles and practices mainly with MS SQL Server; experience with MySQL also beneficial

Hands-on knowledge of enterprise repository tools, data modelling tools, data mapping tools, and data profiling tools

Experience with business requirements analysis, entity relationship planning, database design (both 3NF & Dimensional), reporting structures, and so on

Significant technical architect experience with the MS BI technology stack

Thorough and up to date understanding of IT development approaches, tools and techniques

Excellent client/user interaction skills to determine requirements

Experience with developing and maintaining technical documentation; process documentation

Experience in multi-channel retail and e-commerce would be highly beneficial

We currently have a well established Data Warehouse that is core to our Sales, Operations and Business Development teams. In addition the Data Warehouse is a profit centre for the company as we market a suite of dashboards providing customer and market insight to our large suppliers.

They are based a few minutes' walk from Dollis Hill on the Jubilee line (London), are a dress-down environment, and foster a supportive & friendly working culture. We offer a competitive salary, bonus and benefits plus excellent opportunities for professional and personal development.

Only successful candidates will be contacted, REC CONS