Data Services Team Lead

Wescot Credit Services Limited are seeking a Data Services Team Lead. You will be responsible for ensuring the development of both staff and technology in a fast-paced environment.

Working within the IT function, the Data Services Lead will manage a small team responsible for the extraction, transformation and loads of data for the company, and the support/management of the company’s Data Warehouse. We primarily work with Microsoft SSIS (various versions) and SAP Data Services 3.1. We also utilise custom load programs built in C# as well as application native loads in C&R Debt Manager.

As lead for the team, you will ensure service across both BAU and program work as we complete a major core system migration. There will be opportunities to help shape the technology in the supporting ETL infrastructure.

Hours per week: 35

Hybrid role: We don't require you to work from an office weekly, we solely ask for you to be flexible in your approach to office working, travelling to the Hull office as and when required.

Reporting to: UK Head of IT Solutions

• Breaking down business specification into its simplest elements and translating this logic into an efficient technical design.
• Devising possible solutions to anticipated problems.
• Combining all elements of the technical design and progression through build to testing and execution.
• Reacting to problems and correcting the design as necessary.
• Evaluating and increasing the business process and technical designs’ effectiveness.
• Adapting the design to new requirements, as necessary.
• Writing detailed documentation for the client and internal operations.

• Line management and personal development of a team of highly skilled data developers.
• Overseeing the technical delivery of multiple complex development projects involving multiple complex data sources, from design through to release.
• Estimating resource requirements from work requests and providing updates to delivery teams.
• Working closely with Project Managers and Business Analysts to produce accurate delivery estimates and helping ensure the transition from analysis through to design and delivery.
• Understanding and reporting the impact of change on design and delivery plans.
• Provide regular and effective progress updates to and work closely with Project Managers/Senior Management to ensure the management of any delivery risks or issues.
• Participate in reviews and meetings and provide updates on project progress.
• Take responsibility for ensuring that risks and issues are identified and managed.
• Supporting project resource scheduling and department capacity planning.

• Experienced developer with extensive knowledge of using disparate data sources.
• Able to assist in the ongoing design of technical best practice for the development of data movement, data cleansing, data quality, data governance and other ETL/ELT related activities.
• Experience in data modelling etc. with a knowledge modern data design.
• Extensive knowledge of SSIS/SSRS/SSAS or similar technology.
• Some knowledge of C#/VB, ideally having built CLR code or custom SSIS components.
• Exposure to REST/SOAP Web Services.
• Experience in troubleshooting, performance tuning and optimisation of ETL packages.
• Very strong SQL skills; queries, stored procedures, window functions etc.
• Good knowledge of data quality and cleansing techniques to ensure and maintain data integrity.
• Experience in the use of Azure Dev Ops or similar source control technologies.
• Strong communication and documentation skills.
• Understanding of Waterfall and Agile development methodologies.
• Experience of mentoring/coaching junior staff.

• An understanding of the C&R Debt Manager platform will be highly advantageous
• Educated to degree level in an IT related discipline
• Financial Services experience
• Automated Unit Testing (MS Test/Nunit/Xunit)
• XML
• JSON
• SAP ETL
• Power Query/Power Data/Power BI
• Event Sourcing

• Discretionary annual bonus scheme
• 10% employer pension contribution
• 4 x salary life insurance
• Health cover
• Annual leave scheme that grows with length of service
• Access to our Employee Assistance Programme
• Access to eyecare voucher and cycle to work schemes
• Disco…