Lead Data Engineer

Requisition ID:  2193
Department:  Information Technology
Work Type:  Hybrid
Application Close Date:  22nd April 2024

Intrepid Travel was born in 1989 with the simple mission to create positive change through the joy of travel.

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. After all these years, we’ve stayed true to our mission, ensuring our adventures are good for the places we go, good for the communities we visit and good for our travellers. That’s why we carbon offset all our trips and support local communities but we’re not stopping there. We want to be the best travel company not just in the world, but for the world.

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)
     

A bit about our people:

Our team reflects the diversity of our customers and the communities we visit. Our team is made up of 58 nationalities across 46 countries, and Intrepid recognises that diversity makes us a stronger business. With a commitment to breaking down barriers, we support a culture where people can be themselves. We encourage applications from people of all backgrounds, including First Nations People, LGBTQI+ people, people living with a disability, people from previously disadvantaged backgrounds, and people from different ethnicities, races, and religions. 

Work perks:

  • We offer flexible work options, including work-from-home, and work from anywhere in the world for up to 4 weeks a year
  • Employees receive a free Intrepid trip every year! As well as generous discounts available for families, and close friends
  • 5 extra days of leave annually, for use when travelling on an Intrepid trip
  • Our global leave benefits are aimed at supporting gender equity, so we offer a minimum of 10 weeks of paid parental leave for all parents, and other additional leave provisions. 
  • Access to incredible e-learning platforms, and professional development via our Elevate Mentor program
  • We provide an Employee Assistance Program, a 24/7 service that offers counselling for you and your family
  • We want to support the causes that are important to you, that’s why we offer 20 hours of volunteer leave every year.

If you’re here to inspire, create, share, and lead in what you do, we want to hear from you. We encourage you to submit your application as soon as possible – we may close advertising early if the right person is identified.