Data Engineer/Consultant

TXP; England; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading consulting firm is seeking a Senior Data Engineer to join a complex data migration project. This hybrid role will focus on deep data analysis and migration planning using PL/SQL and Java. Ideal candidates will have public sector experience and be comfortable with databases including Oracle and MongoDB. Strong analytical skills and the ability to work independently are essential. This is a 12-month contract position with an excellent day rate inside IR35.

Qualifications

• Strong background in complex data analysis and migration projects.
• Hands-on coding experience with PL/SQL and Java.
• Solid understanding of data structures, quality, and governance.

Responsibilities

• Analyse large, complex datasets for migration readiness.
• Identify extraction rules for staged data migration.
• Develop migration logic using PL/SQL and Java.
• Handle data across Oracle, MongoDB, and AWS RDS.
• Transform XML data into JSON for migration.
• Validate data integrity post-migration.

Skills

Data analysis

Coding in PL/SQL

Java (Talend)

Data structures and governance

Experience with Oracle

AWS RDS

MongoDB

XML/JSON transformation

Job description

We are currently seeking a Senior Data Engineer/consultant to work with our public sector client

Length: 12-month contract (renewed every 6 months)

Rate: Excellent day rate inside IR35 (Inside IR35)

Location: Hybrid - 1 to 2 days per week onsite in Telford

The ideal candidates will have a proven data engineering/analysis background within public sector/government experience with the below skills and experience:

Opportunity to join a major and highly complex data migration project. The role focuses on deep data analysis, migration planning, and subsequent code development to support extraction, transformation, and load activities.

Key Responsibilities

• Analyse large, complex datasets to define scope, quality, and migration readiness.
• Identify extraction rules and sequencing for staged data migration.
• Develop migration logic using PL/SQL and Java (Talend preferred).
• Handle data across Oracle, MongoDB, and AWS RDS platforms.
• Decompress and transform XML data into JSON for migration.
• Validate data integrity and ensure accurate reconciliation post-migration.
• Produce clear technical documentation and advise on data best practices.

Skills & Experience

• Strong background in complex data analysis / migration projects.
• Hands-on coding with PL/SQL and Java (Talend advantageous).
• Solid understanding of data structures, quality, and governance.
• Experience with Oracle, AWS RDS, MongoDB, XML/JSON.
• Operates independently at SFIA 5 level - can lead, advise, and influence.