Service Delivery Technical Consultant

Picture More; City Of London; Hybrid; GBP 55,000 - 70,000; Full time

Benefits offered by this job

Benefits

Job summary

Picture More is seeking a Technical Consultant to join our Professional Services team, delivering software implementations, SQL migrations and systems integration for UK and international law firms.

In a hybrid role, you will work directly with clients to migrate data, map sources to targets, build SQL scripts and support ETL processes through go-live. This hands-on position suits problem-solvers who thrive on complex data challenges and customer-facing consultancy.

Qualifications

• Experience with Microsoft SQL Server and SQL scripting.
• Proven data migration, ETL and data mapping capabilities.
• Experience in customer-facing software implementation or technical consultancy.
• Strong requirements gathering and excellent communication skills.

Responsibilities

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

Skills

SQL Server

SQL scripting

Data migration

ETL processes

Data mapping

Data transformation

Client-facing consulting

Requirements gathering

Communication skills

Tools

REST APIs

Microsoft .NET

ASP.NET

C#

Middleware

Systems integration

Job description

London/Orpington (Hybrid Initially, reverting to full remote)

£55,000 - £70,000 + Benefits

About the role

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.