{"id":6619,"date":"2026-01-05T11:27:05","date_gmt":"2026-01-05T11:27:05","guid":{"rendered":"https:\/\/sumit.wordpress.avency.de\/portfolio\/data-warehousing-and-data-engineering\/"},"modified":"2026-02-28T09:22:41","modified_gmt":"2026-02-28T09:22:41","slug":"data-warehousing-and-data-engineering","status":"publish","type":"portfolio","link":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/","title":{"rendered":"Data Warehousing &#038; Data Engineering"},"content":{"rendered":"<p class=\"p1\">sumIT implements Data Warehousing and Data Engineering using a clearly structured, practice-oriented approach. The focus lies on building scalable, future-proof data platforms that combine technical robustness with business relevance. sumIT first analyzes existing system landscapes and business processes, defines target architectures together with the client, and develops modern data models based on these foundations.<\/p>\n<p class=\"p1\">In Data Engineering, robust ETL\/ELT processes, automated data pipelines, and quality-assured transformation workflows are implemented. Established cloud and on-premises technologies are selected in alignment with Swiss security and compliance requirements.<\/p>\n<p class=\"p1\">In Data Warehousing, sumIT places strong emphasis on performance, transparency, and governance. The resulting data foundation is characterized by high quality, consistency, and traceability. This ensures that integrated and structured data can be used not only for reporting and analytics, but also as a reliable basis for future AI analyses and data-driven applications.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sumIT implements Data Warehousing and Data Engineering using a clearly structured, practice-oriented approach. The focus lies on building scalable, future-proof data platforms that combine technical robustness with business relevance. sumIT first analyzes existing system landscapes and business processes, defines target architectures together with the client, and develops modern data models based on these foundations. In [&hellip;]<\/p>\n","protected":false},"featured_media":6617,"menu_order":0,"template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-6619","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Warehousing &amp; Data Engineering - sumIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Warehousing &amp; Data Engineering - sumIT\" \/>\n<meta property=\"og:description\" content=\"sumIT implements Data Warehousing and Data Engineering using a clearly structured, practice-oriented approach. The focus lies on building scalable, future-proof data platforms that combine technical robustness with business relevance. sumIT first analyzes existing system landscapes and business processes, defines target architectures together with the client, and develops modern data models based on these foundations. In [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/\" \/>\n<meta property=\"og:site_name\" content=\"sumIT\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-28T09:22:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/01\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"860\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/\",\"name\":\"Data Warehousing & Data Engineering - sumIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png\",\"datePublished\":\"2026-01-05T11:27:05+00:00\",\"dateModified\":\"2026-02-28T09:22:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png\",\"contentUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png\",\"width\":1536,\"height\":860},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/portfolio\\\/data-warehousing-and-data-engineering\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Warehousing &#038; Data Engineering\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\",\"name\":\"sumIT \u2013 get value from data\",\"description\":\"get value from data\",\"publisher\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sumit.ch\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#organization\",\"name\":\"sumIT \u2013 get value from data\",\"url\":\"https:\\\/\\\/sumit.ch\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/sumit_logo_RGB.svg\",\"contentUrl\":\"https:\\\/\\\/sumit.ch\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/sumit_logo_RGB.svg\",\"width\":198,\"height\":61,\"caption\":\"sumIT \u2013 get value from data\"},\"image\":{\"@id\":\"https:\\\/\\\/sumit.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Warehousing & Data Engineering - sumIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/","og_locale":"en_US","og_type":"article","og_title":"Data Warehousing & Data Engineering - sumIT","og_description":"sumIT implements Data Warehousing and Data Engineering using a clearly structured, practice-oriented approach. The focus lies on building scalable, future-proof data platforms that combine technical robustness with business relevance. sumIT first analyzes existing system landscapes and business processes, defines target architectures together with the client, and develops modern data models based on these foundations. In [&hellip;]","og_url":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/","og_site_name":"sumIT","article_modified_time":"2026-02-28T09:22:41+00:00","og_image":[{"width":1536,"height":860,"url":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/01\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/","url":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/","name":"Data Warehousing & Data Engineering - sumIT","isPartOf":{"@id":"https:\/\/sumit.ch\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/#primaryimage"},"image":{"@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/#primaryimage"},"thumbnailUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/01\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png","datePublished":"2026-01-05T11:27:05+00:00","dateModified":"2026-02-28T09:22:41+00:00","breadcrumb":{"@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/#primaryimage","url":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/01\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png","contentUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2026\/01\/Data_Warehousing_Data_Engineering_v3-e1771422606208.png","width":1536,"height":860},{"@type":"BreadcrumbList","@id":"https:\/\/sumit.ch\/en\/portfolio\/data-warehousing-and-data-engineering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/sumit.ch\/en\/"},{"@type":"ListItem","position":2,"name":"Data Warehousing &#038; Data Engineering"}]},{"@type":"WebSite","@id":"https:\/\/sumit.ch\/en\/#website","url":"https:\/\/sumit.ch\/en\/","name":"sumIT \u2013 get value from data","description":"get value from data","publisher":{"@id":"https:\/\/sumit.ch\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sumit.ch\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sumit.ch\/en\/#organization","name":"sumIT \u2013 get value from data","url":"https:\/\/sumit.ch\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sumit.ch\/en\/#\/schema\/logo\/image\/","url":"https:\/\/sumit.ch\/wp-content\/uploads\/2025\/10\/sumit_logo_RGB.svg","contentUrl":"https:\/\/sumit.ch\/wp-content\/uploads\/2025\/10\/sumit_logo_RGB.svg","width":198,"height":61,"caption":"sumIT \u2013 get value from data"},"image":{"@id":"https:\/\/sumit.ch\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/portfolio\/6619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"version-history":[{"count":3,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/portfolio\/6619\/revisions"}],"predecessor-version":[{"id":7015,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/portfolio\/6619\/revisions\/7015"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/media\/6617"}],"wp:attachment":[{"href":"https:\/\/sumit.ch\/en\/wp-json\/wp\/v2\/media?parent=6619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}