Gerald Gastgeb - Data Warehouse Architect and Lead Data Modeler

Q: Where is Gerald based?

Gerald is based in Vienna, Austria and can operate in on-site , hybrid , and remote work models.

Q: What languages does Gerald speak?

Gerald speaks the following languages: German (Native), English (Advanced), French (Elementary) .

Q: How many years of experience does Gerald have?

Gerald has at least 29 years of experience. During this time, Gerald has worked in at least 20 different roles and for 27 different companies . The average length of individual experience is 1 year and 11 months . Note that Gerald may not have shared all experience and actually has more experience.

Q: What is Gerald's latest experience?

Gerald's most recent position is Data Design Authority at Department of Government Enablement .

Q: What companies has Gerald worked for in recent years?

In recent years, Gerald has worked for Department of Government Enablement , Lidl Stiftung & Co KG , and Gastgeb Consulting GmbH .

Q: Which industries is Gerald most experienced in?

Gerald is most experienced in industries like Professional Services , Telecommunication , and Retail . Gerald also has some experience in Banking and Finance , Information Technology (IT) , and Transportation and Logistics .

Q: Which business areas is Gerald most experienced in?

Gerald is most experienced in business areas like Information Technology (IT) , Business Intelligence , and Strategy and Planning . Gerald also has some experience in Project Management , Quality Assurance (QA) , and Product Development .

Q: Which industries has Gerald worked in recently?

Gerald has recently worked in industries like Professional Services , Retail , and Government and Public Administration .

Q: Which business areas has Gerald worked in recently?

Gerald has recently worked in business areas like Strategy and Planning , Information Technology (IT) , and Business Intelligence .

Recommended expert

Vienna, Austria

Experience

Jul 2025 - Present

8 months

Abu Dhabi, United Arab Emirates

Hybrid

Data Design Authority

Department of Government Enablement

Responsible for realigning the data architecture of the Abu Dhabi government to achieve a fully AI-driven public administration
Definition of modeling standards
Creation of a conceptual and logical model for the entire Abu Dhabi government administration
Definition of data quality and data security standards

Nov 2018 - May 2025

6 years 7 months

Heilbronn, Germany

Hybrid

Data Warehouse Architect and Lead Data Modeler

Lidl Stiftung & Co KG

Responsible for building and leading the architecture team at Lidl/Kaufland (about 15 architects and data modelers)
Definition of architecture standards and modeling guidelines
Design of a conceptual enterprise data model and a business glossary
Design of a semantic layer for the Lidl Enterprise Data Warehouse
Technical leadership of a team of 8 analysts and developers
Project planning and setup
Design of a dimensional data model for enterprise reporting
Responsible for analysis, data mapping and development
Lead data modeler for building a logistics DWH
Architect for migrating the data warehouse from Teradata to Snowflake
Definition of the target architecture consisting of a data lake in Microsoft Azure and a data warehouse in Snowflake
Architect for defining an integrated data quality concept based on Ab Initio Metadata Hub and Snowflake
Lead architect for designing a new enterprise data warehouse model
Technical leadership of about 15 architects and analysts
Creating specifications and guidelines for a team of about 30 developers
Requirements analysis
Modeling of an integration layer and a presentation layer
Responsible for business analysis and mapping of source data
Consulting on the design of a system for automated fraud detection
Consulting on the introduction of a data mesh concept

Aug 2018 - Oct 2018

3 months

Düsseldorf, Germany

BI Architect

Vodafone Deutschland

Architect for Vodafone Germany's GDPR program
Creation of a concept for data deletion, masking and encryption
Definition of policies and architecture standards for a team of about 12 analysts

Aug 2016 - May 2018

1 year 10 months

Copenhagen, Denmark

Senior Data Model Consultant

Maersk Line

Responsible for designing an application layer for freight rate analysis
Solution architecture
Data modeling
Data mapping
Definition of modeling guidelines and architecture standards
Responsible for designing Maersk Line's new enterprise DWH
Relational and dimensional modeling
Technical leadership of a team of about 10 data modelers

May 2016 - Aug 2016

4 months

Vienna, Austria

Data Model Consultant

Erste Bank

Design of an application layer based on IBM BDW
Requirements analysis
Solution architecture
Training the client on using IBM BDW

Nov 2015 - Apr 2016

6 months

Vienna, Austria

Lead Data Modeler

Sberbank Europe

Logical and physical data modeling based on Teradata FSDM
Responsible for data mapping
End-user training

Sep 2015 - Nov 2015

3 months

Italy

Architect and Lead Data Modeler

Banca Intesa Sanpaolo

Functional leadership of a team of three data modelers and about 10 analysts
Definition of architecture standards and technical guidelines
Logical and physical data modeling based on Teradata FSDM
Responsible for data mapping

Jan 2015 - Jul 2015

7 months

Copenhagen, Denmark

Lead Data Model Consultant

unnamed telecommunications provider

Represented the client with the implementation partner
Responsible for creating a dimensional model based on IBM TDW
Oversaw data mappings

May 2014 - Dec 2014

8 months

Stockholm, Sweden

Lead Data Model Consultant

TeliaSonera

Definition of policies and data modeling standards
Represented TeliaSonera with implementation partners
Provided guidance to multiple data modelers in subprojects
Responsible for the core data model for the Carrier Services business unit
Responsible for the core and semantic data model for the Debt Collection Services business unit
Oversaw data mappings
Responsible for data model governance processes

Jan 2014 - May 2014

5 months

Data Warehouse Architect and Lead Data Modeler

Vodafone Group

Responsible for extending Vodafone Germany's data warehouse model to a standard solution for all Vodafone organizations in Europe
Design authority for the core data warehouse model
Definition of collaboration and governance processes
Consulting architect for Vodafone Greece's enterprise data warehouse
Consulting architect for Vodafone Turkey's enterprise data warehouse

Jul 2012 - May 2014

1 year 11 months

Düsseldorf, Germany

Data Warehouse Architect and Lead Data Modeler

Vodafone Deutschland

Responsible for defining the overall Data Warehouse architecture
Creating a conceptual data model based on Business Data Elements
Training on Data Warehouse methodology, data modeling and CLDM
Lead data modeler responsible for developing the EDWH model
Leading a team of around 15 business analysts and data modelers
Logical data modeling based on the Teradata CLDM
Responsible for data mapping and creating implementation guidelines
Responsible for creating the physical data model

Feb 2011 - Aug 2012

1 year 7 months

Vienna, Austria

Data Warehouse Architect and Lead Data Modeler

Raiffeisen Bank International

Pre-sales support for Teradata Austria
Solution architecture
Creating specifications and guidelines for a team of around 50 analysts and developers
Responsible for creating a conceptual data model using the Business Data Elements methodology
Lead data modeler responsible for developing the Enterprise Data Warehouse model
Functional lead for a team of 8 data modelers and business analysts
Logical and physical data modeling
Responsible for data mapping and creating implementation guidelines
Training and coaching RBI staff

Jan 2010 - Present

16 years 2 months

Owner and Principal Consultant

Gastgeb Consulting GmbH

Jul 2007 - Mar 2011

3 years 9 months

Vienna, Austria

Data Warehouse Architect and Lead Data Modeler

Bank Austria / UniCredit

Member of the architecture team
Customizing the Teradata FSLDM
Physical data modeling
Responsible for data mapping and implementation
End-user training and workshops
Technical lead for a reporting sub-project
Technical project management for a team of 4 consultants
Project planning
Requirements analysis and reverse engineering of existing processes
Architecture and design
Architect for migrating the Data Warehouse to a new core banking system
Technical project management for a team of around 15 analysts and designers
Logical and physical data modeling
Responsible for data mapping
Consulting architect for UniCredit Italy’s Data Warehouse
Responsible for logical and physical data modeling
Responsible for data mapping
Architect for Bank Austria CEE Data Warehouse (rollout in around 10 countries)
Logical and physical data modeling
Responsible for data mapping (around 10 analysts and developers)
Responsible for designing a MicroStrategy application layer
Lead architect for extending the Data Warehouse to a group-wide solution for UniCredit
Design authority for DWH architecture, data model and mapping
Creating specifications and guidelines for a team of around 120 analysts and developers across multiple countries
Co-responsible for developing a new semi-automatic data mapping process "Business Data Elements"

Aug 2006 - Apr 2007

9 months

Poole, United Kingdom

Data Warehouse Project

Barclays Bank

Database administration
Physical database design for an Active Warehouse application
Database architecture
Designing and implementing a metadata management solution

Aug 2004 - Jun 2006

1 year 11 months

Düsseldorf, Germany

Data Warehouse Project

Vodafone Deutschland

Database administration for the largest Teradata installation in Europe (168 nodes)
Performance monitoring and optimization
End-user and production support
Design and implementation of a performance and workload management solution

May 2004 - Jul 2004

3 months

Sydney, Australia

Data Warehouse Project

Optus

Creating an ETL architecture
Designing and developing load and transformation jobs
Sizing

Jul 2003 - Apr 2004

10 months

Bangkok, Thailand

Technical Project Lead

AIS

Technical project management for a team of 6 consultants
Creating technical designs and guidelines for two external development partners (around 50 consultants and programmers)
Solution design
Hardware sizing
ETL concept
Backup concept
Operations concept
Database setup and administration
Physical data modeling
Quality assurance of the implementation
Training and end-user workshops

May 2002 - Jul 2003

1 year 3 months

Düsseldorf, Germany

Data Warehouse Project

Metro AG

Redesign of the physical data model
Performance optimization
Design and implementation of data marts
Design of Metro-Link, a DWH portal for external partners
Migration from Teradata V2R3 to V2R4
Development of ETL jobs
Integration testing

Apr 2002 - Apr 2002

1 month

Austria

Consulting role

HP Österreich

Advising on the selection of various implementation proposals for a DWH project

Dec 2001 - Mar 2002

4 months

Vienna, Austria

Senior Consultant / Technical Project Manager

Danet GmbH

Concept for migrating the data warehouse of Telekom Austria AG from Teradata to HP Superdome / Oracle 9i
Technical project management for a team of 9 consultants/subcontractors
Analysis of the existing system
Architecture concept
Redesign of the data model and ETL processes
Operations concept
Data warehouse project for Raiffeisen Informatik Service Abroad
Technical project management for a team of 4 developers
Requirements analysis
Data modeling
Design of the ETL process

Feb 2001 - Dec 2001

11 months

Austria

Billing System Developer

atms

Requirements analysis
Design and data modeling
Development of the rating engine and billing database
Design and implementation of billing functionality
Hot billing
Simultaneous calculation of customer charges, interconnection charges, and service fees
Any billing cycles
Customer-specific tariff configuration
Integrated data warehouse functionality
Integrated customer service portal via web applications
Quality assurance
Consulting

Jan 2001 - Dec 2010

10 years

Consultant

Independent Consultant

Sep 2000 - Dec 2000

4 months

Austria

Integration of Telephony into Data Warehouse

Netway AG

Data modeling (logical and physical design)
Design and implementation of a freely configurable loading and transformation program
Implementation of all required transformations
Development of a front-end tool for configuring the entire loading and transformation process
Consulting

Aug 2000 - Aug 2000

1 month

Austria

Data Assessment for Telephony Call Data

Netway AG

Loading scripts
Data analysis and definition of required transformation steps
Advice on data usability and potential application areas

Mar 2000 - Aug 2000

6 months

Austria

Data Warehouse Project

UTA Telekom AG

Project planning
Requirements analysis
Data modeling (logical and physical design)
Load and transform scripts for CDRs and customer data
Load program for CDR tickets (fastload-inmod)
Database administration
Analyses and reports
Churn analysis

Aug 1999 - Sep 1999

2 months

Austria

Data Warehouse Project

UTA Telekom AG

Requirements analysis
Data modeling (logical and physical design)
Load and transformation scripts
Database administration
Analyses and reports

Jul 1997 - Sep 2000

3 years 3 months

Austria

Data Warehouse Project

Post and Telekom Austria

Responsible for the telephone call data area in the data warehouse
Data modeling (logical and physical design)
Design and implementation of a load and transform program for CDR tickets
Ensuring regular loads
Performance optimization
Analyses and user support
Integration of retail data from teller transactions in post offices into the data warehouse
Creating load and transform scripts

Jan 1997 - Dec 2001

5 years

Consultant for Data Warehouse Solutions

NCR / Teradata Austria

Jul 1996 - Sep 1996

3 months

Vienna, Austria

Project work

Institute for Computer Graphics, TU Vienna

Analysis of measurement data samples
Comparison of different modeling methods
Comparison of different compression methods
Recommendation for selecting a method
Development of a prototype for encoding

Aug 1994 - Sep 1994

2 months

Vienna, Austria

Internship

Danubia Ges.m.b.H.

Development of a control program for testing and calibrating electricity meters

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Professional Services (25 years), Telecommunication (9.5 years), Retail (7.5 years), Banking and Finance (7 years), Information Technology (6 years), and Transportation (5 years).

Professional Services

Telecommunication

Retail

Banking and Finance

Information Technology

Transportation

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (28 years), Business Intelligence (27 years), Strategy (25 years), Project Management (11.5 years), Quality Assurance (1.5 years), and Product Development (1 year).

Information Technology

Business Intelligence

Strategy

Project Management

Quality Assurance

Product Development

Summary

25 years of experience in designing and implementing enterprise data warehouse solutions in banking, retail, logistics and telecommunications

Data warehouse architecture
Technical project management
Data modeling
Relational and dimensional modeling, Data Vault, Anchor Modeling, semi-structured modeling (NoSQL)
In-depth knowledge of Teradata and IBM standard data models (Teradata FSDM and CLDM as well as IBM BDW and TDW)

Skills

Databases: Teradata, Snowflake, Netezza, Oracle, Mysql, Ms Sql Server, Ms Access, Mongodb
Cloud Platforms: Microsoft Azure, Snowflake
Architectures: Data Warehouse, Data Lake, Data Lakehouse, Data Mesh
Case Tools: Erwin, Powerdesigner, Ibm Infosphere Data Architect, Idera Er/studio, Hackolade
Standard Data Models: Teradata Communications Logical Data Model (Cldm), Teradata Financial Services Data Model (Fsdm), Ibm Ifw, Ibm Tdw, Ibm Bdw
Etl Tools: Ab Initio, Datastage, Odi, All Teradata Utilities On All Platforms
Olap Tools: Microstrategy, Business Objects
Programming Languages: C/c++, Java, Visual Basic, Pascal, Perl, Python, Javascript
Operating Systems: Windows, Ms-dos, Os/2, Os/390, Unix / Linux
Other: Html, Unix Shell Scripting, Git, Crm, Ss7, Vhdl

Languages

German

Native

English

Advanced

French

Elementary

Education

Oct 1991 - Jun 1998

Vienna University of Technology

Electrical Engineering / Computer Engineering · Vienna, Austria

Profile

Created

May 2025

Last Update

January 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Gerald based?

Gerald is based in Vienna, Austria and can operate in on-site, hybrid, and remote work models.

What languages does Gerald speak?

Gerald speaks the following languages: German (Native), English (Advanced), French (Elementary).

How many years of experience does Gerald have?

Gerald has at least 29 years of experience. During this time, Gerald has worked in at least 20 different roles and for 27 different companies. The average length of individual experience is 1 year and 11 months. Note that Gerald may not have shared all experience and actually has more experience.

What roles would Gerald be best suited for?

Based on recent experience, Gerald would be well-suited for roles such as: Data Design Authority, Data Warehouse Architect and Lead Data Modeler, BI Architect.

What is Gerald's latest experience?

Gerald's most recent position is Data Design Authority at Department of Government Enablement.

What companies has Gerald worked for in recent years?

In recent years, Gerald has worked for Department of Government Enablement, Lidl Stiftung & Co KG, and Gastgeb Consulting GmbH.

Which industries is Gerald most experienced in?

Gerald is most experienced in industries like Professional Services, Telecommunication, and Retail. Gerald also has some experience in Banking and Finance, Information Technology (IT), and Transportation and Logistics.

Which business areas is Gerald most experienced in?

Gerald is most experienced in business areas like Information Technology (IT), Business Intelligence, and Strategy and Planning. Gerald also has some experience in Project Management, Quality Assurance (QA), and Product Development.

Which industries has Gerald worked in recently?

Gerald has recently worked in industries like Professional Services, Retail, and Government and Public Administration.

Which business areas has Gerald worked in recently?

Gerald has recently worked in business areas like Strategy and Planning, Information Technology (IT), and Business Intelligence.

What is Gerald's education?

Gerald attended Vienna University of Technology for Electrical Engineering / Computer Engineering.

What is the availability of Gerald?

Gerald is immediately available full-time for suitable projects.

What is the rate of Gerald?

Gerald's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.