As a Data Warehouse Developer, you ensure that data from various source systems is securely and efficiently unlocked. A central data warehouse forms the backbone of the data infrastructure. Your work ensures that the organization has reliable insights, enabling quick and effective responses to changes and growing information needs. You will work closely with colleagues inside and outside the team and contribute to the further development of the data architecture.
What you will do.
- Maintain and optimize the data warehouse, with attention to performance and data quality.
- Develop and implement existing and new ETL processes, using SQL Server Integration Services (SSIS).
- Design Raw Data Vault and dimensional models for data loading.
- Integrate data via Pro2SQL for data from the primary system and via API connections for data from SaaS solutions.
- Collaborate closely with colleagues inside and outside the team, including a team that develops dashboards and reports with Qlik Sense.
- Delve into new technological developments to apply up-to-date methods and techniques in the field of data warehousing and ETL processes.
Profile
You work independently and accurately, but also attach great importance to good collaboration. You have a keen eye for detail, are able to solve complex problems, and have a strong drive to share knowledge and improve processes. Within the team, the T-shaped mindset is central: you delve into your own specialization, but also have an eye for the broader context and coherence within the organization.
What they ask
- Minimum HBO (higher professional education) working and thinking level.
- Minimum 2 years of relevant work experience.
- Experience with SQL Servers (versions 2019 and 2022) and underlying components, such as Change Data Capture (CDC), T-SQL, and SQL Server Integration Services (SSIS) for implementing ETL processes.
- Knowledge and experience in developing ETL loading streams.
- Knowledge and experience with modeling techniques Data Vault and Kimbal dimensional modeling.
Preferences.
- Knowledge of Powershell and VB-scripting.
- Knowledge and experience with Azure DevOps (repo, pipelines).
About the organization. The organization has been accommodating asylum seekers in reception centers since 1994. In these centers, basic facilities and guidance are offered for their future in the Netherlands or abroad. The organization is always in motion and responds to opportunities.
How to apply
View the full assignment text and application details once your tailored application is ready.
Order a tailored application to view the full assignment and application details.
More context, less searching.
You get enough context to judge whether this job is relevant. The full brief, client details and next steps stay available inside the app.