{bc}
workable

Data Migration Specialist

LEAP Legal Software
Remote, USA
Full-time
Mid
Remote
USD 85000-100000 yearly / year
Discovered 1 months ago
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.

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

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at LEAP Legal Software