Location: Sheffield
ContractType: Permanent
Hours: Full time
Salary: £45,000 - £60,000 p/a depending on experience

The Data Migration Specialist 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: Accounts / financial data, Matter / case data, Contacts, 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: Support migration data preparation and cleansing, Provide auditability and reconciliation reporting, 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: Data mapping and transformation rules, Migration processes and runbooks, Data validation and reconciliation procedures

Skills & Experience Required

• 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.

Joining etiCloud isn’t just about the job, it’s so much more. We want you to forge a successful and rewarding career in the IT industry. You’ll be supported every step of the way in a friendly, professional environment where you and your future matter.

Here’s a quick overview of what you can expect when you become part of our team:

• Competitive salary with regular reviews to reward your progress
• Annual company bonus recognising your hard work
• Career development through ongoing training, support, and progression opportunities
• 28 days’ annual leave
• Company pension scheme to support your future
• Supportive, friendly team with a down-to-earth culture
• Health & wellbeing benefits, including private medical insurance, health cash plan, and mental health support
• Modern, secure Sheffield office with kitchen facilities and a coffee machine
• Weekly fresh fruit as part of our wellbeing initiatives
• Free onsite parking

Apply now and take your next step in the world of tech with etiCloud!

You may also have experience in the following: Data Migration Specialist, Data Migration Consultant, ETL Developer, Data Engineer, SQL Developer, Database Migration Consultant, Technical Implementation Consultant, Data Integration Specialist, Systems Integration Engineer, Data Warehouse Developer, Migration Engineer, Data Conversion Specialist, Application Data Consultant, Legal Tech Data Specialist, SaaS Implementation Data Consultant

REF-224 949