Overview
In this role you own complex data migrations for law firms, combining SQL-driven analysis, ETL, and data validation to move from legacy systems to cloud-based platforms like Actionstep. You’ll work across multiple client projects, shaping migration standards and tooling. You solve challenging data problems, ensure accuracy, and collaborate with cross-functional teams to deliver go-lives. This is a hands-on, impact-driven position with room to influence migration processes and the wider data capability.
Pay / Benefits
- Fully remote, UK-based
- Competitive salary DOE
- Evening/weekend go-live flexibility with time off in lieu
- Supportive, collaborative tech environment
- Autonomy to own migrations
- Varied, technically challenging projects
Responsibilities
- Analyze legacy databases, schemas, and complex data structures
- Extract, transform, map, and migrate data to cloud platforms (primarily Actionstep)
- Develop and improve SQL scripts, ETL routines, and migration utilities
- Profile data, identify inconsistencies, and define cleansing requirements
- Manage trial migrations, UAT, and production cutovers
- Validate migrated data and reconcile financial datasets
- Investigate and resolve migration defects and technical challenges
- Coordinate migration activities across concurrent client projects
- Produce migration specifications, mapping docs, and validation reports
- Contribute to process improvements, tooling, and documentation
- Support occasional out-of-hours go-lives with time off in lieu
Key requirements
- Strong hands-on SQL and relational database knowledge
- Proven data migration experience between business-critical systems
- Experience in ETL, data mapping, and data transformation
- Ability to interpret unfamiliar schemas and undocumented legacy structures
- Experience managing migration across multiple projects or workstreams
- Excellent troubleshooting, analytical, and data reconciliation skills
- Independent worker with ability to meet deadlines and resolve issues
- Practical understanding of data protection and secure handling of sensitive data
- problem-solving
- analytical thinking
- independence
- SQL and relational databases
- ETL principles and data mapping
- Data cleansing and validation
…
