ETL Developer

Team: Solution Delivery

Location: Remote

Work pattern: 35 hours per week, flexible working options available

Salary: Up to £43,003.67 per year

Contract: 18 month fixed-term contract

We are the UK’s largest cat welfare charity. All over the country, our passionate employees, volunteers and supporters are using their kindness and expertise to make life better for millions of cats and the people who care for them.

Will you join us and make life better for cats?

Responsibilities of our ETL Developer:

- Designing, developing and managing the data extraction, transformation and loading processes for Cats Protection’s data warehouse

- Cleanse, transform, and validate data to meet the business requirements

- Work closely with data analysts, data architects and other stakeholders to ensure data is accurately and efficiently processed and available for BI and analytics

- Load transformed data into databases, ensuring efficient and secure storage

- Design, develop, and maintain ETL processes and workflows using ETL tools and technologies including Azure Data Factory, Azure Sync, Power Automate, and SQL

- Provide support and troubleshooting for ETL processes and data-related issues

- Participate in code reviews and provide feedback to peers to maintain code quality standards

About the Solution Delivery team:

- the team is made up of 10 employees and sits within the IT department

- the team work to identify issues and provide technical solutions

- builds internal solutions using a range of technologies, focused around the Azure stack

What we’re looking for in our ETL Developer:

- educated to bachelor degree level or holds a relevant professional qualification or a relevant IT apprenticeship at level 3

- knowledge of Azure SaaS Platform, SQL Server, MS Dynamics

- knowledge of programming languages such as SQL (T-SQL), DAX, Power Query M, Visual Studio, Azure DevOps, C#, Git

- aware of the concepts of object and data modelling, data management, databases and database management systems and techniques, the development lifecycle, and the use of information as a resource

- experience in Information Architecture

- experience in Database Software

- analytical thinker with great problem solving skills

What we can offer you:

- range of health benefits

- 25 days’ annual leave plus bank holidays, increasing with length of service

- Salary Finance, which empowers you to take control of your financial wellbeing

- and much more, which you can learn about

Application closing date: 16th April 2025

Virtual interview date: w/c 28th April onwards

Applications may close before the deadline, so please apply early to avoid disappointment. Please note, applications received after the closing date may not be responded to.

If you’re enthusiastic about this opportunity but your experience doesn’t align perfectly with every requirement, we encourage you to apply anyway and demonstrate how your experience is transferrable.  You may be just the right candidate. 

If successful, your recruitment journey will include:

1. anonymised application form

2. possible video screening

3. virtual interview

Please note, the process may change slightly dependent on application numbers. We will inform you of any relevant changes.

Please email us if you require any adjustments to be made for you to complete your application or to participate in the recruitment journey.