Data Services Team Lead

Wescot Credit Services Ltd; Beeford; On-site; GBP 65,000 - 95,000; Full time

Benefits offered by this job

Discretionary annual bonus

4 x salary life insurance

Health cover

Annual leave scheme

Employee Assistance Programme

Eyecare voucher

Cycle to work

Gym membership

Job summary

Wescot Credit Services Limited seeks a Data Services Team Lead to manage a team of data developers and oversee complex data integration projects from design through to release.

You will translate business specs into technical designs, devise robust ETL/ELT processes, and ensure data quality across sources. Strong SQL and BI tooling experience are essential for this role.

Qualifications

• Extensive experience with disparate data sources.
• Design data movement, cleansing, quality and governance.
• Experience in data modelling and modern data design.
• Strong SQL skills incl. procedures and window functions.
• Experience with ETL/ELT tools (SSIS/SSRS/SSAS) and data delivery.

Responsibilities

• Lead a data development team and oversee multiple projects from design to release.
• Break down business specs into technical designs and solutions.
• Manage delivery estimates and risk across projects.
• Mentor junior staff and ensure best practices.
• Document technical designs for clients and internal teams.

Skills

Data integration

SQL

Power BI

ETL/ELT

Data modelling

C#/VB

REST/SOAP

Azure DevOps

Unit testing

Education

Degree in IT/Computing

Tools

SSIS/SSRS/SSAS

Azure DevOps

Power BI

SAP ETL

Job description

Data Services Team Lead Wescot Credit Services Limited

Pay Range This range is provided by Wescot Credit Services Limited. Your actual pay will be based on your skills and experience.

Technical Responsibilities

• 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 progressing 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.

As a Lead

• 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.


• Providing regular and effective progress updates to and working closely with Project Managers/Senior Management to ensure the management of any delivery risks or issues.


• Participating in reviews and meetings and providing updates on project progress.


• Taking responsibility for ensuring that risks and issues are identified and managed.


• Supporting project resource scheduling and department capacity planning.

Position Requirements

• 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 and 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 in 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.


• Automated Unit Testing (MS Test/Nunit/Xunit).


• XML.


• JSON.


• SAP ETL.


• Power Query/Power Data/Power BI.


• Event Sourcing.

Benefits

• Discretionary annual bonus scheme.


• 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.

Diversity & Inclusion

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.

Seniority Level

Mid-Senior level

Employment Type

Full-time

Job Function

Information Technology