{"id":6028,"date":"2020-02-13T12:51:45","date_gmt":"2020-02-13T11:51:45","guid":{"rendered":"https:\/\/onlu.ch\/projects\/data-warehouse\/"},"modified":"2025-07-23T10:03:28","modified_gmt":"2025-07-23T08:03:28","slug":"data-warehouse","status":"publish","type":"portfolio","link":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/","title":{"rendered":"Data Warehouse"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Data warehouse to fulfill regulatory requirements in the financial sector<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Data Warehouse & Reporting Platform<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

As part of this project, we were jointly responsible for ensuring compliance with regulatory requirements in the financial sector. The following tasks played a central role in this: <\/p>\n

Design of the data warehouse<\/strong> (DWH): Our task was to design a high-performance data warehouse capable of processing and storing large volumes of data. The DWH formed the basis for fulfilling the regulatory reporting requirements.<\/strong> <\/p>\n

Provider management: <\/b>We were responsible for working with an external data provider who supplied us with the required data. This included coordinating the data deliveries, ensuring data quality and solving any delivery problems. <\/p>\n

Software design and implementation: <\/b>Together with the reporting department, we designed, implemented and rolled out a customized software solution. This solution enabled automated data checks to monitor the quality of information from different providers. <\/p>\n

Requirements analysis: <\/b>We carried out a detailed analysis of the requirements to ensure that the software solution developed contained all the necessary functions and met the needs of the various departments. In addition to the purely technical requirements, a large number of quality features were also worked out, which were taken into account in the design and implementation of the software.
<\/p>\n

OpenShift deployments: <\/b>As part of the project, we deployed the software solution on the OpenShift platform to ensure a scalable and reliable environment for running the applications.<\/p>\n

The challenge was to deal with a significant amount of data coming from different sources. We also had to ensure that the information could be consolidated in (quasi-)real time and presented in various reports and dashboards. Thanks to the successful implementation of this project, regulatory requirements were met and reporting efficiency was significantly improved. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Problem definition<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Scaling with large amounts of data<\/a><\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLaunch Project<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Technologies & Tools<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
  • Python<\/li>
  • Angular<\/li>
  • Snowflake<\/li>
  • SQLAlchemy<\/li>
  • OpenShift<\/li>
  • Pandas<\/li>
  • FastAPI<\/li>
  • ArgoCD<\/li>
  • PyCharm<\/li>
  • DBeaver<\/li>
  • Visual Studio Code<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    Activities<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t
    • Data Warehouse design<\/li>
    • Vendor management<\/li>
    • Software design & implementation<\/li>
    • Requirement Analysis<\/li>
    • OpenShift deployments<\/li>
    • Development of dashboards<\/li><\/ul><\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

      Data warehouse to fulfill regulatory requirements in the financial sector Data Warehouse & Reporting Platform As part of this project, we were jointly responsible for ensuring compliance with regulatory requirements […]<\/p>\n","protected":false},"author":9,"featured_media":5193,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"portfolio_category":[],"class_list":["post-6028","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nData Warehouse - ONLU AG<\/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:\/\/onlu.ch\/en\/projects\/data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Warehouse - ONLU AG\" \/>\n<meta property=\"og:description\" content=\"Data warehouse to fulfill regulatory requirements in the financial sector Data Warehouse & Reporting Platform As part of this project, we were jointly responsible for ensuring compliance with regulatory requirements […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"ONLU AG\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-23T08:03:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/07\/projects-zug.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/\",\"url\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/\",\"name\":\"Data Warehouse - ONLU AG\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/onlu.ch\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/projects-zug.jpg\",\"datePublished\":\"2020-02-13T11:51:45+00:00\",\"dateModified\":\"2025-07-23T08:03:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/onlu.ch\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/projects-zug.jpg\",\"contentUrl\":\"https:\\\/\\\/onlu.ch\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/projects-zug.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/data-warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/onlu.ch\\\/en\\\/home-page\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Projects\",\"item\":\"https:\\\/\\\/onlu.ch\\\/en\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/onlu.ch\\\/en\\\/\",\"name\":\"ONLU AG\",\"description\":\"Massgeschneiderte Software \u2013 Ihr hoch-qualifiziertes IT Team\",\"publisher\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/onlu.ch\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#organization\",\"name\":\"ONLU AG\",\"alternateName\":\"ONLU.CH\",\"url\":\"https:\\\/\\\/onlu.ch\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/onlu.ch\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/onlu-logo-red-arrow.png\",\"contentUrl\":\"https:\\\/\\\/onlu.ch\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/onlu-logo-red-arrow.png\",\"width\":800,\"height\":221,\"caption\":\"ONLU AG\"},\"image\":{\"@id\":\"https:\\\/\\\/onlu.ch\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/ch.linkedin.com\\\/company\\\/onlu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Warehouse - ONLU AG","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:\/\/onlu.ch\/en\/projects\/data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Data Warehouse - ONLU AG","og_description":"Data warehouse to fulfill regulatory requirements in the financial sector Data Warehouse & Reporting Platform As part of this project, we were jointly responsible for ensuring compliance with regulatory requirements […]","og_url":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/","og_site_name":"ONLU AG","article_modified_time":"2025-07-23T08:03:28+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/07\/projects-zug.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/","url":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/","name":"Data Warehouse - ONLU AG","isPartOf":{"@id":"https:\/\/onlu.ch\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/07\/projects-zug.jpg","datePublished":"2020-02-13T11:51:45+00:00","dateModified":"2025-07-23T08:03:28+00:00","breadcrumb":{"@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlu.ch\/en\/projects\/data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/#primaryimage","url":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/07\/projects-zug.jpg","contentUrl":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/07\/projects-zug.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/onlu.ch\/en\/projects\/data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/onlu.ch\/en\/home-page\/"},{"@type":"ListItem","position":2,"name":"Projects","item":"https:\/\/onlu.ch\/en\/projects\/"},{"@type":"ListItem","position":3,"name":"Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/onlu.ch\/en\/#website","url":"https:\/\/onlu.ch\/en\/","name":"ONLU AG","description":"Massgeschneiderte Software \u2013 Ihr hoch-qualifiziertes IT Team","publisher":{"@id":"https:\/\/onlu.ch\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlu.ch\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/onlu.ch\/en\/#organization","name":"ONLU AG","alternateName":"ONLU.CH","url":"https:\/\/onlu.ch\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlu.ch\/en\/#\/schema\/logo\/image\/","url":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/06\/onlu-logo-red-arrow.png","contentUrl":"https:\/\/onlu.ch\/wp-content\/uploads\/2023\/06\/onlu-logo-red-arrow.png","width":800,"height":221,"caption":"ONLU AG"},"image":{"@id":"https:\/\/onlu.ch\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/ch.linkedin.com\/company\/onlu"]}]}},"_links":{"self":[{"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/portfolio\/6028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/comments?post=6028"}],"version-history":[{"count":2,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/portfolio\/6028\/revisions"}],"predecessor-version":[{"id":6034,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/portfolio\/6028\/revisions\/6034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/media\/5193"}],"wp:attachment":[{"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/media?parent=6028"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/onlu.ch\/en\/wp-json\/wp\/v2\/portfolio_category?post=6028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}