Data Warehouse Developer

Design, build, and maintain scalable data warehouse solutions that enable reliable analytics, reporting, and data-driven decision-making. - Develop and optimize ETL/ELT pipelines to ingest, transform, and validate data from multiple sources. - Model data using dimensional and relational techniques (e.g., star/snowflake schemas) to support BI and analytics. - Implement and maintain data warehouse objects such as tables, views, stored procedures, and materialized aggregates. - Ensure data quality through profiling, reconciliation, monitoring, and automated testing. - Improve performance via indexing, partitioning, query tuning, and workload optimization. - Collaborate with analysts, engineers, and stakeholders to translate business requirements into technical solutions. - Document data definitions, lineage, transformations, and operational runbooks. Required skills - SQL expertise and experience with data warehouse development best practices. - Hands-on experience with at least one major data platform (e.g., Snowflake, Redshift, BigQuery, Azure Synapse, SQL Server). - Experience with ETL/ELT tools or frameworks (e.g., dbt, Informatica, SSIS, Airflow). - Understanding of data governance, security, access controls, and compliance requirements. - Strong troubleshooting skills, attention to detail, and ability to work in agile delivery environments. Bij het COA Bij het COA staan we voor maatschappelijke impact, en data is hierin onmisbaar. Ons datawarehouse-team speelt een sleutelrol in het dat…