Data Architect

About the jobAs a recruitment company, DCG understands that every business is powered by experienced professionals. Our management style and partnership approach enable us to meet your needs and provide continuous support. Due to our ongoing growth and the large number of recruitment projects we undertake for our partners, we are currently looking for:Data Architect100% remoteB2B contractResponsibilities:Designing the Kimball Data Model for a new data warehouseDeveloping and implementing ETL processesBuilding the query layerDesigning and implementing Slowly Changing DimensionsPreparing a Proof of Concept covering: the Data Warehouse layer, ETL processes, the analytical engine (Analysis Engine)Requirements:Hands-on experience in designing and implementing Data Warehouses, including infrastructure-level workStrong knowledge of the Kimball Data Model or similar data warehouse design conceptsAdvanced knowledge of Microsoft SQL ServerHands-on ETL design and development experienceExperience using AI tools supporting design and developmentAbility to design: slowly Changing Dimensions, analytical and intermediate layers, reporting-oriented data modelsAbility to clearly present and explain professional experiences in a business-friendly mannerStrong technical competencies: SQL Server, ETL, KimballProven experience in building commercial data warehouses from scratchExcellent communication and collaboration skills, proactivenessAbility to work in project environments and deliver complete end-to-end solutionsEnglish at minimum B2+, ideally C1Offer:Private medical careCo-financing for the sports cardConstant support of dedicated consultantEmployee referral program