Data Engineer

All Your BI; United States; Remote; USD 40,000 - 50,000; Full time

Benefits offered by this job

Two trips abroad per year

€500 home-office budget

Great laptop

25 vacation days + buy up to 10 days

Sabbatical option

Job summary

All Your BI, a remote-first data agency based in Rotterdam, seeks a data engineer to build end-to-end Azure pipelines and deliver BI solutions across Europe. You will ingest data into the Data Lake and Azure SQL, architect Data Vault and dimensional models, and optimize T-SQL ETL processes.

You will also design datasets and semantic models in Power BI and own data quality with monitoring. English communication with clients and a remote team is essential.

Qualifications

• 5+ years hands-on data engineering and database development.
• Depth in relational databases; 3NF modelling and query tuning.
• Excellent T-SQL for transformation and loading.
• Hands-on Azure data engineering with ADF, Data Lake Gen2, Azure SQL.
• Power BI data modeling and reports; datasets and semantic models.

Responsibilities

• Build and maintain end-to-end pipelines in the Azure stack.
• Ingest source data into the Data Lake and Azure SQL, orchestrated with Azure Data Factory.
• Develop data warehouse layers from raw staging through Data Vault and dimensional model.
• Write and optimise stored procedures for ETL loads (full, incremental, delete).
• Deliver in Power BI; ensure data quality, monitoring, and issue resolution.

Skills

Data pipelines

Azure Data Factory

Azure Data Lake Gen2

Azure SQL

Power BI

T-SQL

Data Vault

Dimensional modeling

Python

DAX

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. Fully remote, from anywhere in Europe, ideally within a couple of hours of CET, so the team overlaps. 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.

Requirements

• 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.