Sql jobs in United Kingdom

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 DevOps 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
• Discounted gym memberships
• Hybrid working

See what your future colleagues say: https://youtu.be/fM3-_4cqZdA?si=JtQgVJNc2KGROvZf

Wescot Credit Services is a Contact Centre working with several large UK banks, as well as Credit Card Providers, Energy, Telecoms and others to help recover debts owed to them by their customers.

We are proud to announce that Encore Capital Group, which Wescot is part of, is Great Place to Work-Certified™ in Costa Rica, France, India, Portugal, the United Kingdom and the United States.

Diversity and inclusion are very important to us at Wescot and we value diverse talent within our business. We want everyone to be themselves at work and encourage a culture that includes everyone.

At Wescot we’re regulated by our clients - as such, any successful candidates will have to undergo a basic credit check and criminal background check. Please note that we’re unable to proceed to interview stage if a CCJ, IVA or Bankruptcy appears on a credit file, or if you do not have full right to work in the UK.