Lead Business Intelligence Analyst

at  G Adventures

About Us
G Adventures is the world’s largest small-group adventure travel company and we’ve been making epic travel memories happen on all seven continents for over 30 years.
Our mission is simple: to change lives through travel. And not just our travelers’ either. Since day one, our tours have been built to establish meaningful relationships with local communities, directly benefiting the people and places we visit at every step of our tours.
With the demand for travel coming back strong, we are set up and excited for this next chapter in our company’s story — and we’d love for you to be a part of it.
Our DNA revolves around building, nurturing, and developing a diverse culture of people and a true sense of belonging, where everyone is encouraged to bring their authentic self to work each and every day. You’ll have the opportunity to grow your career, and yourself, alongside a passionate, talented, and welcoming community that works hard to spread goodness around the world.
If all that sounds like your kind of thing, well, we can’t wait for you to join us.

Responsibilities

• Work cross-functionally to translate business requirements into specifications that will be used to implement the required data model and/or dashboard
• Design, build, and document data models, coded using LookML within Looker BI software, for enterprise-wide reporting
• Create intuitive and insightful dashboards in Looker for official company reporting
• Lead in-depth ad hoc analysis with the ability to parse out insights and deliver recommendations
• Respond to ad-hoc questions and help teach business users how to find answers
• Liaise with the Technology department with regards to new data sources, data warehousing transformation, data discrepancies, etc.
• Design & develop automated processes for recurring tasks
• Proactively identify improvements and new innovative ways to get the job done

Requirements

• Bachelor’s degree in a related field, or equivalent training and experience
• Minimum 4 years of experience in a data analytics or engineering related role
• Advanced SQL knowledge required, preference given to those with LookML experience
• An expert with Business Intelligence tools (Looker preferred)
• Strong documentation skills; experience with GitHub an asset
• Experience with ETL (Fivetran, dbt) and data warehouses (Redshift) an asset
• Experience writing Python an asset
• Experience with CRM (Salesforce) or digital analytics tools (Google, Facebook, Marketo, Heap) an asset
• Strong analytical and diagnostic skills when dealing with issues that are not readily defined
• A problem solver, a quick learner, and a self-starter with curiosity

What do we offer you?

• Competitive salary commensurate with the role
• Competitive benefits package
• Birthday day off
• Vacation time for you to recharge
• Enhanced Parental Leave
• Learning and growth opportunities
• Employee Resource Groups

Applicable based on location
G Adventures is an equal opportunity employer committed to fostering a diverse and inclusive work environment. We consider all qualified applicants.

• Work cross-functionally to translate business requirements into specifications that will be used to implement the required data model and/or dashboard
• Design, build, and document data models, coded using LookML within Looker BI software, for enterprise-wide reporting
• Create intuitive and insightful dashboards in Looker for official company reporting
• Lead in-depth ad hoc analysis with the ability to parse out insights and deliver recommendations
• Respond to ad-hoc questions and help teach business users how to find answers
• Liaise with the Technology department with regards to new data sources, data warehousing transformation, data discrepancies, etc.
• Design & develop automated processes for recurring tasks
• Proactively identify improvements and new innovative ways to get the job don