Opportunity Details

Posted: 06/08/2019

SQL Developer

Location
United Kingdom, London Bishopsgate
Schedule Type
Full Time
Reference
SHAW00946
Job Family
Corporate Functions
The Role

Shawbrook is a specialist UK savings and lending bank founded in 2011 to serve the needs of SMEs and individuals in the UK with a range of lending and saving products. At 31 December 2017 our total lending reached £4.9 billion and we have now raised more than £4.4 billion in customer deposits.

We differentiate ourselves by concentrating on markets where our specialist knowledge and personalised approach to underwriting offer us a competitive advantage. This supports attractive, stable returns and sustainable growth, and also benefits businesses and consumers in parts of the market which continue to be poorly served by traditional high street banks. Fundamental to our success is a relationship focus which puts the interests of our customers and business partners at the heart of everything we do, built on a culture which stresses the use of our experience and judgement to make decisions that balance risk, return and customer needs.

Shawbrook are looking to hire a SQL Developer to be a member of the IT Data Team to assist with the design and delivery of high quality systems, processes and deliverables. Supporting effective and appropriate maintenance of existing systems and working on a project-by-project basis, developing IT solutions across a range of systems and applications as designated.

Responsibilities
  • Delivery high quality data solutions using the tools available
  • Proficient in data analysis, defect identification and resolution
  • Support IT Data Manager and Head of Innovation and Delivery to liaison with business colleagues in the areas of specification, estimation and testing of development deliverables
  • Keep up-to-date with new technologies and industry standards; seek self-development and opportunities to progress, learn new skills and maintain high quality work
  • Resolve all development tasks within the specified timeframe, reporting to the IT Data Manager if the timescale cannot be met
  • Effectively use the feedback from business users to keep the team connected to any issues before they become bigger problems. Feed and translate the feedback into development tasks to improve quality of the deliverables
  • Attend meetings as required
  • Ensure security and risk are the fundamental foundations for design, decision and delivery
  • Contribute to the continuous development of the team
  • Display great team spirit and loyalty towards colleagues whilst maintaining a high performance level
  • Documentation creation and management
  • Identifies and investigates data quality/integrity problems, determines impact and provides solutions to problems
The Person
  • Minimum of a Bachelor’s degree OR a minimum of 3 years of experience and/or training in the technical Business Intelligence field, or equivalent combination of education and experience
  • Microsoft qualifications advantageous, but certainly not pre-requisite
  • Minimum of 3 years of recent experience in querying and analysing data sources in a Microsoft environment to understand the data and determine logic for data transformations
  • Minimum of 3 years recent relevant technical experience with Microsoft data integration tools and/or EDW design and development in a Microsoft environment
  • Working with a financial services or other regulated environment
  • Regulatory reporting experience preferred
  • Medium sized IT Department (50+)
  • Data transformation from external sources
  • Planning & executing database related deployments
  • ITIL or similar – working within Change & Incident frameworks
  • Ticket management

 

 

Technical

  • SQL Server 2008R2/2012/2016
  • T-SQL
  • SSIS
  • Performance tuning & best practises
  • SSRS
  • Conceptual, logical and physical data modelling
  • OLAP database design and theory
  • OLTP database design and theory
  • Understanding of Infrastructure Architecture
  • Able to interact with technical experts in other areas of IT to ensure that underlying architecture is correct and delivered
  • Understanding of BI concepts and theory
  • Experience of supporting a UAT team

 

Nice to have

  • SSAS & MDX Experience
  • Microsoft Excel power user, Visio
  • Scripting experience (VBScript, C#, VB.Net)
  • QlikView

 

Interpersonal

  • Business analyst: ability to work with users to initiate technical solutions
  • Analytical in problem solving and decision making
  • Communication skills both written and verbal
  • Ability to work as part of a team
  • High levels of drive, energy and personal commitment to success
  • Accuracy & attention to detail
  • Establishes effective working relationships at all levels
  • Customer-focused approach and willing to champion the business
  • Good awareness of own strengths, weaknesses, and future aspirations
  • Presents a professional/business like image, credible
Banding

This role is an SB4 on Shawbrook's internal banding system