Data Engineer

All Your BI; Rotterdam; Remote; EUR 38,000 - 48,000; Full time

Benefits offered by this job

Growth stipend

Vacation days

Trips abroad

Home-office budget

Remote-friendly

Team culture

Job summary

All Your BI is a remote-first data agency based in Rotterdam. We seek a Data Engineer with hands-on Azure experience to build end-to-end pipelines, warehouse layers, and BI delivery for logistics and industrial clients.

You will own data quality, model in Data Vault and 3NF, and deliver dashboards in Power BI while collaborating with a Europe-wide remote team. Candidates should have 5+ years of relevant work and strong English communication.

Qualifications

• 5+ years hands-on experience in data engineering and warehouse work.
• Deep relational-database skills: 3NF modelling and execution plans.
• Excellent T-SQL for transformations and loading.
• Hands-on Azure data engineering with ADF, Data Lake Gen2 and Azure SQL.
• Power BI experience: datasets, models, relationships and DAX.
• Data quality is built in and monitored with Git as a default.
• English communication with clients and remote teams.
• Nice to have: Data Vault 2.0, Python, Dremio, and logistics domain exposure.

Responsibilities

• Build and maintain end-to-end pipelines in the Azure stack.
• Ingest data into Data Lake and Azure SQL, orchestrated with ADF.
• Develop data warehouse layers: Data Vault to dimensional Data Mart.
• Write and optimise stored procedures for ETL and loads.
• Model hubs, links, satellites, and conformed facts in the vault.
• Understand source systems and reflect true data meaning.
• Deliver in Power BI with self-built datasets and models.
• Own data quality, validation, monitoring, and root-cause fixes.

Skills

Azure Data Factory

Data Lake Gen2

Azure SQL

Power BI

T-SQL

Data Vault modelling

3NF data modelling

Data quality monitoring

Git

Python

Dremio

English communication

Logistics domain knowledge

Tools

Git

Dremio

Job description

Maybe you call yourself a Data Engineer or a Data Specialist or a BI Developer or a Data Architect or an Azure Developer, or maybe you just call yourself Alex? This vacancy is part of our Delivery team and applies to all the above titles.

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.
• Fullyremote,fromanywhereinEurope,ideallywithinacoupleofhoursofCET,sotheteamoverlaps.

Benefits across the EU: the perks above are AYBI's and go to everyone, everywhere. Statutory benefits (pension, health, social security, leave, sick pay, notice) follow the hire's country via their local contract or EOR.

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 in with T-SQL · Azure (Data Factory, Data Lake Storage Gen2, Azure SQL) · Power BI · Git — plus Data Vault and dimensional modelling.

What you bring

• ~5+ years hands-on, across data engineering and database development. We weight depth and range over the exact number, but this isn't a junior seat; you've owned real warehouse work, not just touched it.
• Real relational-database depth: you model in 3NF, read an execution plan, tune a slow query, and work confidently in the Data Vault layer beneath the mart, not just the semantic layer on top.
• Excellent T-SQL: especially stored procedures for transformation and loading.
• Hands-on Azure data engineering: you've built end-to-end pipelines with ADF, Data Lake Gen2 and Azure SQL.
• You build in Power BI, not just consume it: datasets/semantic models, relationships, DAX, reports.
• A reliability habit: data quality validated and monitored as part of the work, Git as a default, and the confidence to trace a broken pipeline/proc/DB project to root cause and fix it calmly.
• Communication: fully comfortable in English to collaborate with clients and a remote team.
• Nice to have: experience with Data Vault 2.0 specifically (hubs, links, satellites, hash keys); knowledge in Python; exposure to a semantic-layer tool such as Dremio; background in operational / logistics / industrial domains (e.g. ports, terminals, maintenance/CMMS, IoT-style event data).

We're 60+ data heroes across Europe, and we hire to widen that mix, not narrow it. What matters is what you can do and the perspective you bring, not your age, gender, ethnicity, orientation, disability, background, or where you studied.