Scroll To View More
Stefan Fuchs, Data Warehouse Design Developer in Vienna, Austria
Stefan Fuchs

Data Warehouse Design Developer in Vienna, Austria

Member since April 28, 2018
Stefan is a passionate data engineer and data warehouse developer who knows how to build complex, scalable data processing flows and data structures for data analysis. He has worked with Oracle, Postgres, diverse BI-Platforms (QV, SAP BO, Cognos) and focused on BigData processing (Apache Kafka, Spark, Cassandra) over the last two years.
Stefan is now available for hire



  • Database Development, 18 years
  • Data Warehouse Design, 10 years
  • Oracle Application Express (APEX), 6 years
  • Scala, 2 years
  • Apache Cassandra, 2 years
  • Apache Kafka, 2 years
  • Spark, 2 years
  • Spring Boot, 2 years
Vienna, Austria



Preferred Environment

IntelliJ, Bitbucket, Jira, Slack, Windows, Ubuntu

The most amazing...

...project I've worked on was a recursive decent parser for Oracle SQL functions including analytical functions for a sophisticated syntax highlighter.


  • Data Engineer

    2015 - 2018
    • Redesigned the category data structure in the OLTP DB.
    • Contributed to optimizing the data model and stored procedures in collaboration with the Java developers.
    • Redesigned the data pipeline from the OLTP-system to the BI Tool (QlikView).
    • Supported the setup of a Cassandra cluster.
    • Developed an event collector including some Java components such as Spring Boot, Kafka, and Cassandra.
    • Supported the setup of a Spark cluster.
    • Developed Spark jobs (using Scala) to aggregate the collected event data.
    Technologies: Scala, Java, Spring, Cassandra,Spark, Kafka, QlikView, SAP Sybase, Postgres
  • BI Specialist

    2014 - 2015
    Coface Austria
    • Migrated and redesigned the data warehouse.
    • Redesigned the BO Universe (meta-data layer).
    • Implemented the ETL using PL/SQL.
    • Built the UI for data maintenance using Oracle APEX.
    Technologies: Oracle, SAP Business Objects, PL/SQL, Oracle APEX
  • Team Lead CRM & Reportng Systems Pharma Germany

    2011 - 2014
    Berlin-Chemie AG
    • Managed all systems related to the support of the pharma sales force in Germany (reporting, CRM, and territory management).
    • Served as an internal consultant to the sales and product management.
    • Engineered requirements for a new CRM.
    • Migrated Access apps to Oracle using APEX as UI.
    Technologies: Oracle, Cognos, APEX, Access
  • Sales Controller (Field Force Evaluation)

    2004 - 2010
    Berlin-Chemie AG
    • Created standard reports.
    • Developed report automation.
    • Provided ad-hoc analysis.
    • Defined KPIs.
    • Designed and calculated Bonus System.
    Technologies: Access, Excel, Cognos, Oracle SQL/plSQL
  • Junior Sales Controller

    2001 - 2003
    Berlin-Chemie AG
    • Developed standard reports.
    • Automated reports.
    • Provided ad-hoc analysis.
    Technologies: Cognos, Excel, Access, GIS-Tools


  • Event Collector (Development)

    The events are sent to a Kafka Queue that is consumed by multiple instances of a Java component that is writing the data to a Cassandra DB.

    The setup handles currently 2k events per second but is able to scale linear horizontally. The system is highly available due to multiple instances (respectively partitions).


  • Languages

    SQL, Scala, T-SQL, Java 8
  • Paradigms

    Database Design, ETL Implementation & Design, Agile Software Development, Object-oriented Programming (OOP), Database Development, Functional Programming, MVC Design, Design Patterns, Requirements Analysis
  • Frameworks

    Spark, Spring Boot, Spring IoC, Spring MVC
  • Platforms

    Oracle, Apache Kafka, QlikView
  • Storage

    PL/SQL, PostgreSQL, Spring Data for Apache Cassandra, Database Modeling
  • Other

    Apache Cassandra, Data Warehouse Design, SAP BusinessObjects (BO)
  • Tools

    Oracle Application Express (APEX), IntelliJ


  • Master of Arts degree in IT Management
    2012 - 2015
    FOM - Berlin, Germany
  • Bachelor of Arts degree in Business Administration
    2009 - 2011
    VWA - Berlin, Germany
  • Diploma in Informatik-Betriebswirt (IT & business administration)
    2006 - 2009
    VWA - Berlin, Germany
  • Education and apprenticeship in Informatikkaufmann (IT economics)
    1998 - 2001
    OSZ für Industrie und Datenverarbeitung and Berlin-Chemie AG - Berlin, Germany
I really like this profile
Share it with others