LEAP is the global leader in the development of integrated productivity solutions for law firms with offices in the United States, Canada, United Kingdom, Republic of Ireland, Australia, and New Zealand.
Law firms using LEAP software enjoy all the benefits of a state-of-the-art practice management system as well as legal accounting, document assembly and management and, uniquely, legal publishing assets, all in one integrated solution.
We are a trusted partner of more than 60,000 lawyers and their staff who rely on us to help them provide outstanding legal services and run productive, profitable law firms.
The Transitions department is responsible for extracting and transferring data from legacy systems to LEAP for clients globally. The department is not only responsible for the technical aspects but also manages client’s expectations in relation to data collection, migration and LEAP implementation.
Data Migration Specialists use the proprietary migration tools available as well as technical expertise to ensure data moving from a legacy system is properly migrated and checked prior to uploading into LEAP.
Data Migration Specialists are the product experts on our migration tools and are expected to also teach and work with our Partner Network to ensure their migrations are running smoothly.
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
Requirements
- SQL & Relational Databases: 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.
- Data Transformation & ETL: Hands-on experience with ETL methodologies and source-to-target field mapping, including script automation in Python or PowerShell.
- Data Wrangling (Excel / CSV): Expertise in Excel for fast schema validation and cleanup (nested formulas, VLOOKUP/XLOOKUP, text-to-columns).
- Legal Bookkeeping & Accounting: Working knowledge of legal trust/client and office accounting, and familiarity with legal terminology (e.g., matters, unbilled fees, disbursements, safe custody).
- Legal Practice Management Software: Experience with legal practice management systems (desirable).
- Project Management: Ability to plan, prioritise, and track conversion work through to completion.
- Attention to Detail: Exceptional eye for detail and data accuracy.
- Client Communication: Confidence liaising directly with clients on conversion status, issues, and timelines.
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
- Salary range $85-100k OTE dependent upon experience
We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age. All LEAP employees must ensure ongoing compliance with organizational security policies, standards, procedures, and control frameworks including risk management and incident management processes.
Skills Required
- Advanced proficiency with Microsoft SQL Server, including queries, joins, scripts, and stored procedures for extracting, cleaning, and mapping legacy records
- Strong understanding of relational database environments
- Hands-on experience with ETL methodologies and source-to-target field mapping
- Script automation experience using Python or PowerShell
- Expertise with Excel and CSV data wrangling, including nested formulas, VLOOKUP/XLOOKUP, text-to-columns, schema validation, and cleanup
- Working knowledge of legal trust/client and office accounting
- Familiarity with legal terminology, including matters, unbilled fees, disbursements, and safe custody
- Experience with legal practice management systems
- Ability to plan, prioritize, and track conversion work through completion
- Exceptional attention to detail and data accuracy
- Confidence communicating directly with clients about conversion status, issues, and timelines
What We Do
LEAP practice management software has grown from the belief that it should be fast and easy for legal practitioners to manage matter documents, accounting and billing, so they can focus on practicing law. Today, LEAP is the world’s largest provider of legal practice management software for small firms; with clients across the United States, United Kingdom and Australia. Firms have relied on LEAP since 1992 for innovative and powerful software to simplify their workflow. We take this responsibility seriously and dedicate millions of dollars each year to product development. It’s resulted in benefits such as a cloud-based and mobile interface. This allows teams to access their LEAP data anywhere, anytime. In addition, over 13,000 automated forms and templates are regularly updated for all areas of law, and purpose-built for the United States’ federal and state jurisdictions. We’re obsessive about evolving LEAP with feedback from clients, so the software is easy to use and allows small firms to get more work done. Our goal is to empower small firms to make more money. After all, everything LEAP does is geared toward helping the attorneys who help people. Let the LEAP team become an extension of your practice, so you can focus on what you do best. Spend more time advising on the law!
