24 Oct
|
Butterfield & Robinson
|
Toronto
24 Oct
Butterfield & Robinson
Toronto
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 Database Administrator at Butterfield & Robinson thrives on solving complex data challenges, enjoys working across multiple database environments, and takes pride in clean, reliable data.
The Database Administrator works with the Technology, Data and Digital Experience teams under the direction of the Chief Technology Officer.
The Database Administrator manages our databases and data quality, and will lead data cleaning and migration for migrations. The role works with teams across the business to design, maintain, and optimize data flows between internal and external systems. This position requires a balance of robust technical expertise, analytical thinking, and good communication skills.
As our only database specialist, the Database Administrator is the main point of contact for database management and data related application support. Alongside responsibility for servers, backups and security, the role involves investigating application issues, supporting users and understanding how our front‑end applications access, update and display data. This suits someone who enjoys a varied, hands‑on role, combining database administration with day‑to‑day application troubleshooting and support.
Key Responsibilities
- Manage,
design, and maintain our databases, especially PostgreSQL, as well as Microsoft SQL Server.
- Lead data migration for projects where it is required: map fields, move data, then check and reconcile it after each load.
- Monitor and tune database performance and reliability, including backups, access, and security.
- Develop and maintain data integrations using ETL/ELT tools.
- Clean and standardize data: remove duplicates, fix errors, and set rules that keep data clean in CRM/ERP and other systems.
- Support CRM/ERP data requests and configuration changes with business users.
- Write and maintain Python scripts (NumPy, Pandas, Matplotlib) for data transformation, analysis, and automation.
- Write, update and maintain SQL functions, both for and with our developers.
- Collaborate with Agile teams, participating stand‑ups.
- 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
Essential Skills, Qualifications and Experience
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 3-5 years of experience as a database administrator, or in database engineering or development.
- Advanced SQL, with strong hands‑on experience managing PostgreSQL databases. Microsoft S
📌 Database Administrator (Toronto)
🏢 Butterfield & Robinson
📍 Toronto