Warning
This job advert has expired and applications have closed.
ETL Developer
| Posting date: | 02 June 2025 |
|---|---|
| Salary: | £42,861 to £44,439 per year |
| Hours: | Full time |
| Closing date: | 09 June 2025 |
| Location: | London, London, N1 1XR |
| Company: | Islington Council |
| Job type: | Permanent |
| Job reference: | 56847666 |
Summary
About The Role
About The Role
This is an excellent opportunity for an experienced ETL Developer to join the Project team here at Islington Council, for a Fixed Term of 12 months starting June 2025. We are in the process of implementing a new ERP - Technology One's OneCouncil SaaS+ solution, and this role is pivotal in helping us to deliver a successful go-live for April 2026.
This position will focus on the critical elements of Data Migration and Interfacing. Your primary responsibility is to facilitate the data migration process in line with the Data Migration strategy. This will require understanding of data extraction, transformation processes (predominantly via Excel templates), and using the import functionality within the OneCouncil solution to import with validation sign-off. You may also get involved with interface/process mapping throughout the project if required. Your expertise in coordinating closely with project managers, IT specialists, and business stakeholders will be pivotal in facilitating a smooth transition, minimising disruptions, and maximizing the benefits of the new finance system.
Key Responsibilities
- Developing full understanding of the OneCouncil data templates and import process.
- Working with functional stakeholders to determine data requirements/validation in accordance with the solution specification and data migration strategy.
- Prepare transformational and mapping requirements within the templates (Excel).
- Action data migration testing
- Action data migration at Go Live
- Manage the data validation processes throughout UAT and Go Live
- Assist with the data archiving activities required
- Assist with interfacing activities as and when required
What we're looking for
A technical data related qualification with a background in data administration is fundamental. Advanced skill set with Excel is vital and any experience with Oracle SQL is favourable. Any experience in any large scale, data migration activities, especially relating to finance systems, will also be favourable. A more detailed listed of requirements can be found within the Job Description.
Here you’ll be welcomed. We champion diversity and we understand the importance of our people representing the communities and customers we serve. You’ll find an inclusive environment where you can be yourself and where everyone is driven by the same purpose – For a more equal future at Islington.
Please Note: This is a hybrid role, predominantly working from home, but there may be exceptions where attendance on site is required.
For further information or for an informal conversation about the post, please contact:
George Langer | Strategic Finance Manager - Systems & Banking
george.langer@islington.gov.uk
Working for our organisation
Islington is a place rich with diversity and culture. As a council our sense of purpose couldn’t be clearer: we serve. It’s in the logo. We are committed to challenging inequality in the borough and as one of the largest employers we know that to look after the place and the planet, we have to look after our people. Together we can change the future.
We are determined to create a more equal Islington, where everyone who lives here has an equal chance to thrive.
To do this, everyone who works at Islington Council lives by a set of values which guide us in everything that we do: collaborative, ambitious, resourceful, and empowering. They spell out ‘CARE’, which is what we think public service is all about.
Our offer to you
We are committed to challenging inequality in the borough and as one of the largest employers we know that to look after the place and the planet, we have to look after our people. Our staff benefits include:
- Up to 31 days leave per year, increasing to 36 days after five years of local government service
- A range of flexible working arrangements to maintain a healthy work-life balance, as well as a 35-hour working week
- Learning and development opportunities to maximise your potential
- Competitive pay and a commitment to paying all staff the London Living Wage at minimum
- Excellent local government pension scheme
- Cycle to Work scheme and discounted gym memberships
- Local discounts from restaurants, shops, health and beauty therapists, and more!
Please note: Priority will be given to those at risk of redundancy within Islington Council. Current employees who are part of the redeployment pool must meet the essential criteria for shortlisting to be prioritised.
Workforce Equality, Equity, Diversity and Inclusion Statement
We are dedicated to creating an inclusive and equitable workforce, where everyone is treated with dignity and respect. Our workforce strategy places equality, equity, diversity, and inclusion at the heart of everything we do, reaffirming our commitment to fostering a culture of inclusion. We strive to create an environment where all colleagues feel they belong and can safely express their thoughts, ideas, and challenges, without fear of judgement or discrimination.
We maintain a zero-tolerance approach to any unlawful discrimination, harassment, or victimisation on the grounds of any protected characteristics under the 2010 Equality Act, including but not limited to race, disability, sexual orientation, sex, religion and belief, age, gender reassignment, marriage and civil partnership, pregnancy, and maternity. Any incidents of discrimination will be promptly investigated and addressed in line with our HR policies to ensure a safe and inclusive environment for all colleagues.
We use data to identify and address disparities, ensuring that our policies and practices are transparent and impactful in promoting a diverse representation of backgrounds and perspectives at all levels of the organisation. We look at inequality through an intersectional lens, recognising that different aspects of someone’s identity can combine to create unique experiences of discrimination and disadvantage.
We know that advancing diversity and inclusion is a continuous journey, and we must listen to our colleagues and learn where we can further improve. We work closely with our Colleague Forums and Trade Unions, supported by active allies from our Corporate Management Team, to monitor and evaluate our practices, identify barriers, and empower colleagues to promote equality and inclusion in the workplace.
Every one of us has a role to play in making Islington Council a truly inclusive workplace. By living out our CARE (collaborative, ambitious, resourceful, and empowering) values every day and embedding the principles of equality, equity, diversity, and inclusion in our work, we can all actively contribute to empowering people and creating a more equal Islington.
Safeguarding
We are committed to safeguarding and promoting the welfare of children, young people and vulnerable adults, and expects all staff, and volunteers to share this commitment. Some posts are subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service.
The post is subject to a qualifications check and 3/5 years referencing.
Disability Confident Scheme
Islington Council operates a guaranteed interview scheme for candidates with disabilities who meet the minimum criteria and we are committed to providing support to applicants who request reasonable adjustments to be made during the recruitment process and throughout their career with us.
About The Role
This is an excellent opportunity for an experienced ETL Developer to join the Project team here at Islington Council, for a Fixed Term of 12 months starting June 2025. We are in the process of implementing a new ERP - Technology One's OneCouncil SaaS+ solution, and this role is pivotal in helping us to deliver a successful go-live for April 2026.
This position will focus on the critical elements of Data Migration and Interfacing. Your primary responsibility is to facilitate the data migration process in line with the Data Migration strategy. This will require understanding of data extraction, transformation processes (predominantly via Excel templates), and using the import functionality within the OneCouncil solution to import with validation sign-off. You may also get involved with interface/process mapping throughout the project if required. Your expertise in coordinating closely with project managers, IT specialists, and business stakeholders will be pivotal in facilitating a smooth transition, minimising disruptions, and maximizing the benefits of the new finance system.
Key Responsibilities
- Developing full understanding of the OneCouncil data templates and import process.
- Working with functional stakeholders to determine data requirements/validation in accordance with the solution specification and data migration strategy.
- Prepare transformational and mapping requirements within the templates (Excel).
- Action data migration testing
- Action data migration at Go Live
- Manage the data validation processes throughout UAT and Go Live
- Assist with the data archiving activities required
- Assist with interfacing activities as and when required
What we're looking for
A technical data related qualification with a background in data administration is fundamental. Advanced skill set with Excel is vital and any experience with Oracle SQL is favourable. Any experience in any large scale, data migration activities, especially relating to finance systems, will also be favourable. A more detailed listed of requirements can be found within the Job Description.
Here you’ll be welcomed. We champion diversity and we understand the importance of our people representing the communities and customers we serve. You’ll find an inclusive environment where you can be yourself and where everyone is driven by the same purpose – For a more equal future at Islington.
Please Note: This is a hybrid role, predominantly working from home, but there may be exceptions where attendance on site is required.
For further information or for an informal conversation about the post, please contact:
George Langer | Strategic Finance Manager - Systems & Banking
george.langer@islington.gov.uk
Working for our organisation
Islington is a place rich with diversity and culture. As a council our sense of purpose couldn’t be clearer: we serve. It’s in the logo. We are committed to challenging inequality in the borough and as one of the largest employers we know that to look after the place and the planet, we have to look after our people. Together we can change the future.
We are determined to create a more equal Islington, where everyone who lives here has an equal chance to thrive.
To do this, everyone who works at Islington Council lives by a set of values which guide us in everything that we do: collaborative, ambitious, resourceful, and empowering. They spell out ‘CARE’, which is what we think public service is all about.
Our offer to you
We are committed to challenging inequality in the borough and as one of the largest employers we know that to look after the place and the planet, we have to look after our people. Our staff benefits include:
- Up to 31 days leave per year, increasing to 36 days after five years of local government service
- A range of flexible working arrangements to maintain a healthy work-life balance, as well as a 35-hour working week
- Learning and development opportunities to maximise your potential
- Competitive pay and a commitment to paying all staff the London Living Wage at minimum
- Excellent local government pension scheme
- Cycle to Work scheme and discounted gym memberships
- Local discounts from restaurants, shops, health and beauty therapists, and more!
Please note: Priority will be given to those at risk of redundancy within Islington Council. Current employees who are part of the redeployment pool must meet the essential criteria for shortlisting to be prioritised.
Workforce Equality, Equity, Diversity and Inclusion Statement
We are dedicated to creating an inclusive and equitable workforce, where everyone is treated with dignity and respect. Our workforce strategy places equality, equity, diversity, and inclusion at the heart of everything we do, reaffirming our commitment to fostering a culture of inclusion. We strive to create an environment where all colleagues feel they belong and can safely express their thoughts, ideas, and challenges, without fear of judgement or discrimination.
We maintain a zero-tolerance approach to any unlawful discrimination, harassment, or victimisation on the grounds of any protected characteristics under the 2010 Equality Act, including but not limited to race, disability, sexual orientation, sex, religion and belief, age, gender reassignment, marriage and civil partnership, pregnancy, and maternity. Any incidents of discrimination will be promptly investigated and addressed in line with our HR policies to ensure a safe and inclusive environment for all colleagues.
We use data to identify and address disparities, ensuring that our policies and practices are transparent and impactful in promoting a diverse representation of backgrounds and perspectives at all levels of the organisation. We look at inequality through an intersectional lens, recognising that different aspects of someone’s identity can combine to create unique experiences of discrimination and disadvantage.
We know that advancing diversity and inclusion is a continuous journey, and we must listen to our colleagues and learn where we can further improve. We work closely with our Colleague Forums and Trade Unions, supported by active allies from our Corporate Management Team, to monitor and evaluate our practices, identify barriers, and empower colleagues to promote equality and inclusion in the workplace.
Every one of us has a role to play in making Islington Council a truly inclusive workplace. By living out our CARE (collaborative, ambitious, resourceful, and empowering) values every day and embedding the principles of equality, equity, diversity, and inclusion in our work, we can all actively contribute to empowering people and creating a more equal Islington.
Safeguarding
We are committed to safeguarding and promoting the welfare of children, young people and vulnerable adults, and expects all staff, and volunteers to share this commitment. Some posts are subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service.
The post is subject to a qualifications check and 3/5 years referencing.
Disability Confident Scheme
Islington Council operates a guaranteed interview scheme for candidates with disabilities who meet the minimum criteria and we are committed to providing support to applicants who request reasonable adjustments to be made during the recruitment process and throughout their career with us.
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident.