workable
Data Migration Specialist
LEAP Legal Software
Remote, USA
Full-time
Mid
Remote
USD 85000-100000 yearly / year
Discovered 1 months ago
PythonPowerShellCSVVLOOKUPXLOOKUP
Key Skills for This Role
PythonPowerShellCSVVLOOKUPXLOOKUP
Full Job Posting
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.
About LEAP Legal Software
Software & SaaS808 employeesFounded 1992
Private Australian LegalTech company providing practice-management, document-automation, accounting, billing, and AI software to law firms.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at LEAP Legal Software
Software Engineer - AI Legal Risk Systems
Sydney, AUS
Discovered TodayFull-time
L2 Helpdesk Technician
Three Rivers, USA
Discovered 3 days agoFull-time
Help Desk Technician
Jersey City, USA
Discovered 3 days agoFull-time
Personal Injury Content Lead
Toronto, CAN
Discovered 3 days agoFull-time
Legal Editor (By Lawyers Role)
Toronto, CAN
Discovered 5 days ago
Customer Success Consultant (Legal Tech)
Nottingham, GBR
Discovered 5 days agoFull-time
Customer Success Manager (Legal Tech)
Manchester, GBR
Discovered 6 days agoFull-time
Web Developer
Toronto, CAN
Discovered 1 weeks agoFull-time