Data Migrations Consultant

Data Migrations Consultant

Department: Operations

Employment Type: Permanent - Full Time

Location: London - Paddington

Description We are seeking a skilled Data Migration Consultant to support the extraction, transformation, and loading (ETL) of data between relational database systems. The ideal candidate will have strong SQL skills and a solid understanding of relational database structures. You will be responsible for writing and executing SQL scripts to extract data, performing transformations according to business rules, and loading the data into target systems.

While not required, knowledge of double-entry accounting or financial data structures would be considered a strong asset.

Key Responsibilities

• Analyze source data structures and understand data relationships in various relational database systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL, Firebird, .Net, Delphi).
• Design and write SQL scripts and ETL processes to extract data from source systems.
• Apply transformation logic to conform data to the schema and requirements of the target system.
• Validate and reconcile migrated data to ensure accuracy, completeness, and compliance with data migration specifications.
• Work collaboratively with project managers, developers, and business analysts to gather requirements and deliver high-quality migration solutions.
• Assist with mapping documentation, data profiling, and data cleansing as required.
• Troubleshoot migration issues and perform root cause analysis.
• Maintain detailed technical documentation of migration processes and scripts.

Skills, Knowledge & Expertise

• Proven experience in data migration or ETL roles involving relational databases.
• Strong SQL scripting skills across one or more RDBMS platforms.
• Familiarity with relational database concepts, data normalization, and data integrity principles.
• Experience with data transformation and reconciliation techniques.
• Ability to analyze complex datasets and business rules.
• Excellent attention to detail and problem-solving skills.
• Strong communication skills, both written and verbal.

Nice to Have:

• Understanding of double-entry accounting principles or experience working with financial or accounting data.
• Experience with tools such as SSIS, Talend, Pentaho, or custom ETL scripting frameworks.
• Knowledge of writing and executing stored procedures, triggers, or database functions.
• Familiarity with source control tools and Agile methodologies.

Job Benefits At Dye & Durham we strive to be visionaries! As a leader in our field, we ensure our employees are ready for the next challenge in their journey with us by offering internal and external training opportunities. We offer competitive salaries and a whole host of benefits including healthcare, pension, company discounts, wellness programs, and paid days off to move house or volunteer for your favourite charity. Do you share our DNA?

• We ask how tomorrow can be better than today
• We are passionate about solving our customer's challenges
• Our ideas break boundaries
• We value different perspectives and encourage dialogue
• We take ownership and celebrate together