Data Migration Specialist
About The Position
LEAP is the global leader in the development of integrated productivity solutions for law firms. The Transitions department is responsible for extracting and transferring data from legacy systems to LEAP for clients globally. Data Migration Specialists use proprietary migration tools and technical expertise to ensure data is properly migrated and checked before uploading into LEAP. They are product experts on migration tools and are expected to teach and work with the Partner Network to ensure smooth migrations. LEAP software offers law firms a state-of-the-art practice management system, legal accounting, document assembly and management, and legal publishing assets in one integrated solution. LEAP is a trusted partner to over 60,000 lawyers and their staff, helping them provide outstanding legal services and run productive, profitable law firms.
Requirements
- Advanced proficiency in MS SQL Server — writing queries, joins, scripts, and stored procedures to extract, clean, and map legacy database records; solid understanding of database environments.
- Hands-on experience with ETL methodologies and source-to-target field mapping, including script automation in Python or PowerShell.
- Expertise in Excel for fast schema validation and cleanup (nested formulas, VLOOKUP/XLOOKUP, text-to-columns).
- Working knowledge of legal trust/client and office accounting, and familiarity with legal terminology (e.g., matters, unbilled fees, disbursements, safe custody).
- Ability to plan, prioritise, and track conversion work through to completion.
- Exceptional eye for detail and data accuracy.
- Confidence liaising directly with clients on conversion status, issues, and timelines.
Nice To Haves
- Experience with legal practice management systems
Responsibilities
- Liaise with implementation coordinators to ensure they are kept up to date with the progress of the data migrations
- Timely and accurate migration of data
- Reconciliation of migrated accounting data
- Expanding and adding functionality to the transition process
- Creation and maintenance of documentation and internal systems
- Daily observations and control of projects for the Transitions Department
- Written reporting on migrated data
- QA Testing on transition software
- Ensure data sets received from client are complete and ready for migration (e.g. reports, backups)
- Run migration tools for the applicable legacy system to migrate client data to LEAP
- Check that data was successfully imported into LEAP
- Ensure time, client funds and office balances are correct and match to the legacy data cut-off
- Liaise with clients to ensure they are kept up to date with the progress of their data migration, reviewing transition reports with the client and discussing any roadblocks with their transition
- Testing fixes to bugs
- Keeping the Partner Network up to date on new improvements to the migration tools
- Assisting the Partner Network on any migrations they have questions about and ensuring they are delivering quality migrations
Benefits
- Medical, Dental and Vision Plans Available
- Remote work model
- WFH Equipment allowance (including internet costs)
- 401k with Company Matching Program
- Employee Assistance Plan
- Flexible PTO
- Company Shares Opportunity
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
