Data Migration Technical Lead

Firefish Software; Glasgow; Remote; GBP 43,000 - 56,000; Full time

Job summary

Firefish Software seeks a Data Migration Technical Lead to enhance onboarding by managing ETL processes for client recruitment data. You'll leverage your strong SQL skills in a remote-first work environment offering flexibility and extensive benefits for a balanced work-life.

Benefits

Remote-first working

25 days holiday plus 8 public holidays

Medical cashback for treatments

Private healthcare

24/7 mental health support

Structured career development programmes

Regular social events

Qualifications

• Strong SQL experience with large relational datasets.
• Experience with SSIS for ETL process design and execution.
• Understanding of recruitment workflows and data lineage.

Responsibilities

• Lead complex data migrations from various products.
• Map and normalize datasets to Firefish's structures.
• Collaborate with Implementation Managers for onboarding.

Skills

SQL

ETL

Data analysis

Data mapping

Problem-solving

Job description

At Firefish Software, we empower recruiters with software that accelerates time-to-placement and streamlines candidate engagement. But it all starts with a solid foundation: accurate, compliant, and complete data migration.

That’s where you come in.

We’re looking for a Data Migration Technical Lead to spearhead our onboarding process by owning the ETL of recruitment data from legacy systems into Firefish. Our clients use a myriad of recruitment CRMs, ranging from modern SaaS competitors to bespoke databases, all with different schemas and structures.

Here’s a flavour of what you’ll be doing:

• Leading complex data migrations from a wide range of competing recruitment products and bespoke sources
• Mapping and normalising datasets to match Firefish’s candidate, job, placement, and compliance structures
• Using core SQL skills to analyse, transform, and validate datasets during import/export.
• Designing, running and optimising workflows using SSIS
• Collaborating with Implementation Managers to ensure smooth onboarding timelines
• Working closely with Product teams to identify efficiencies, propose tooling, and introduce AI-assisted workflows for validation and mapping
• Owning the migration methodology, producing repeatable patterns, tools and playbooks
• Constantly de-risking projects by flagging ambiguity, data quality issues, or performance blockers early

You'll Excel If You...

• Have strong SQL experience across large relational datasets and a keen eye for query performance
• Have demonstrable experience with SSIS for ETL process design and execution
• Understand recruitment workflows and the importance of data lineage (especially for placements, GDPR, and compliance)
• Can reverse-engineer legacy databases and APIs—even when documentation is lacking
• Are comfortable working with technical and non-technical stakeholders
• Have a mindset for continuous improvement and AI-readiness

And You’ll Get Bonus Points For…

• Experience with recruitment CRMs like Bullhorn, Vincere, RDB, or Invenias
• Scripting experience in Python or automation with Power Automate
• Experience integrating GPT-based or LLM-enhanced tools into workflows

We appreciate that to have a good life at work you need to have a good life outside of work too! So, for this role we offer:

• A basic salary of £43,000- £56,000per annum
• Remote-first working & flexible hours: adjust your schedule to fit around your out-of-work commitments (as long as you're here for our core hours!)
• 25days holiday (plus 8 public holidays)
• Medical cashback for optical, dental, therapy treatments and consultations up to £1170 per year for you, and additional allowance for dependent children
• Private healthcare, GP service, healthclub discounts, retail discounts and cashback
• 24/7 mental health support line, face-to-face CBT sessions, and in-house mental health first aider
• Structured career developmentprogrammes and in-house coaches
• Regular social events online, at our Glasgow Aquarium, and at exciting external locations
• Company awards, kudos...and plenty of fish puns