Data Migration Lead

The Data Migration Lead is responsible for managing and delivering high-quality data migrations from legacy Case/Practice Management Systems (CMS/PMS) into our platform. This role owns the end-to-end migration lifecycle: extraction, transformation, validation, reconciliation, and loading of data using API-led and ETL approaches.

In addition, this role will advise on and help shape an internal data warehouse that will act as the foundation for migration preparation, cleansing, auditability, and as a single source of truth for database migrations.

Key Responsibilities

· Lead the data migration workstream, including planning, scoping, mapping, cleansing, testing, and loading.

· Extract data from legacy CMS/PMS and related systems and transform datasets to meet target data models.

· Use API-based tools and integration frameworks to perform data imports, updates, and reconciliations.

· Deliver migrations across core data domains including:

o Accounts / financial data

o Matter / case data

o Contacts

o Documents and related metadata

· Identify data quality issues, perform remediation, and work closely with clients to validate migrated data.

· Execute trial migrations, delta migrations, and final production cutover loads.

· Advise on and contribute to the design and development of an internal data warehouse to:

o Support migration data preparation and cleansing

o Provide auditability and reconciliation reporting

o Act as a single source of truth for migration datasets

· Collaborate closely with the Implementation Lead and project team to align migration activities with overall delivery timelines.

· Produce and maintain clear documentation for:

o Data mapping and transformation rules

o Migration processes and runbooks

o Data validation and reconciliation procedures

Do you have experience in Data migration?, · Proven experience delivering data migrations in legal, financial, accounts, or SaaS environments.

· Strong understanding of ETL processes, data mapping, data quality, and validation techniques.

· Hands-on experience using APIs for data import/export and system integrations.

· Experience with scripting or development languages such as Python and/or C#.

· Strong SQL skills, including querying, data analysis, and validation.

· Experience working with relational databases and structured data models.

· Ability to analyse, troubleshoot, and resolve data discrepancies efficiently and methodically.

· Excellent organisational, documentation, and stakeholder communication skills.

· Understanding of data governance, auditability, and reconciliation best practices.

Desirable

· Experience working in professional services, legal tech, or enterprise SaaS implementations.

If you do not have all the above skills and experience, we would still be interested in hearing from you as we are able to provide training and development opportunities to grow within our teams, * Data migration: 5 years (required)

Pulled from the full job description

• Annual leave
• Employee discount
• Free parking
• Company pension
• Private medical insurance
• Casual dress
• Health & wellbeing programme, · Competitive salary with annual reviews

· 25 days annual leave

· Continual career development and training opportunities

· Private medical insurance and wellbeing support

· Annual bonus

· Modern Sheffield office with free parking

Apply now and take your next step in tech with etiCloud.

Job Types: Full-time, Permanent

Pay: £50,000.00-£60,000.00 per year

Benefits:

• Casual dress
• Company pension
• Cycle to work scheme
• Employee discount
• Free parking
• Health & wellbeing programme
• On-site parking
• Private medical insurance

Joining etiCloud isn't just about getting a job-it's about growing a career with one of the UK's leading cloud-based IT providers. You'll be supported every step of the way in a friendly, professional environment where your development matters. Here's what you'll get when you become part of our team