Data Engineer in Preston

Perch Group are searching for a Data Engineer. Established in 2016, Perch Group have rapidly grown to become one of the UK’s foremost debt collection groups, overseeing the financial well-being of over a million customers and assets exceeding £1 billion. Our annual mission is to empower hundreds of thousands of customers to positively engage with and resolve their outstanding debts through an empathetic and customer-centric approach that is at the heart of our success.

Perch’s comprehensive platforms offer clients a one-stop shop of market-leading, data-driven services spanning the entire debt lifecycle, including BPO services, debt collection, debt purchase, reconnection, and litigation services.

The Technical Delivery team require a Data Engineer to join their team on a permanent basis. The Data Engineer is tasked with providing technical solutions to business problems, ETL/ELT and reviewing junior team members outputs.

The ideal candidate will have good knowledge of Data Engineering skills including developing and optimising stored procedures, developing ETL/ELT processes with Azure Data Factory (ADF).

£40,000 + up to 20% of your annual salary, paid as a bonus. This role is based at our Blackpool or Manchester Spinningfields office. Please note that the successful candidate will be expected to attend the Blackpool office 3 days per week for the first month of employment, for training.

You’ll make a major contribution by:

• Using best practice and experience to create ETL/ELT processes using ADF/SQL and Azure Databricks.
• Being responsible for creating or guiding the low-level design of data solutions, taking high level solutions, and translating them into workable designs and work packages to deliver themselves or in other members of the team.
• Monitoring the quality of the overall data platform(s), ensuring that data ETL and database solutions are implemented effectively from a re-use and performance optimisation perspective.
• Developing high complexity, secure, governed, high quality, efficient data ETL from a variety of on and off premise, internal and external data sources.
• Designing and building of data observability and data quality by design into all Data ETL, promoting self-testing pipelines that proactively identify processing issues or discrepancies.
• Checking junior team members outputs, feeding back any issues.
• Able to explain complex topics to junior members of the team.
• Coaching junior members of the team around Data Engineering and the Data Development Lifecycle.
• Taking accountability for peer review, testing and deployment of junior team members’ code.

You should apply for this role if you have:

• 3 years’ designing and deploying ETL/ELT solutions with Azure Data Factory (ADF).
• 3 years’ experience with T-SQL, including Functions, CTEs, complex joins and query optimisation.
• 1 years’ experience of Azure Databricks/notebooks.
• Strong analytical and problem-solving skills.
• Strong data quality and governance skills.
• Strong teamwork, interpersonal and collaboration skills with colleagues and clients.
• Can explain technical subjects to non-technical people.
• Experience coaching junior data engineers.
• Experience checking junior data engineer’s outputs.

Preferred experience:

• Azure Data Lake / BLOB storage file structures.
• SSIS, some experience would be beneficial to migrate away from legacy packages.
• SSRS and/or PowerBi.

The Application Timeline:

• A first stage video call with the internal recruitment team (15 minute call).
• A face to face or video call with the hiring manager (30-45 minutes).
• On site technical test (up to 2 hours).

What’s In It For You:

• £40,000 + up to 20% of your annual salary, paid as a bonus.
• 37.5 hours per week. We offer flexible working hours between our core hours of 8am-6pm, Monday to Friday.
• The opportunity to complete formal qualifications and learn on the job in a successful, growing organisation.
• And many more benefits to support your wellbeing and professional development.

We’re an equal opportunity employer. All applicants will be considered for employment without attention to age, ethnicity, religion, sex, sexual orientation, gender identity, family or parental status, national origin, or veteran, neurodiversity or disability status.

Typically, the average successful applicant will be within this timeline for 2-3 weeks. Please note we will close this role once we have enough applications for the next stages therefore you should submit your application asap to avoid any disappointment. If you do not receive a response after 3 weeks of applying, please assume you have been unsuccessful as we may experience a high volume of applications.

If you have any questions or suggestions of how we can assist you in your application due to disability or personal reasons, please email.

PLEASE NOTE - As we are a financial services company, we are required to run DBS and Credit Checks on all of our successful candidates. This information MUST be disclosed at the time of your initial screening call should you be invited to interview.