Data Consultant - ETL Projects

Applause IT Recruitment Ltd; England; Remote; GBP 46,000 - 55,000; Full time

Job summary

A recruitment agency is looking for a Data Consultant specializing in ETL projects. This remote role involves leading complex data migration initiatives for the UK public sector. Ideal candidates will possess strong ETL and SQL skills, with hands-on experience handling raw data. Enjoy competitive salary and a supportive company culture that values your contributions to improving public sector efficiency.

Benefits

Salary up to 55,000

Fully remote working

Opportunities for long-term progression

Qualifications

• Proven ETL experience in data migrations or software transitions.
• Extensive SQL skills for data transformation and manipulation.
• Ability to handle raw and inconsistent data effectively.

Responsibilities

• Lead data migration and ETL projects.
• Analyze and map legacy database schemas.
• Extract raw data from legacy systems.

Skills

Strong ETL experience

Expert-level SQL scripting

Hands-on knowledge of Oracle

Excellent communication skills

Problem-solving mindset

Proactive consulting approach

Tools

Oracle

SQL Server

PostgreSQL

ETL tools

Azure

AWS

GCP

Job description

Overview

Data Consultant - ETL Projects – UK - Remote Permanent

Up to 55,000 + Benefits

Are you a Data Consultant with a strong background in hands-on ETL development and data transformation? Are you looking to lead technically complex data migration projects that genuinely impact digital services across Local Government?

We're hiring for an experienced Data Consultant to join a growing team delivering mission-critical data migration projects. You'll be part of an expert unit supporting onboarding for a new cloud platform - working directly with raw datasets from legacy systems and transforming them into future-ready digital infrastructure.

What You'll Be Doing

• Leading data migration and ETL projects for UK public sector software implementations
• Analysing and mapping legacy database schemas (Oracle, SQL Server, Postgres)
• Extracting raw data from legacy systems, often with limited documentation
• Writing and executing SQL scripts and/or using ETL tools to build data pipelines
• Creating transformation logic and performing reconciliation and validation
• Working closely with customers and internal teams to troubleshoot and ensure smooth migrations

This role is not focused on BI or data visualisation - we're seeking someone who enjoys rolling up their sleeves with raw, inconsistent data and scripting solutions that deliver real value.

What You'll Need

• Strong ETL experience in data migrations or software transitions
• Expert-level SQL scripting for transformation and manipulation
• Hands-on knowledge of Oracle, SQL Server, or PostgreSQL
• Excellent communication skills for working with technical and non-technical stakeholders
• Problem-solving mindset when facing incomplete or messy data
• A consulting approach - proactive, collaborative, and detail-driven

Nice to Have

• Experience with UK Local Government datasets or public sector systems
• Familiarity with cloud platforms (Azure, AWS, GCP)
• Knowledge of spatial data tools (ArcGIS, QGIS)
• Experience with document management systems and data validation processes

What's in it for You?

• Salary up to 55,000 depending on experience
• Fully remote working
• Join a mission-driven business improving public sector efficiency
• Inclusive and supportive company culture with global reach
• Opportunities for long-term progression and real-world impact

If you're a hands-on Data Consultant ready to shape the future of Local Government software, click apply now to learn more and start your application.