Data Migration Engineer, West Midlands

Axiom Software Solutions; Telford; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

A tech solutions company based in Telford is seeking a Data Migration Engineer to lead and execute data migration projects. The ideal candidate will be responsible for planning, designing, and implementing migration strategies for large datasets, ensuring data integrity and compliance with GDPR. A robust understanding of ETL processes, cloud environments, and database management systems is essential. This role operates in a hybrid setup, requiring attendance at the Telford office two days a week.

Qualifications

• Experience leading data migration projects with end-to-end responsibility.
• Proficiency in cloud platforms and ETL tools.
• Strong understanding of data governance and compliance.

Responsibilities

• Lead data migration from various sources ensuring data integrity.
• Design ETL processes and optimize performance.
• Collaborate with teams to address migration requirements.

Skills

Data migration project management

Data integrity

Data transformation

SQL

ETL processes

Cloud platforms (AWS)

Tools

AWS Glue

SQL Server

Oracle

MySQL

PostgreSQL

Job description

Data Migration Engineer

Job Role : Data Migration Engineer

Role Type : Permanent

Location : Telford, UK

Hybrid 2 days work from Telford office

Job Description

Lead end-to-end data migration projects, including planning, mapping, extraction, transformation, loading, and validation.

Design and implement data migration strategies to migrate large volumes of structured and unstructured data across various environments (cloud, on-premises, hybrid).

Collaborate with cross-functional teams, including data architects, business analysts, and developers, to gather migration requirements and align data migration processes with business objectives.

Ensure data integrity, security, and compliance during migration, adhering to GDPR and other data protection regulations.

Develop ETL pipelines using tools like AWS Glue, or similar technologies to automate data migration processes.

Optimize data migration performance through efficient data transformation, filtering, and mapping techniques.

Monitor data migration progress and resolve issues related to data quality, schema mismatches, or system compatibility.

Create and maintain detailed documentation, including migration plans, data mapping, transformation rules, and post-migration validation reports.

Conduct data validation and testing post-migration to ensure successful data transfer and accuracy in target systems.

Provide technical support and troubleshooting during the migration process, ensuring minimal downtime and business disruption.

Experience with database management systems such as SQL Server, Oracle, MySQL, or PostgreSQL, and proficiency in data modeling and schema design.

Expertise in cloud platforms like AWS Cloud for cloud-to-cloud or cloud-to-on-premises data migrations.

Implement data masking, anonymization, and encryption techniques to safeguard sensitive data during migration.

Strong understanding of data governance, lineage, and auditing principles to ensure transparent and compliant data migration practices.

ETL, AWS, SQL