数据工程师
Data Engineer
也许你自称为数据工程师、数据专家、BI开发人员、数据架构师或Azure开发人员,或者你只是叫Alex?这个职位属于我们的交付团队,适用于以上所有职位名称。
你将获得
- 月薪3200–4000欧元(税前),根据职位、你的经验和当地市场而定。
- 每年5000欧元用于个人成长,你有真正的决定权如何使用。
- 25天年假+可购买最多10天+当地公共假期+可申请最长4个月的休假。
- 每年两次团队旅行+偶尔的聚餐和团队活动。
- 500欧元的居家办公预算和一台出色的笔记本电脑。
- 适时的“嘿,干得好,伙计!”。
- 全程远程办公,可在欧洲任何地方,最好是与CET时区相差几小时,以便团队有重叠时间。
欧盟范围内的福利:以上福利是AYBI提供的,适用于所有员工。法定福利(养老金、健康、社保、带薪休假、病假、通知期)根据雇佣所在国家通过当地合同或EOR来执行。
关于我们
All Your BI是一家以远程办公为先的数据机构,总部位于鹿特丹。自2019年以来,我们从一家精品咨询公司发展成为超过60名数据专家组成的国际数据团队,分布在欧洲各地。我们为物流和工业公司提供管理BI服务,帮助减少数据浪费并推动业务发展。我们热衷于让用户获得新见解并发现机会时的“哇”时刻。我们采用霍拉克里制度工作:少层级,多自主权。认真工作,认真娱乐。
工作内容
- 在Azure堆栈中构建和维护端到端的数据管道,将源数据导入数据湖和Azure SQL,使用Azure Data Factory进行编排。
- 从原始暂存层开始,通过数据仓库的Data Vault和Business Vault,构建维度数据集市,主要使用T-SQL。
- 编写和优化存储过程用于转换和加载(全量、增量和删除加载),包括基于水位线的增量处理。
- 正确建模数据,在仓库中设计中心、链接和卫星,在数据集市中设计一致的事实和维度。
- 调查和理解源系统(例如终端操作和维护系统),使模型反映数据的实际含义,而不仅仅是其结构。
- 在Power BI中交付成果,自己构建数据集/语义模型和报告,而不仅仅是打开别人的报告。
查看英文原文
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. If the role excites you and you bring most of it, apply: the people who add the most rarely tick every box.
Originally posted on Himalayas