25 Oct
|
Butterfield & Robinson
|
Toronto
25 Oct
Butterfield & Robinson
Toronto
As the world’s premier active travel company, Butterfield & Robinson ( 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. 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.
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 chance to be part of a community that’s passionate about shaping the future of travel.
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 strong 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.
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
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 SQL Server experience is an asset.
- Proven experience cleaning and migrating data, including at least one major migration.
- Experience setting data quality rules for large data sets.
- Experience with SSRS or Power BI reporting, and with travel or booking systems such as Peak 15, an asset.
- 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.
- Experience preparing data for AI or machine learning projects is an asset.
- Familiarity with AI tools that connect to databases, such as Claude, ChatGPT, is an asset.
- Comfortable as the sole database expert, making sound decisions without a team of database peers.
Creative and independent thinker with sound judgment.
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 the demonstrated ability to take initiative.
We use automated tools, including artificial intelligence, to assist with the initial screening of applications. We consider qualified applicants regardless of race, colour, religion, gender, national origin, sexual orientation, age, citizenship, disability, or gender identity. Accommodations are available on request for candidates taking part in all aspects of the selection process.
#
📌 DataBase Administrator (IT) (Toronto)
🏢 Butterfield & Robinson
📍 Toronto