Passionate about delivering exceptional data solutions and solving complex migration challenges?

This role offers the perfect opportunity to combine your technical expertise with client-facing impact in a dynamic, forward-thinking environment. Katchr is a leading provider of business intelligence solutions, and we’re looking for our next PMS Migration Consultant to join our talented team.

At Katchr, we’re on a mission to make work and life a winning team. We believe that when people thrive in their careers, it transforms both their professional and personal lives. Over the years, we’ve built a reputation for delivering powerful tech solutions with exceptional service — and now we’re looking for someone who shares our passion for quality, collaboration, and continuous improvement.

The Role

As a PMS Migration Consultant, you’ll be part of our close-knit SQL specialist team, working with complex data sets, solving ETL challenges, and ensuring data integrity during critical Practice Management System migrations. You’ll work directly with clients, understanding their systems, applying business rules, and making sure their data is accurate, reconciled, and ready to drive results.

This role is perfect for someone who thrives in a structured, process-driven environment but still enjoys the variety and problem-solving that comes with client projects.

What You’ll Be Doing

• Leading or contributing to client PMS data migrations, ensuring clean, accurate, and secure data transfer
• Designing data connectors to extract and process information from diverse sources (APIs, data lakes, CRMs, legacy systems)
• Configuring and customising ETL SQL scripts to reflect client-specific business rules
• Transforming and reformatting legacy PMS data into standardised structures
• Reconciling, validating, and balancing complex data sets across systems
• Creating dashboards using our proprietary tools
• Demonstrating work in team reviews and managing feedback
• Exploring new tools and techniques to keep your skills sharp

What We’re Looking For

We hire for both skill and mindset. You’ll be a strong match if you:

• Have proven experience with Microsoft SQL Server & T-SQL
• Understand ETL processes and data transformation
• Have worked with complex data models and business rules
• Bring experience with PMS migration projects
• Have exceptional attention to detail and a logical, structured approach

Bonus points for:

• Experience with Power BI or Azure Data Factory
• Knowledge of BI/data warehouse environments
• Background in legal, accounting, insurance, or financial services sectors
• Exposure to systems like Elite 3E, Aderant, or other PMS platforms

Our Values

Katchr people are CACTI:

Customer Focused – We put clients first, giving them the insights and support to succeed.

Authentic – We act with integrity and build lasting trust.

Collaborative – We solve problems together and support each other.

Transparent – We communicate openly so people always know where they stand.

Improvers – We learn, adapt, and keep finding better ways to work.

These aren’t just words on a wall — they shape how we work every day.

The Benefits

• £45k - £55k basic salary (depending on experience)
• A warm, collaborative, and capable team
• 25 days holiday plus Bank Holidays
• Annual profit-sharing bonus based on company performance
• Private healthcare
• Unlimited training budget for personal and professional development
• Flexible working options to suit real life
• Pension scheme
• Annual leave loyalty bonus every 5 years

Location & Working Pattern

You’ll be based from our Huddersfield hub for onboarding (due to secure data handling requirements). After that, we offer flexibility — work from the office, from home, or a mix of both.

If you’re ready to use your skills to deliver exceptional results for clients while working in a supportive and ambitious team, we’d love to hear from you.