Intermediate Data Engineer

About the role

Let's go on an adventure together! Hey there, we're G Adventures. We're one of the world's leading small group travel companies, and we've always believed that travel isn't just about where you go - it's about how it changes you. For the last 35 years, we've set out to do things differently. No cookie-cutter tours. No giant buses or cruise ships. And not to mention, as few selfie sticks as possible. Just real humans, travelling your heart out across the world with open minds and a non-stop desire to make our planet better, simply by exploring it. At G Adventures, our DNA (or GNA, if you will) is built on belonging - where bringing your authentic self to work every day isn't just accepted, it's downright celebrated. For our office crew - you wanna rock a t-shirt with your dog's face on it? We say go for it. For our Chief Experience Officers - you wanna hit the road and call some of the most epic places on Earth your home office? We love that - and we've got you. Wanna spend your days with people you genuinely like? Us too - and we're pretty sure you'll fit right in, wherever that is. Now about that career of yours - this is the kind of place where you can spread your wings and truly grow into your role. The best part? You get to do it all alongside a passionate, freakishly talented, one-of-a-kind bunch excited to produce top-notch work and spread a ridiculous amount of goodness at the same time. Feel like this could be the right fit? We think so too, and we're already way too excited to meet you. The Intermediate Data Engineer is highly motivated and experienced; responsible for designing, building and maintaining highly scalable and robust data solutions for our global operations. The role is key in our data-driven organization; working alongside a team of passionate engineers, developers, analysts, and subject matter experts to deliver solutions that transform the way we use data. Working with the latest technologies and frameworks to leverage your creativity and problem-solving skills to overcome the challenges of managing large volumes of data in real-time. Collaborating with cross-functional teams and make a real impact on our organization: You will manage and maintain the automated orchestration and ingestion of data using Fivetran and Airflow MWAA into our Redshift warehouse; assist our BI team by providing support and guidance for our BI tool Looker; build high-quality data models using dbt Cloud with a focus on marketing data and utilize Python, SQL, Git and CI/CD tools to build integrations while maintaining high standards of documentation and coding efficiency. Technical Leadership & Architecture Support the design and implementation of highly scalable, resilient and performant data solutions that feed into a central data warehouse which serves as the single source of truth for the organization. This includes conforming to data architecture methodologies and ensuring their consistent application. Monitor and maintain data pipelines and orchestration to ensure reliable, timely and accurate ingestion from internal and external source systems. Proposing and implementing improvements that enhance system performance, scalability, and overall reliability. Passionate about emerging technologies and industry trends, suggesting innovative and forward-thinking solutions to enhance the company's data environment. Data Engineering & System Excellence Adhere to best practices, coding standards, and design principles. You'll help ensure the delivery of exceptionally clean, efficient, and maintainable data models. Support diagnosing, debugging, and resolving technical issues within a complex data environment involving distributed systems, and critical third-party integrations. Support the Principle Data Engineer in optimizing the data environment; implementing methodologies and automated tests, ensuring robust and reliable solutions, promoting data integrity,accuracy, availability, usability and security. Monitoring the performance of the data warehouse; help diagnose bottlenecks and resources to ensure scalability for the growing data volumes and business requirements. Collaboration & Stakeholder Engagement Work with business stakeholders, infrastructure and technical teams to implement technical solutions for efficient and timely delivery of new data sources. Collaborate with subject matter experts to deliver solutions that enable the distribution of data models to BI tools and other data platforms which conform to data engineering principles and compliance with international regulations. Support the business by performing administrative tasks such as performing license updates and permission changes. Mentorship & Knowledge Management Contribute with code reviews, providing actionable feedback, and serve as a mentor to other team members. Provide constructive feedback to foster a culture of continuous learning and technical growth. Provide technical guidance to the Data Systems a