Lead Data Engineer

Requisition ID:  2193
Department:  Information Technology
Work Type:  Hybrid
Application Close Date:  28th November 2024

 

At Intrepid Travel we exist to inspire, create, share and lead the best travel experiences ever – for both people and the planet. More than 34 years later, we’re proud to be a certified B Corp with hundreds of trips in over 100 countries. 

 

At Intrepid Travel we exist to inspire, create, share and lead the best travel experiences ever – for both people and the planet. More than 34 years later, we’re proud to be a certified B Corp with more than 1000 small group trips in over 120 countries. 

 

 

The world needs more Intrepid people: 

 

As a Lead Data Engineer with the Data & Analytics team, you will be accountable for designing, and developing scalable and effective data architectures that align with overall business objectives. This will include implementing data ingestion, processing and presentation capabilities. This role will see you working closely with the stakeholders across our global business to deliver high-value solutions across all our departments and locations.  

 

You will be working in a development environment that takes agility seriously and produces amazing technological solutions for the wider business. As a key member of our team, you will work very closely with product owners, senior technical team and end-users to deliver the best possible solutions with the latest techniques and tools. 
 

Some of your duties will include: 
 

  • Design & build data pipelines (Microsoft Fabric, Azure Data Factory, SSIS, stored procedures, Python, Databricks, C#) to ingest data from external systems  

  • Design and build data lakehouse layers (Microsoft Fabric, Azure Datalake) and data warehouse layers (Azure SQL, SQL Server) to facilitate reporting  

  • Design & build Power BI semantic models 

  • Maintain existing platform and provide operational support  

  • Lead and mentor a team of data engineers and provide technical guidance 

  • Define standards, processes and practices for the data engineers to follow. Ensure seamless integration between different data systems and platforms 

  • Identify and address performance bottlenecks and optimize data processing performance 

 

Some of the essential skills you’ll have are:
 

  • Bachelor’s degree or equivalent qualification in Business Information Systems, Information Technology, or related field   

  • Minimum of 3+ years analytical solutions using Microsoft SQL Server Stack, Azure SQL or Microsoft Fabric  

  • Excellent T-SQL and Python skills  

  • Experience (3+ years) with modern data warehouses/data lakes, relational databases, dimensional modelling and Kimball methodology  

  • Experience with source control (Git)
     

Our people reflect the diversity of our customers and the communities we visit:
Intrepid is made up of 58 nationalities across 46 countries, and we recognise that diversity makes us a stronger business. We support a culture where people can be themselves and encourage applications from people of all backgrounds. Including First Nations People, LGBTQI+ people, those living with a disability, or from disadvantaged backgrounds, and all people from different ethnicities, races, and religions. 

Rewarding and developing our people is important to us, some of our work perks include:
     •     
Flexible work options, such as work-from-home options and the ability to 'work from anywhere' 4 weeks a year
     •     A free Intrepid trip every year, plus generous discounts for families, and close friends
     •     5 extra days of leave a year for use on Intrepid trip's
     •     A minimum of 10 weeks paid parental leave for all parents, and other additional leave provisions. 
     •     Access to e-learning platforms, professional development and mentor programs
     •     20 hours of volunteer leave every year to use on causes most important to you
     •     Employee Assistance Program, a 24/7 service that offers counselling for you and your family

We are Real. Together. Ambitious. Impactful. These are our values and to us they're more than just words, they are the pillars of our success and every day it's our people and the work they do that bring them to life.

At Intrepid ensuring diversity, equity, and inclusion is an important part of our recruitment process. If you require a reasonable accommodation to submit your application, please email careersupport@intrepidtravel.com with your name, location, and the accommodations you need, we will then be in touch to support your application.