At a Glance
- Tasks: Lead data discovery and migration processes, ensuring data quality and structure.
- Company: Join a forward-thinking firm focused on data-driven solutions.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on innovation and collaboration.
- Why this job: Make a real impact by transforming legacy data into valuable insights.
- Qualifications: 3+ years in data analysis or migration, strong SQL skills required.
The predicted salary is between 40000 - 50000 £ per year.
You will lead the structured discovery of legacy finance and matter data, assess its quality and structure, and play an instrumental role in the migration process that follows.
Responsibilities
- Own the data discovery process across legacy finance and matter systems, profiling data volume, quality, completeness, and structure.
- Get a true understanding of legacy database schemas across practice management, case management, and finance platforms, producing field‑level mapping documentation.
- Write SQL queries to extract, profile, and validate data from source systems, turning raw data into structured discovery outputs.
- Surface data quality issues, retention risks, and anomalies early.
- Contribute to the data migration, working across extraction, transformation, validation, and post‑migration reconciliation.
- Translate complex data findings into clear, well‑structured outputs, for discovery reports or exception logs.
- Contribute to migration runbooks, test scripts, and acceptance criteria.
- Build and maintain MI dashboards.
Requirements
- At least three years in a data analyst or data migration role, with exposure to complex, multi‑system environments.
- Solid SQL capability, with the confidence to write queries against unfamiliar schemas, extract and profile data at volume.
- A proven track record in data discovery and quality assessment, with the ability to identify and categorise issues at scale and communicate findings in a way that drives action.
- Understanding of the data migration lifecycle, from extraction and transformation through to loading, reconciliation, and acceptance testing.
- Strong communication skills, with the ability to present complex data findings clearly to non‑technical audiences.
- Experience producing high‑quality data documentation, including data dictionaries, field mapping matrices, and quality exception logs.
- Resilience and resourcefulness when faced with legacy data that is incomplete, inconsistently structured, or poorly documented.
What Would Set You Apart
- Hands‑on familiarity with legal practice management or case management systems, for example Aderant Expert, SOS Connect, Partner for Windows, ProClaim, Linetime Liberate, or VisualFiles.
- SQL skills, including the ability to interrogate unfamiliar schemas, write profiling and extraction queries, and support transformation and field‑level mapping; exposure to scripting languages such as Python for data preparation and automation.
- An appreciation of the data retention obligations and regulatory considerations that apply to legal sector data, particularly client matter records and financial information, and how these affect migration scoping and decision‑making.
- Prior experience working within a structured programme or project delivery environment, with an understanding of how data workstreams fit into a broader delivery lifecycle.
Data Analyst in London employer: Dgh Recruitment
As a Data Analyst at our company, you will thrive in a dynamic work culture that values innovation and collaboration. We offer competitive benefits, including professional development opportunities and a supportive environment that encourages growth and learning. Located in a vibrant area, our team enjoys a balanced work-life experience while contributing to meaningful projects that drive impactful change in the legal sector.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries, data discovery projects, and any dashboards you've built. This gives you a tangible way to demonstrate your expertise and makes you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data migration scenarios and challenges. Be ready to discuss how you've tackled data quality issues in the past and how you can contribute to the migration process at StudySmarter.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining the StudySmarter team.
We think you need these skills to ace Data Analyst in London
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your SQL capabilities in your application. We want to see how you can write queries and handle data extraction, so don’t hold back on showcasing your experience with complex schemas!
Be Clear and Concise:When writing your application, keep it straightforward. We appreciate clarity, especially when it comes to presenting complex data findings. Use simple language to explain your past experiences and how they relate to the role.
Tailor Your Experience:Link your previous roles to the responsibilities listed in the job description. We’re looking for someone who understands the data migration lifecycle, so make sure to mention any relevant projects you've worked on that demonstrate this.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining the StudySmarter team!
How to prepare for a job interview at Dgh Recruitment
✨Know Your Data Inside Out
Before the interview, dive deep into the specifics of data discovery and migration. Familiarise yourself with legacy finance and matter systems, and be ready to discuss how you’ve profiled data volume and quality in past roles. This will show your potential employer that you understand the intricacies of the job.
✨Show Off Your SQL Skills
Be prepared to demonstrate your SQL capabilities during the interview. Practice writing queries against unfamiliar schemas and think of examples where you've extracted and validated data. This hands-on approach will highlight your technical prowess and confidence in handling complex data.
✨Communicate Clearly
Since you'll need to present complex data findings to non-technical audiences, practice explaining your past projects in simple terms. Use clear examples of how you’ve turned raw data into structured outputs, and be ready to discuss how you’ve communicated data quality issues effectively.
✨Prepare for Legacy Challenges
Expect questions about dealing with incomplete or poorly documented legacy data. Share specific instances where you’ve tackled these challenges, showcasing your resilience and resourcefulness. This will demonstrate your ability to navigate the complexities of data migration.
