Data Engineer

All Your BI; Rotterdam; Hybrid; EUR 36,000 - 45,000; Full time

Benefits offered by this job

€5,000 growth budget per year

25 vacation days + buy up to 10 more

€500 home-office budget

Fully remote across Europe

Job summary

All Your BI, a remote-first data agency based in Rotterdam, seeks a data professional to build end-to-end pipelines in Azure, model data in the Data Vault, and deliver Power BI reports for clients across Europe.

You will own data quality, work with T-SQL, Data Factory, Data Lake Gen2, and Azure SQL, and communicate with remote teams in English. The role requires ~5 years in data engineering with warehouse experience.

Qualifications

• 5+ years hands-on data engineering and warehouse development experience.
• Strong relational data modelling with Data Vault 2.0 familiarity preferred.
• Deep knowledge of T-SQL, stored procedures and transformations.
• Hands-on Azure data stack: ADF, Data Lake Gen2, Azure SQL.

Responsibilities

• 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 so the model reflects what the data means.
• Deliver in Power BI, building datasets/semantic models and reports yourself.
• Own data quality, building validation and monitoring into the platform, and debugging pipelines and DB projects.
• Wear the analyst hat, profiling new datasets, answering data questions, and validating numbers.

Skills

Data warehouse design

3NF modelling

T-SQL optimization

Azure data engineering

Power BI development

Data quality monitoring

English communication

Tools

Azure Data Factory

Azure Data Lake Gen2

Azure SQL

Power BI

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.