At a Glance
- Tasks: Deliver technical projects, analyse databases, and support data migrations for legal tech.
- Company: Join a growing Professional Services team in a leading tech consultancy.
- Benefits: Competitive salary, hybrid work, and opportunities for professional growth.
- Other info: Dynamic role with potential for remote work and career advancement.
- Why this job: Solve complex problems and make a real impact in the legal tech industry.
- Qualifications: Experience with SQL, data migration, and excellent communication skills.
The predicted salary is between 55000 - 70000 £ per year.
- Service Delivery Technical Consultant
- London/Orpington (Hybrid Initially, reverting to full remote)
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 with Essential
- 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
- i Manage
- Net Documents
- e DOCS
- Elite 3E
- Aderant
- Big Hand
- 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.
#J-18808-Ljbffr
Technical Consultant (SQL / Data) employer: Picture More Ltd
Picture More Ltd is an exceptional employer that values its employees by offering a dynamic work culture and the flexibility of hybrid working arrangements. With a focus on professional development, team members have access to cutting-edge Microsoft technologies and opportunities for growth within a respected professional services environment, making it an ideal place for those seeking meaningful and rewarding employment in London.
StudySmarter Expert Advice🤫
We think this is how you could land Technical Consultant (SQL / Data)
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Picture More Ltd or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Picture More Ltd.
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Picture More Ltd.
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Picture More Ltd that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Technical Consultant (SQL / Data)
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Picture More Ltd.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Picture More Ltd and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at Picture More Ltd
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Picture More Ltd uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.
