Data Warehouse Technical Lead - Financial Services

Recruiter
Devonshire Hayes
Location
London
Salary
65000.00 - 75000.00 GBP Annual
Posted
11 Oct 2017
Closes
13 Oct 2017
Category
IT, Internet
Function
IT
Contract Type
Permanent
Hours
Full Time

Data Warehouse Technical Lead

Permanent Opportunity

Central London

GBP65,000 - GBP75,000 Per Annum

Financial Services

Job Description

As the Data Warehouse technical lead, you will be responsible for a managing and mentoring a team of SQL developers working on MS SQL 2016 and Power BI. You will have strong technical standards and excellent communication skills to help mentor less experienced developers. Attention to detail is required to facilitate peer-review of code. This role will require strong stakeholder management as you engage with a mixture of technical and business stakeholders.

Key Responsibilities:

  • Responsible for the implementation of high quality, maintainable, enterprise-grade software solutions within the department and the technology stack
  • Work closely with Solutions Architecture to ensure that designs are practical, workable and deliverable ensuring best working practices are adopted and that the technical implementation and the architectural vision remain aligned
  • Encourage the use of 3rd party and in-house developed common components where appropriate
  • Take a leading role in assessing developments within the technological stack and offer recommendations regarding the adoption of new technologies to maintain the departments position as an early adopter of proven technologies
  • Assist with resource allocation, forward capacity planning and recruitment of staff within the technology space
  • Encourage the development of colleagues within the technology space by increasing awareness of technical events, training opportunities, through the establishment of a technology forum and through one-to-one mentoring
  • Keeping IT Management and Project Manager's updated by reporting on delivery schedules and goals through progress updates and stand up' meetings
  • Ensure that software is built to the highest standard, is built in a way that favours a simple and maintainable approach over a complex one, is tested at every step on the path to production using the appropriate tools and practices
  • Demonstrate your passion for IT by promoting good practices within your team, including any associated disciplines and functional areas
  • Develop and foster strong relationships with Business Analysts and Project Managers to ensure that the software delivered by the Software Developers maps to the requirements of the business

Essential Experience/Skills:

  • Advanced Data Warehouse development experience on SQL Server using the Kimball methodology
  • Development best practice including code reviews, unit testing, source control, and automated testing
  • Extensive ETL experience, with advanced T-SQL transformation abilities
  • Experience in Dimensional Modelling (creating facts and dimensions)
  • Experienced with SSAS/MDX and OLAP Cube design and implementation
  • Good knowledge of implementing Slowly Changing Dimensions
  • A good understanding of the Application life cycle and a solid understanding of quality assurance, database engineering and build and deployment
  • Can articulate to the business the impact of technology/design choices
  • Familiarity with testing frameworks and processes

Preferred Experience/Skills:

  • WhereScape RED Data Warehouse life cycle tool
  • Experience of interfacing warehouse schemas to BI dashboards (QlikView, PowerBI, etc)
  • Experience in SSIS development
  • Understanding of cloud and on-premises infrastructure concerns
  • An understanding of the benefits of loosely coupled applications/systems
  • Oracle environments
  • Unix/Linux environments

If you feel you have the required skills and experience for this role then please apply with a most recent version of your CV and I will be in contact to discuss further.