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…
