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 employer: Dgh Recruitment
As a Data Analyst at our company, you will thrive in a dynamic work culture that prioritises collaboration and innovation. We offer competitive benefits, including professional development opportunities and a supportive environment that encourages growth and learning. Located in a vibrant area, our office provides a stimulating atmosphere where your contributions to data migration and quality assessment will be valued and impactful.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with data professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨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 potential employers a taste of what you can do and sets you apart 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 their migration process.
✨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, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Analyst
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 against unfamiliar schemas and extract data effectively. Don’t forget to mention any specific projects where you’ve used SQL to solve complex data issues!
Be Clear About Your Data Experience:When detailing your experience, focus on your background in data discovery and quality assessment. We love candidates who can identify and categorise data issues at scale, so share examples of how you've communicated findings that drove action in previous roles.
Document Your Achievements:We appreciate high-quality documentation, so include any relevant work you've done on data dictionaries, field mapping matrices, or quality exception logs. This shows us you understand the importance of clear, structured outputs in the data migration process.
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 gives you a chance to explore more about what we do at StudySmarter!
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’re not just familiar with the concepts but have practical experience.
✨Show Off Your SQL Skills
Brush up on your SQL capabilities! Be prepared to write queries on the spot or discuss how you've tackled unfamiliar schemas in previous jobs. Highlight specific examples where your SQL skills helped you extract and validate data effectively, as this is crucial for the role.
✨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 turned raw data into structured outputs, and be ready to discuss how you documented your findings, like creating data dictionaries or exception logs.
✨Demonstrate Resilience and Resourcefulness
Be prepared to share stories about overcoming challenges with legacy data. Discuss how you approached incomplete or poorly documented data and what strategies you employed to ensure successful migration. This will showcase your problem-solving skills and adaptability, which are key for this role.
