Data Engineer

Overview

Akkodis is launching a new technical delivery team to drive a UK national program in collaboration with key partners, designed to transform and future-proof the central government’s workforce. By leveraging cutting-edge technology, strategic partnerships, and a comprehensive SaaS-based platform, this program will create an advanced, candidate-centric experience tailored to meet tomorrow’s public sector skill demands.

This high-impact initiative offers a unique opportunity to join a team dedicated to building a scalable, data-driven recruitment ecosystem. Through redesigning, building, and rolling out a sophisticated Big Data system, our diverse roles span across architecture, project management, data analytics, development, and technical support, giving you the chance to shape a dynamic, next-gen digital infrastructure.

You’ll be integral to our mission of crafting a seamless, powerful platform that empowers the public sector with the talent to navigate an evolving digital landscape.

Role

As part of this mission, the Data Engineer role focuses on the planning, execution, and management of data migration projects. Data Engineer are responsible for transferring data from legacy systems to new platforms, ensuring accuracy, consistency, and adherence to data integrity standards.

Analyse existing data structures and understand business requirements for data migration.

Design and implement robust data migration strategies.

Develop scripts and processes to automate data extraction, transformation, and loading (ETL) processes.

Work closely with stakeholders, including business users and IT teams, to ensure data requirements are met, and migrations proceed without disruption to business operations.

Responsibilities

• Plan, coordinate, and execute data migration projects within set timelines.
• Design and build ETL solutions, ensuring data quality and integrity throughout the migration process.
• Troubleshoot and resolve data-related issues promptly to minimise disruption.
• Collaborate with various teams to align migration processes with organisational goals and regulatory standards.
• Proficiency in AWS ETL technologies, including Glue, Data Sync, DMS, Step Functions, Redshift, DynamoDB, Athena, Lambda, RDS, EC2 and S3 Datalake, CloudWatch for building and optimizing ETL pipelines and data migration workflows.
• Working knowledge of Azure data engineering tools, including ADF (Azure Data Factory), Azure DB, Azure Synapse, Azure Data lake and Azure Monitor providing added flexibility for diverse migration and integration projects.
• Prior experience with tools such as MuleSoft, Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation.
• Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema).
• Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise in IAM, KMS, and RBAC implementation.
• Cloud automation and orchestration tools like Terraform and Airflow.
• Strong analytical skills to assess data quality, identify inconsistencies, and troubleshoot data migration issues.
• Understanding of database management systems (SQL Server, Oracle, MySQL and NoSQL) and SQL query optimisation.
• Ability to plan and execute data migration projects, manage timelines, and coordinate with stakeholders.
• Precision in handling large volumes of data and ensuring accuracy during migration processes.
• Effective communication skills to convey technical concepts and updates to diverse audiences, including non-technical stakeholders.
• Cloud certifications like AWS and Azure are preferred.

Required Experience

• Experience working with ETL tools and database management systems.
• Familiarity with data integrity and compliance standards relevant to data migration.

Required Education

Bachelor’s degree in Information Technology, Computer Science, Data Science, or a related field.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Engineering and Consulting
• Industries
• IT Services and IT Consulting, IT System Data Services, and Engineering Services

#J-18808-Ljbffr