Data Engineer - Data Warehouse

Project overview

Assignment Description

You will work on a migration project in a data warehouse (SQL Server) and Power BI on-premise reporting environment. The data warehouse (SQL Server) of the Rijksschoonmaakorganisatie (RSO) will be migrated to the Directie Samenwerkingsverbanden en Uitvoering (DSU) by early 2027. To ensure this migration proceeds smoothly, we are looking for a Data Engineer. In addition to the data warehouse migration, the integration of a new source is planned prior to this migration. This involves replacing an existing source with a new one based on a low-code platform (Mendix).

As a data engineer, you will ensure that all data from the old source is correctly transferred to the new source and that reporting needs can continue to be met. Naturally, you will ensure the quality of the data is in order and properly document the origin, lineage, and descriptions of the data (metadata).

The assignment consists of 2 parts:

The work will take place within a team. The data engineer is primarily responsible for the back-end part of the data warehouse.

Profile Sought

We are not just looking for a developer who performs tasks, but a professional who takes initiative, shows ownership, and actively contributes to technical improvements. Furthermore, it is essential that someone can quickly grasp the subject matter and translate it into working solutions.

The ideal candidate:

Practical Matters

Work will take place in The Hague. Remote work is possible, but preferably in the office. Especially during the onboarding phase.

The team works agile / scrum.

What makes this assignment interesting?

The RSO and DSU are at the start of a great collaboration within the Ministry of Social Affairs and Employment with this migration. With this assignment, you will get a look into both organizations. You are at the inception of a collaboration that can further expand. There is good energy in the team and a pragmatic way of working together.

Background Assignment

In 10 years, the Rijksschoonmaakorganisatie has grown into an organization with over 1700 employees and nearly 600 buildings that are cleaned. Buildings of the Central Government, the First Chamber, the Second Chamber, and the Council of State. Our focus in the coming period is on the further development of (internal) processes and the organizational structure to remain future-proof and stable. For the data warehouse and BI environment, we will outsource management to an internal department within our Ministry of Social Affairs and Employment.

The RSO originated from the decision to manage the cleaning services of government buildings in-house. The government wants to set a good example as an employer by also employing staff in lower salary scales themselves. The Rijksschoonmaakorganisatie (RSO) is the cleaning service provider for and by the Central Government. Together with other service providers, we work daily to ensure a clean, healthy, and pleasant workplace for colleagues within the Government. We do this professionally, customer-oriented, reliably, and cost-consciously.

To provide quality, we consider people's experience of their work environment. We achieve results through clear communication with clients, collegial cooperation between our cleaning teams, colleagues, and partners within the Government, and transparency about our services. The RSO stands for sustainable, efficient, and respectful deployment of people, materials, and resources. The craftsmanship of our employees forms the basis of our services, and within the organization, they have the space to develop further. As an employer, the RSO offers every employee a good, healthy, and enjoyable job.

The RSO is positioned under the Deputy Secretary-General (pSG) of SZW, who is ultimately responsible for the functioning of the RSO. The staff of the RSO is located in The Hague; operational activities take place throughout the country. The RSO is managed by the Director, supported by the Head of Operations and the Head of Business Operations & Administrative Support.

• Preparing the current data warehouse and its associated loading processes as well as possible. This includes:
• Integrating the new source (CSV files).
• Finalizing the latest requirements regarding loading processes for reports that are already available. You will collaborate with the business analyst and reporting employee of RSO on this.
• Migration of the RSO data warehouse to DSU in collaboration with DSU.
• Has extensive experience with VBA, SQL Server, SSIS Packages (ETL loading processes), C#
• Is able to get up to speed quickly, given the short turnaround times.
• Has knowledge and experience in data modeling and documenting the origin, route, and description of data (metadata and lineage).
• Wants to understand where the data comes from and how it relates to each other.
• Experience with migration projects.
• Has a proactive attitude, asks questions, and identifies bottlenecks.

Requirements

Wishes

Additional Information

When you offer a professional to us as a supplier and they are placed, we will need information from you as a contracting party, including regarding the Chain and Principal Liability Act (Wet keten- en inlenersaansprakelijkheid - WKA). The 'WKA' aims to prevent abuse in the remittance of payroll taxes at all links in the chain; from supplier to client. We cover these risks for our clients through a blocked account, the G-account. This is an account to which a portion of the invoice amount is deposited and from which you can pay payroll taxes and VAT to the Tax Authorities.

The percentage to be deposited depends on whether you have a SNA certification (NEN-4400-1 or NEN-4400-2) and whether your company is based in the Netherlands or abroad. You can apply for the G-account from the Tax Authorities. If you cannot obtain a G-account (and you can provide proof of this from the Tax Authorities), you also have the option to submit an accountant's statement (assurance report regarding personnel lending) quarterly. In this, a certified accountant (AA or RA) will issue a statement on the accuracy, completeness, and timeliness of the remittances.

Please note that the costs for this statement are at your own expense.

• Candidate possesses at least HBO work and thinking level.
• Candidate possesses demonstrable knowledge of VBA, SQL Server, SSIS Packages, C#.
• Candidate possesses at least 3 years of demonstrable experience as a data warehouse back-end developer.
• Degree to which the candidate possesses knowledge of VBA, SQL Server, SSIS Packages, C#.
• Degree to which the candidate has experience with migration projects.
• Degree to which the candidate possesses the required competencies and skills (verifiable in CV, motivation, and/or possible interview).
• Degree to which the candidate can indicate that they can work constructively within the organizations and establish and maintain relationships.

Project details

• Start: 2026-11-08T23:00:00
• Location: Den Haag Zuid-Holland, NL
• Languages: Dutch