Techncial Consultant

Picture More Ltd; Greater London; Hybrid; GBP 55,000 - 70,000; Full time

Benefits offered by this job

Bonuses & Benefits

Job summary

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

In this hands-on role you will work directly with clients to migrate and transform data across legal technology platforms, analyse legacy databases, define data mappings and develop SQL migration scripts, while supporting integrations and delivering comprehensive

Qualifications

• Experience with SQL Server, SQL scripting, and data migration.
• Ability to design data mapping specifications and develop ETL processes.
• Customer-facing software implementation or technical consultancy experience.
• Strong requirement gathering and communication skills.

Responsibilities

• Deliver technical implementations and migrations from discovery to go-live.
• Analyse SQL databases and legacy app 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 apps and business systems.
• Configure software during implementations.
• Produce technical docs, migration plans and guides.
• Gather requirements and provide technical guidance to customers.
• Troubleshoot migration and implementation issues.

Skills

SQL scripting

Data migration

ETL processes

Data mapping

Data conversion and transformation

Customer-facing software consultancy

Requirements gathering

Excellent communication

Tools

Microsoft SQL Server

REST APIs

Systems integration

Microsoft .NET

ASP.NET

C#

Middleware

SQL-based integrations

Enterprise application integration

Job description

London/Orpington

(Hybrid Initially, reverting to full remote)

£55,000 - £70,000 + Bonuses & 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.