Data Engineer

What Data at Hive looks like

Everyone at Hive is hungry for data- our team members, clients, and partners. We need easy access to clean, trustworthy, transformed data to support operational & strategic decision making. We’d also like to leverage this data to provide insights back to our customers that they can use to increase their ticketing revenue.

You will play a key role in managing and evolving our data infrastructure, serving key stakeholders across various business units. With much of the groundwork for our data systems already established, you’ll build on this foundation, ensuring seamless data operations while identifying and implementing improvements to support the business.

What you’ll get up to

• Design, build, and maintain robust data systems, including data ingestion pipelines, orchestration processes, and integration of new data sources.

• Be an ambassador for our data-driven culture, taking data and shaping it to facilitate analysis, insight generation, and decision-making.

• Maintain and troubleshoot a modern data stack and own the infrastructure, ensuring high data quality and availability for our core data sets.

• Ingest, clean and organize raw data in a way that makes sense for both you and the organization.

• Shape the data model at Hive, which will advance our broader analytics strategy and support in establishing norms and best practices for data governance across Hive.

• Liaise between various teams to translate business requirements into proper data capture and schema design.

• Support folks out in the business to get the insights they need, creating dashboards, coaching citizen analysts etc.

• Lead data projects from ingestion to reporting, showing your ability to manage scope and work with ambiguity.

• Proactively identify opportunities to optimize the data stack and introduce new tools or technologies as required.

The tech stack you’ll be working with: 

• Data warehouse: Snowflake

• Ingestion: Airbyte

• Orchestration: Dagster

• Data modeling: dbt

• BI tool: Metabase

• Ad-hocs and Python notebooks: Hex

Who you are

• 3+ years of experience as a data engineer, full-stack data analyst, or analytics engineer.

• Experience working E2E in a modern data stack (data ingestion to reverse ETL & reporting), preferably at a startup or scaleup. 

• Strong SQL skills.

• Experience writing Python data pipelines (Dagster, Airflow, Prefect).

• Experience with Modern Data Stack data warehouses (e.g. Snowflake, BigQuery).

• Experience working with a variety of complex data sources. Our toolset currently includes Salesforce, Stripe, Intercom, Vitally, Google Analytics, FullStory.

• Proven ability to translate business needs into analytical frameworks.

• Skilled at developing efficient self-service analytics platforms, data marts/sets & dashboards and designing effective data models.

• Have an appreciation of data governance principles including appropriate handling of personal data, data lineage, data cataloguing, and compliance.

• Excellent communication skills, spoken and written, with both technical and non-technical stakeholders.

Who you are

• Comfortable working independently and autonomously in an ambiguous environment

• You index for impact, you’re not afraid to make a decision without all the information, and you like to have fun while doing it.

• You have a knack for troubleshooting and creating solutions when systems or tools break. 

• You are excited about the opportunity to shape the future of our data operations in a drawing, fast-paced company

Nice to haves

• Python skills, familiarity with AWS.

• You’ve set up and/or managed a data stack E2E before.

• Working experience with a variety of tools - you can speak to why we might choose BigQuery over Snowflake, or Mode vs Looker.

• You’ve worked in SaaS before, so you have an understanding of the data sets needed to answer the questions that teams are likely to have.

We understand that we all bring different strengths to the table. If you meet some but not all of our requirements or think you bring something else unique to the table please don’t hesitate to apply. We’d love to hear from you even if you’re not an exact match to our list.

Comp/Benefits Package

• Meaningful salary and equity: you're rewarded based on impact

• Fully remote: Work fully remote in Canada, where you’re most productive whether that be from your house, or elsewhere. We just ask that you have legal Canadian work authorization

• Flexible work hours: Choose your 9-5 as long as it’s not disruptive to your role, team, and Hive

• Health + Insurance: Comprehensive health & dental coverage with a parental leave top-up program

• Unlimited vacation/PTO: So you can be happy and healthy!

About Hive

Hive.co is a marketing platform for event marketers. We help brands personalize and automate their campaigns, using email and SMS, to empower them to sell out so they can focus on making their events unforgettable.

By integrating with ticketing partners like Ticketmaster and e-commerce partners like Shopify, we enable brands to access and act on all their customer data, so they can easily segment their list in thousands of ways, and send more customized, timely email campaigns that land in inboxes.

We started our company inside a University of Waterloo computer lab in early 2014, graduated from Y Combinator that summer (S14 batch) and have been growing ever since. Originally based in Kitchener, our team is now 100% remote and located all across Canada! We strive to provide an online work environment that allows team members to have a strong work life balance while still feeling connected to their team and Hive’s mission.

To learn more about our team check out our About Us page on our website: https://www.hive.co/company