Working Student Analytics Engineer (m/w/d)

Department: Data & BI

Location: Berlin | Global Team

Employment Type: PartTime

As a Working Student Analytics Engineer, you will get hands-on with the systems and data that power decisions across the entire business. You will write real SQL, ship production dbt models, help maintain a modern data warehouse, and see your work land in the reports leadership actually runs on. This is a part-time (Werkstudent) role where you take ownership of your own small projects end to end, from raw data to actionable insight, with room to grow your responsibilities as your skills develop.

PERGOLUX designs and sells Scandinavian-inspired outdoor living products, from pergolas to garden furniture, directly to consumers. With around 300 employees, 9-figure revenue, and operations across 8 markets, we build our data systems with the same care and precision as our products, guided by integrity, innovation, ambition, and unity.

What You'll Do

• Help build and maintain our Snowflake data warehouse with dbt, and contribute to the migration of our ERP pipelines

• Support the team in defining and developing core metrics that steer business performance

• Build and iterate reports in Looker, turning raw data into insights the business acts on

• Monitor data health, proactively flagging gaps, freshness issues, and quality problems

• Take on your own small projects across the stack (Airbyte for ingestion, Snowflake as the warehouse, Python for the messy bits, dbt for transformation and orchestration) and ship them
  

What You'll Bring

• Currently enrolled in a Bachelor's or Master's program (Data Science, Statistics, CS, Business Analytics, or related), or a solid self-taught track record

• Solid SQL fundamentals, comfortable writing complex queries and full-fledged models well beyond a basic SELECT

• Business intuition: before running a query, you weigh whether asking "why does this number look like that?" will drive real decisions

• Technical curiosity about end-to-end data architecture and a critical mindset for getting the most out of AI tools while knowing where they fall short, plus professional working proficiency in English

• Nice to have: exposure to dbt, Airbyte, Snowflake, Looker, or Python; familiarity with e-commerce data (Shopify, Klaviyo, GA4); a GitHub, portfolio, or side project you are proud to talk about
  

💼 Compensation — 16 Euro/hour

🚀 Growth and Career Development — You will work alongside a lean, senior data team who explain the "why" instead of just handing you tickets, take real ownership of shippable projects from the start, gain full-stack exposure to a modern data platform and a live ERP migration, and build fast-track career momentum and a resume-worthy portfolio as PERGOLUX scales.

⏰ Time Off and Flexibility — Up to 30 vacation days, starting at 27 · One week per year remote workation in EU/UK

🌟 Benefits and Lifestyle

• International, collaborative team, working with colleagues across Europe

• Regular team events (summer party, Christmas party, after-work gatherings) and retreats

• Modern setup and laptops (Apple or Windows)

• Employee discounts on PERGOLUX products

• Jobrad / Bike leasing program, promoting sustainable and healthy commuting
  

How to Apply

Ready to ship real data work while you study? Apply through our Career Page and connect with us on LinkedIn. We would love to see what you bring to the table.

PERGOLUX is an equal opportunity employer. We welcome applicants from all backgrounds, we think it's less about ticking every box and more about what you bring to the table!