Data Engineer

What you get

• A salary between €3,200–€4,000/gross monthly, based on the role, your experience, and your local market.
• €5,000 a year for your own growth, with a real say in how you spend it.
• 25 vacation days + the option to buy up to 10 more + local public holidays + the option of a sabbatical up to 4 months.
• Two trips abroad a year with the whole team + occasional drinks and team outings.
• €500 home-office budget and a great laptop.
• A well-earned "Hey, well done Buddy!", so now and then.
• Fully remote, from anywhere in Europe, ideally within a couple of hours of CET, so the team overlaps.

About us

All Your BI is a remote-first data agency based in Rotterdam. Since 2019 we've grown from a boutique consultancy into an international data team of more than 60 data heroes spread across Europe. We deliver managed BI services for logistics and industrial companies, helping reduce data waste and move businesses forward. We live for the WOW moment, that sparkle in users' eyes when they gain new insights and discover opportunities. We work according to Holacracy: little hierarchy, lots of ownership. Serious work. Serious fun.

What the job looks like

• Build and maintain end-to-end pipelines in the Azure stack, ingesting source data into the Data Lake and Azure SQL, orchestrated with Azure Data Factory.
• Develop the data warehouse layers from raw staging through the Data Vault and Business Vault into the dimensional Data Mart, primarily in T-SQL.
• Write and optimise stored procedures for transformation and loading (full, incremental and delete loads), including watermark-driven incremental processing.
• Model data correctly, designing hubs, links and satellites in the vault, and conformed facts and dimensions in the mart.
• Investigate and understand source systems (e.g. terminal operating and maintenance systems) so the model reflects what the data really means, not just its shape.
• Deliver in Power BI, building datasets/semantic models and reports yourself, not just opening someone else’s dashboard.
• Own data quality, building validation and monitoring into the platform, and debugging broken pipelines, stored procedures or database projects without flinching.
• Wear the analyst hat, profiling new datasets, answering data questions directly, and validating that numbers reconcile before they reach the business.

You'll work with T-SQL, Azure (Data Factory, Data Lake Storage Gen2, Azure SQL), Power BI, Git, and Data Vault and dimensional modelling.