Sql jobs in Canada

At Range Group we believe in the power of the professional travel advisor. We represent over $4.5 billion in annual travel sales. All our investments stem from a common thesis that travel advisors add real value to a trip. Travel advisors when equipped with technology and 24/7 support are irreplaceable. Equally important is our philanthropy. Range Foundation channels 10% of group profits to social impact. From exploration grants, improved access to education, new discoveries on sea and land, cultural infrastructure, and helping our global neighbors in times of need — we are investing to build a better future.

Who We Are:

Ensemble is the cornerstone of Range Group, a privately held company that invests in travel companies that elevate the customer experience and drive innovation. Our expansive and growing group of brands empowers seamless access to a comprehensive range of luxury travel options and services globally with over $1 billion transactions annually. Range Group’s goal is to create a more purposeful travel industry through its strategic investment, best-in-class services and philanthropy.

The Role:

As the Manager of Data & Platform Operations, you will lead and modernize Ensemble’s operational data, internal applications, and platform ecosystem. This role combines leadership with hands-on technical depth across data engineering & operations, CRM and finance systems, cloud platforms, and enterprise automation. You will define operational standards, own system stability, and drive the adoption of AI-enabled workflows and automation across the business.

You will oversee the reliability of critical business processes including production reporting, profit-sharing data flows, data ingestion, internal tooling, and identity systems while also shaping the long-term architecture that supports scalability and automation. This leader must be as comfortable setting strategic direction as they are rolling up their sleeves to solve system, data, or integration issues.

• Develop and direct Ensemble’s data and platform operations strategy with a focus on reliability, automation, and AI-driven process improvement.
• Build and mentor a high-performance team across data ingestion, platform engineering, data quality, and internal system administration.
• Champion an automation-first mindset, using AI and workflow tools to reduce manual effort and increase operational stability.
• Data, Systems & Platform Operations
• Provide hands-on leadership in the implementation, maintenance, and control of enterprise data systems, including CRM (HubSpot) and finance-related platforms.
• Own operational stability for business-critical internal systems and ensure clear administration, access control, monitoring, and documentation practices.
• Lead the design and enforcement of governance frameworks for data quality, ingestion architecture, workflow reliability, and integration controls.
• Oversee day-1 reporting availability and production data flows across ADX, GRASP, HubSpot, Power BI, and partner systems.
• Manage cloud operations with both leadership direction and hands-on involvement (Azure, AWS), ensuring resilient infrastructure, identity/SSO integration, and secure connectivity across systems.
• Direct platform modernization efforts, including environment configuration, networking, cost optimization, scalability planning, and disaster recovery.
• AI, Automation & Process Improvement
• Identify and deploy AI-enabled solutions that streamline operational tasks, improve data quality, and enhance system performance.
• Expand the use of automation tools (Power Automate, scripting, AI-assisted workflow orchestration) to simplify integrations and reduce error rates.
• Establish monitoring, alerting, and automated remediation processes for data pipelines and internal systems.
• Cross-Functional Collaboration & Governance
• Collaborate with Finance, Marketing, Member Services, Supplier Relations, and Technology teams to translate business requirements into stable and scalable operational systems.
• Work closely with Engineering teams to ensure seamless connectivity between applications and consistent data flows.
• Ensure the creation and maintenance of detailed process documentation, standards, and operational runbooks.
• Define and enforce controls, audit practices, and compliance standards across data and system workflows.

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field.
• 7+ years of progressive experience in data engineering, systems administration, platform operations, or enterprise applications, including at least 2 years leading technical teams.
• Hands-on experience implementing, maintaining, and governing CRM systems (preferably HubSpot) and finance or revenue-related systems.
• Deep experience with ETL/ELT frameworks, data architecture, integration patterns, and operational data workflows preferably with the Microsystem ecosystem including Fabric, Data Factory & Synapse
• Strong hands-on experience with Python, PySpark, SQL, data transformation frameworks and technical proficiency with APIs & integration patterns
• Strong technical experience with cloud platforms (Azure, AWS), including hands-on configuration, identity management, networking, monitoring, and automation.
• Experience deploying or managing AI-driven automations, workflow orchestration, or platform-wide efficiency improvements.
• Proven ability to improve operational reliability, reduce manual effort, and implement standardization across systems.
• Excellent communication, prioritization, and cross-functional leadership skills.
• Experience in travel or ecommerce environments is an asset.

• Thrives working in a technology and KPI driven organization.
• Able to thrive in an entrepreneurial environment.
• Highly functional in a fast paced, constantly changing workplace - building plans through iterations from learning on what’s working and not working.
• Ability to build trust and work through conflict both upwards and downward.

We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.

The Range Group may use artificial intelligence throughout the recruitment process to screen, assess or select applicants for this position. These tools assist our hiring team but do not replace human judgment. Final hiring decisions are ultimately made by humans. We thank all candidates for their interest however only those selected for an interview will be contacted.