Data Integration / SQL Developer 57755

Data Integration / SQL Developer 57755

Department: Professional Services

Employment Type: Permanent - Full Time

Location: Milton Keynes

Compensation: £35,000 - £45,000 / year

Description

About Kinetic

Kinetic was founded in 1998 with one aim: to develop the most innovative software to help university accommodation and conferencing teams deliver the best student and customer experiences possible.

Fast forward 25 years, and we are now the technology partner of choice to the worlds' leading universities, colleges and accommodation providers. We are ranked on the APUC framework for student accommodation management, conferencing and events management, and multifunctional management systems. Our big hairy audacious goal (BHAG) is to achieve £50m net revenue by 2032 and for every person in a university to experience a Kinetic product.

We supply mission-critical software for over 350 customers worldwide, and we are trusted partners to over 80% of universities in the UK!

Since 2015, Kinetic has been part of the Volaris Group. Volaris help strengthen and grow vertical market software companies so, like Kinetic, they become leaders in their industry.

Key Responsibilities

• Design and develop data interfaces to import/export data between internal systems and third-party services.
• Write, optimize, and maintain T-SQL stored procedures, views, and queries.
• Collaborate with consultants and client stakeholders to define technical needs and project scope.
• Write comprehensive interface specifications, including data mapping, transformation logic, file formats, and transfer schedules.
• Monitor and troubleshoot data flows, resolving transformation and delivery issues effectively.
• Maintain clear documentation for integration logic and operational procedures.
• Ensure all solutions meet internal standards for security, reliability, and data quality.

Skills, Knowledge & Expertise

• Strong proficiency in SQL Server and T-SQL, including stored procedure development and performance tuning.
• Hands-on experience developing system integrations involving structured data.
• Ability to create accurate, detailed technical specifications for data interfaces and file transfers.
• Knowledge of file-based formats (CSV, XML, JSON) and secure transfer methods (e.g. SFTP).
• Understanding of relational databases and data transformation techniques.
• Experience working with personal and financial data in a secure and compliant manner.

Desirable Skills

• Background working with student information systems or platforms used in education or finance.
• Familiarity with job scheduling tools (e.g. SQL Agent) or task automation (e.g. PowerShell).
• Basic familiarity with APIs (REST, JSON) - although this is not the primary integration method.

What Success Looks Like

• Integration projects are delivered on time with well-documented, accurate, and robust specifications.
• Interfaces are reliable, performant, and compliant with data protection requirements.
• You are a trusted expert in technical interface design, able to translate requirements into working solutions.

Job Benefits

At Kinetic, we believe work should come with rewards that make a real difference. Here's just a taste of what you can expect when you join us:

• 25 days holiday (plus bank holidays) - with extra days the longer you're with us
• Two paid wellbeing days each year, with a budget to enjoy some time out with someone important to you
• Enhanced pension contributions to support your future
• Two paid days a year to give back through volunteering, charity work, or sustainability projects with our Green Team
• Salary sacrifice schemes for electric vehicles and cycle-to-work
• 24/7 access to our Employee Assistance Programme for confidential advice and support
• A full annual health check to keep you at your best
• A flexible benefits platform - from life assurance and learning opportunities to retail discounts and cinema tickets
• A genuine people-first culture where your growth and wellbeing come first
• Performance-related bonus scheme to reward your contribution
• Regular socials - from team get-togethers to all-company celebrations, with each department owning a budget for their events
• The opportunity to attend group conferences, away days and learning forums both in the UK and abroad - network with other talent

We've created a welcoming office environment, with well-stocked kitchens offering free breakfast, fresh fruit, hot and cold drinks, and a range of tuck shop goodies to keep you fuelled throughout the day.

Kinetic is an equal opportunity employer, fostering diversity and committed to creating an inclusive environment for all employees.