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 here
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:
• anonymised application form
• possible video screening
• virtual interview
Please note, the process may change slightly dependent on application numbers. We will inform you of any relevant changes.
Please email recruitment@cats.org.uk if you require any adjustments to be made for you to complete your application or to participate in the recruitment journey.
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 here
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:
• anonymised application form
• possible video screening
• virtual interview
Please note, the process may change slightly dependent on application numbers. We will inform you of any relevant changes.
Please email recruitment@cats.org.uk if you require any adjustments to be made for you to complete your application or to participate in the recruitment journey.
