ETL Developer

  • Competitive
  • Brentwood, England, United Kingdom
  • Permanent, Full time
  • Shawbrook Bank
  • 29 Dec 16

Shawbrook is currently recruiting for an ETL developer within our IT Data Team based in Brentwood. The role will be responsible for the design and delivery of high quality systems and maintenance of existing systems. You will be working on a project-by-project basis, developing IT solutions across a range of systems and applications as designated. This role will interface with the business so building relationships is also key as well as the technical experience required.

Role Responsibilities
• Data analysis, defect identification and resolution
• Support the IT Data Manager and Head of IT to liaison with business colleagues in the areas of specification, estimation and testing of development deliverables
• Responding to allocated tickets, providing a timely and appropriate response to problems and issues across a broad range of software projects
• Resolve 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
• 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
• Ensure security and risk are the fundamental foundations for design, decision and delivery

Qualifications/Certification 
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 not a pre-requisite
 

Experience
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
ITIL or similar – working within Change & Incident frameworks

Working with financial services or other regulated environment – preferred but not essential
Data transformation from external sources

Technical Experience
• SQL Server 2008R2/2012/2016
o T-SQL
o SSIS
o SSRS
o Performance tuning & best practises
• Conceptual, logical and physical data modelling
o OLAP database design and theory
o OLTP database design and theory
• Understanding of Infrastructure Architecture
o 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

• Nice to have
o SSAS & MDX Experience
o Microsoft Excel power user, Visio
o Scripting experience (VBScript, C#, VB.Net)
o Qlikview