Job Specifications
Discover the Art of Travel
As the world's premier active travel company, Butterfield & Robinson (www.butterfield.com) creates immersive journeys that inspire, delight, and transform. Since 1966, we've been crafting exceptional experiences and extraordinary memories, redefining what it means to truly travel.
At Butterfield & Robinson, success is built on our relentless pursuit of excellence and our passion for pushing the boundaries of what's possible in luxury travel. We don't just design trips--we curate unforgettable adventures that connect people to the world in deeply meaningful ways. Behind every seamless journey is a dedicated team of experts who share a singular focus: making every moment extraordinary.
A Legacy of Excellence
For decades, Butterfield & Robinson has been celebrated as a trailblazer in luxury travel, recognized globally for our commitment to innovation and excellence. Our efforts have earned us prestigious accolades, including being named the World's Best Tour Operator by Travel + Leisure. These honors reflect the care, creativity, and precision we bring to every adventure--ensuring each experience exceeds expectations and leaves a lasting impression.
A Workplace That Inspires
At B&R, we believe that extraordinary journeys begin with an inspired team. Our dynamic and supportive work environment fosters creativity, collaboration, and well-being. Employees are part of a vibrant, innovative workplace and benefit from a range of unique perks designed to support wellness, individual growth and balance. We value transparency and accountability in the social and environmental performance of our business, and are deeply committed to the principles of responsible, sustainable, and ethical tourism. Working at Butterfield & Robinson isn't just a job--it's an opportunity to be part of a community that's passionate about shaping the future of travel.
Job Overview
The SQL & Integration Specialist at Butterfield & Robinson thrives on solving complex data challenges, enjoys working across multiple database environments, and has a knack for building efficient, reliable data integrations.
The SQL & Integration Specialist works to support the IT and Digital Experience teams under the direction of the Director, IT.
The SQL & Integration Specialist will work cross-functional teams to design, maintain, and optimize data flows between internal and external systems. This position requires a balance of strong technical expertise, analytical thinking, and excellent communication skills.
Key Responsibilities
Support the design, develop, and maintain SQL databases (Microsoft SQL Server, PostgreSQL) under the direction of the Director of IT.
Build and optimize SQL Server Reporting Services (SSRS) reports and dashboards.
Manage, monitor, and tune database performance and reliability.
Develop and maintain data integrations using ETL/ELT tools.
Write and maintain Python scripts (NumPy, Pandas, Matplotlib) for data transformation, analysis, and automation.
Collaborate with Agile teams, participating in sprints, stand-ups, and planning sessions.
Partner with the Senior Business Analyst (Power BI) to ensure data consistency, accessibility, and integrity across analytical and reporting environments.
Translate business needs into data solutions, reports, and pseudo-code where needed.
Create and maintain documentation of data structures, integrations, and workflows.
Provide ad hoc data analysis and reporting support using Excel and other tools.
Oversee ongoing development and maintenance of data transfer protocols with our vendors
Act as the primary point of contact with vendors' data specialists
Essential Skills, Qualifications and Experience
Bachelor's degree in Computer Science, Information Systems, or a related field.
3-5 years of experience in database engineering, development, or a related field.
Advanced proficiency in SQL (Microsoft SQL Server and/or PostgreSQL).
Strong experience with SSRS report development.
Experience with ETL/integration tools - Experience with: Dell Boomi, MuleSoft, TIBCO Scribe, n8n a strong asset.
Solid Python skills, particularly for data handling - experience with: NumPy, Pandas, Matplotlib a strong asset.
Strong Excel skills, including advanced formulas, pivot tables, and data modeling.
Strong understanding of data governance and security best practices.
Excellent communication and documentation abilities.
Skills and Characteristics
Creative and independent thinker with sound judgment.
Strong analytical and problem-solving abilities.
High attention to detail.
Strong written and verbal communication skills with the ability to interact with all levels of the business.
Ability to maintain a high degree of professionalism and confidentiality.
Understanding and appreciation of a global, creative, and flexible work environment.
Ability to balance multiple priorities and deliver high quality work while working independently.
Must be highly organized, flexible and have
About the Company
Butterfield & Robinson--the world's premier active travel company--designs incredible journeys to the world's most amazing places. Crafted from the finest ingredients (exceptional lodgings, incomparable access, stellar wines and food, experienced guides and more than a few secrets), B&R's trips combine active adventure with unparalleled cultural immersion in the world's greatest destinations. Options include biking, walking, family and multi-active itineraries plus an unmatched custom trip planning division that features exp...
Know more