Data Migration Technical Lead

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,000 per 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!)
  • 25 days 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 development programmes 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 🐠