Technical Consultant - SQL Data Migration & Legal Systems

We’re looking for a Technical Consultant to join a growing Professional Services team delivering software implementations, SQL data migrations and systems integration projects for leading UK and international law firms.

Working directly with clients, you’ll play a key role in migrating and transforming data across a range of legal technology platforms. You’ll analyse Legacy databases, define data mapping requirements, develop SQL migration scripts and support the successful implementation of enterprise legal applications.

This is a hands-on technical consultancy role and would suit someone who enjoys solving complex technical problems while working closely with customers.

What you’ll be doing

• Deliver technical implementation and migration projects from discovery through to go-live
• Analyse SQL databases and Legacy application structures
• Design source-to-target data mapping specifications
• Build and execute SQL migration scripts
• Develop and support ETL processes
• Perform data conversion, transformation, cleansing and validation
• Support integrations between legal applications and business systems
• Configure software solutions during implementation projects
• Produce technical documentation, migration plans and implementation guides
• Work directly with customers to gather technical requirements and provide technical guidance
• Troubleshoot migration and implementation issues throughout project delivery

You’ll ideally have experience withEssential

• Microsoft SQL Server
• SQL Scripting
• Data migration
• ETL processes
• Data mapping
• Data conversion and transformation
• Customer-facing software implementation or technical consultancy
• Requirements gathering
• Excellent communication skills

Desirable

Experience with one or more of the following would be advantageous:

• Document Management Systems (DMS)
• Practice Management Systems (PMS)
• Time Recording systems
• Information Governance platforms
• Records Management systems
• iManage
• NetDocuments
• eDOCS
• Elite 3E
• Aderant
• BigHand
• Intapp

Integration experience

Any experience working with integrations would be beneficial, although not essential.

This could include:

• REST APIs
• Systems integration
• Microsoft .NET
• ASP.NET
• C#
• Middleware
• SQL-based integrations
• Enterprise application integration

You’ll be working with multiple interconnected legal technology platforms, so an understanding of how enterprise systems exchange and consume data would be highly desirable.