What You’ll Be Doing
* 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.
What You’ll Bring
Core Technical Skills
* 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.
Nice to Have
* 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.
Benefits & Perks
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:
* Competitive salary aligned to experience
* 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
Kinetic is an equal opportunity employer, fostering diversity and committed to creating an inclusive environment for all employees.
#J-18808-Ljbffr