SQL Developer (6 Month Contract)

Collinson is the global, privately-owned company dedicated to helping the world to travel with ease and confidence. The group offers a unique blend of industry and sector specialists who together provide market-leading airport experiences, loyalty and customer engagement, and insurance solutions for over 400 million consumers.


Collinson is the operator of Priority Pass, the world’s original and leading airport experiences programme. Travellers can access a network of 1,500+ lounges and travel experiences, including dining, retail, sleep and spa, in over 650 airports in 148 countries, helping to elevate the journey into something special. We work with the world’s leading payment networks, over 1,400 banks, 90 airlines and 20 hotel groups worldwide.

We have been bringing innovation to the market since inception – from launching the first independent global VIP lounge access Programme, Priority Pass to being the first to sell direct travel insurance in the UK through Columbus Direct and creating the first loyalty agency of its kind in the travel sector with ICLP. Today we still invest heavily in innovation to ensure that we continue to deliver superior customer experiences.

Purpose of the job

We are seeking a skilled SQL Developer to join our insurance team and support the design, development, and maintenance of SQL Server databases. The ideal candidate will have strong experience in writing and optimizing stored procedures, views, and handling data migration tasks. A solid understanding of relational database schemas is essential.

Key Responsibilities

• Design, develop, and maintain SQL Server stored procedures, views, and functions.

• Perform data migration tasks across environments and systems.

• Analyze and optimize existing SQL queries for performance improvements.

• Collaborate with engineering and business teams to understand data requirements and deliver solutions.

• Ensure data integrity and consistency across systems.

• Document database structures, processes, and procedures.

• Support troubleshooting and debugging of database-related issues.

Knowledge, skills and experience required

Key Responsibities:

• Design, develop, and maintain SQL Server stored procedures, views, and functions.

• Perform data migration tasks across environments and systems.

• Analyze and optimize existing SQL queries for performance improvements.

• Collaborate with engineering and business teams to understand data requirements and deliver solutions.

• Ensure data integrity and consistency across systems.

• Document database structures, processes, and procedures.

• Support troubleshooting and debugging of database-related issues.

Required Skills & Experience:

• Proven experience with Microsoft SQL Server.

• Strong proficiency in writing stored procedures, views, and complex SQL queries.

• Experience with data migration and transformation processes.

• Solid understanding of relational database design and normalization principles.

• Familiarity with performance tuning and query optimization techniques.

• Ability to work independently and in a team-oriented environment.

Nice to Have:

• Insurance Industry Experience

Key clients include Mastercard, American Express, Cathay Pacific, British Airways, LATAM, Flying Blue, Accor, EasyJet, HSBC, Chase, HDFC.

Our mission is focused on doing good beyond profit, which for us means we seek out opportunities for our people to share in our success and that we give back to the communities and people within which we work.

Never short of ambition, the success of our business is delivered through the diverse and talented team of over 2,200 global colleagues.

Collinson is an equal opportunity employer and welcomes differences in all their forms including: colour, race, ethnicity, gender identity, sexual orientation, neurodivergence, family status, age, individuals with disabilities and people from all backgrounds, cultures and experiences as we strongly believe this contributes to our on-going success.

We are focused on continually evolving our purpose driven, high performing culture, providing an environment where our people have the opportunity to achieve their full potential and do interesting and meaningful work. Our company values are: Take Action, Do the right thing, One team and Be insight led. These help guide everything we do internally in terms of how we think, act and interact, right through to how we deliver value to our customers and clients.

In your application, please feel free to note which pronouns you use (For example - she/her/hers, he/him/his, they/them/theirs, etc).

If you need any extra support throughout the interview process, then please email us at [email protected]