Back

Lead Data Warehouse Developer, SQL, T-SQL, SSRS, SSIS

City of London, £70k - £75k per annum + bonus + benefits
Permanent
Reference: RC5735

SQL, TSQL, SSIS, SSRS, Power BI, AGILE, data lakes and big data


Lead Data Warehouse Developer required by highly buoyant and ever expanding financial services organisation based in the City of London. This role will see you leading the development, support and maintainence of BI solutions in line with the Company's architectural vision, and in accordance with departmental project standards and practices. The purpose of the team being to provide the business users with insight.

 

Key Responsibilities:

  • To develop high-quality bespoke financial data warehousing solutions using appropriate, industry-standard tools, technologies and languages. Aligned to the organizational target architecture and data strategy
  • To ensure that high-quality documentation is developed, maintained, regularly reviewed and stored for all solutions developed
  • To perform peer reviews of solutions and documentation in order to ensure that procedures and standards are followed consistently. Continuously work towards the objective of building in quality and provide appropriately tested solutions
  • To contribute to the improvement of the code base, and project and development processes
  • To act as second and third-line support in undertaking tasks assigned via Service Desk
  • Actively participate, contribute and mentor others to adopt Agile practices
  • Take a proactive role within the team to support the development of colleagues. Where necessary providing task monitoring and coaching of other team members
  • Release and Deployment: Preparation of all release content and documentation, ensuring it is fit for purpose when required. Take an active role in continually improving deployment capability and maximising deployment reliability and quality in all environments
  • Technical leadership: To take the Technical Lead role on projects where required, as well as working with Solution Architects and Team Managers to deliver solutions


Key Requirements:

  • Demonstrable skills in Data warehousing, Data Lake and Big Data solutions
  • Good understanding of SQL Server technologies (T-SQL, SSIS, SSRS, Power BI)
  • Good understanding of automated testing and continuous integration using Microsoft Release Manager
  • Demonstrable skills in database concepts, object and Datamodelling techniques and design principles
  • Translate object and data models into appropriate database schemas within design constraints
  • Demonstrable experience within Microsoft applications and platforms
  • A team player to proactively work in an Agile project environment
  • Mentoring and coaching skills
  • An aptitude for data solutions and the ability to understand and manage complex concepts
  • A willingness to learn new skills and adopt to new technologies
  • Good communication skills, verbal and written and knowing when to use them
  • A Financial Services background


For a full consultation on this role please email your CV to Rebecca or call Arc IT.

Apply Now