Senior Data Engineer (f/m/d)

<h3>The position</h3> <p><em>If you are excited about growing with Hive and love operations, this might be the right position for you!</em></p><p>You’ll join as our first full-time data engineer, helping power our business, serve our customers better, and drive our data infrastructure. </p><p><strong>What you’ll be responsible for:</strong></p><p>Some exemplary topics of what we expect a data engineer to cover is below — an important note is that we’re not looking for someone that purely optimizes the technical aspects of what they’re doing, but that they’re doing it with their users (engineers, data analysts, PMs, …) and our customers in mind.</p><ul><li><p>Design, develop, and maintain scalable ETL/ELT processes to support data ingestion, transformation, and storage using dbt, Python, and Redshift.</p></li><li><p>Optimize and manage our data warehouse (Redshift) to ensure high performance, reliability, and low latency.</p></li><li><p>Architect, create, and maintain data models that reflect the needs of the business.</p></li><li><p>Develop data products to be integrated across our entire operations platform, such as:</p><ul><li><p>Merchant-facing analytics for dashboards and different views in our customer-facing applications</p></li><li><p>Operational analytics for data-driven decision making in our Warehouse Management Software</p></li><li><p>Delivery time prediction models to power our "Delivery Promise" functionality across applications, from the merchant's storefront to their tracking emails and customer-facing tracking portal.</p></li></ul></li></ul><p>Hive is building the leading operations platform for independent commerce. It’s time for us to take the next step and deeply invest in our data platform foundations as a key enabler to enhance the value of our multi-product offering. Better commerce operations for merchants, consumers, and our fulfillment network.</p><p><strong>What you’ll be doing:</strong></p><ol><li><p><strong>Data pipeline optimization: </strong>Redesign, build, and optimize ETL processes to reduce latency and improve performance for real-time analytics use cases.</p></li><li><p><strong>Scalable Data Warehouse setup</strong>: Help shape and implement a scalable data warehousing solution (e.g., in Redshift) to handle increasing data volumes and complex queries efficiently.</p></li><li><p><strong>BI enhancement:</strong> Guide data analysts to develop new dashboards and reporting solutions in Metabase, providing actionable insights.</p></li><li><p><strong>Data quality and consistency:</strong> Ensure comprehensive data quality and accuracy across all pipelines.</p></li><li><p><strong>Integration with product infrastructure: </strong>Work with engineering teams to integrate data solutions with our product stack, enabling seamless data flow and enhancing our capabilities across the entire platform.</p></li></ol>Collaboration across the business: Assess stakeholder needs across the Hive organization to drive decision-making and technical approaches proactively, ensuring different use cases are covered properly and thoroughly <h3>Your profile</h3> <p><em>We know - sometimes, you can’t tick every box. We would still love to hear from you if you think you’re a good fit!</em></p><ul><li><p><strong>You have the skills. </strong>Strong proficiency in SQL and significant experience with relational databases and data warehouse (e.g. Postgres and Redshift). Experience with (near) real-time data use-cases a plus.</p></li><li><p><strong>You get into the details.</strong> Hands-on experience with ETL/ELT tools and processes, BI tools like Mode/Metabase/Tableau, and cloud platforms like AWS.</p></li><li><p><strong>You write code. </strong>Proficiency in a programming language such as Python, and are experienced in managing data infrastructure via IaC tools like Terraform</p></li><li><p><strong>You know the theory, and the practice. </strong>Solid understanding of data warehousing concepts and best practices.</p></li><li><p><strong>You care about the craft</strong>. Excellent problem-solving skills and high attention to detail.</p></li><li><p><strong>You bring people along. </strong>Strong communication skills and the ability to work collaboratively in a team environment.</p></li></ul> <h3>Our offering</h3> <ul><li><strong>Be part of the Hive</strong>. You will work with a highly driven team of exceptional and experienced people in all domains. People at Hive have worked at organizations such as McKinsey, Amazon, Shopify, Google, Flink, Blackstone, J.P. Morgan &amp; DHL before. We believe in a culture of trust, collaboration, empowerment and constructive feedback in a positive and inspiring work atmosphere</li><li><strong>Make an impact.</strong> Join a young company with an entrepreneurial culture operating at lightning speed — we want you to grow with us</li><li><strong>You will be valued</strong>. We offer attractive compensation, including virtual employee stock options for all full-time team mem