Jakob Zellman

Data Architect
10+
years of experience

Summary

10+ years of experience in data and analytics working both as consultant and managerial positions in data. Worked with data warehousing, business intelligence, applied AI and data strategy. Proficient in market leading products such as Snowflake, dbt, Qlik, Power BI, Azure and Python. Extensive business experience working closely together with controllers and CFOs for a sound understanding of business and how to maximize value and reduce overhead using data.

Key Competencies

Data WarehousingBusiness IntelligenceApplied AI & MLData StrategyCloud ArchitectureFinancial Systems Integration

Previous Missions

Volkswagen

Lead Data Architect

Helped Volkswagen build their data warehouse solution from scratch using dbt + Snowflake, creating a cross functional data warehouse for operation and financial data with Qlik Sense and Qlikview for reporting.

Challenges:

  • Build modern data warehouse from ground up
  • Integrate operational and financial data streams
  • Establish scalable reporting infrastructure

Key Deliverables:

  • Complete data warehouse architecture using Snowflake
  • dbt transformation models for data modeling and quality
  • Qlik Sense dashboards for operational reporting
  • QlikView reports for financial analysis
  • ETL pipelines connecting source systems

Impact: Enabled cross-functional data analysis combining operations and finance, providing unified reporting platform for business decision-making.

SnowflakedbtQlik SenseQlikViewSQLPython

Caspeco

Data Warehouse Consultant

Built Caspeco's (payment processing and restaurant management systems) data warehousing solution using TimeXtender, Azure and Power BI with integration to 10+ source systems.

Challenges:

  • Consolidate data from 10+ heterogeneous source systems
  • Handle payment processing and restaurant management data
  • Ensure data quality and consistency across systems

Key Deliverables:

  • TimeXtender-based data warehouse on Azure SQL
  • Integration layer for 10+ source systems
  • Power BI reporting solution
  • Azure Data Factory pipelines for data orchestration
  • Data quality framework and monitoring

Impact: Created single source of truth for payment and restaurant operations data, enabling comprehensive business analytics across the organization.

TimeXtenderAzure SQLPower BIAzure Data FactorySQL Server

Vitamin Well (Nocco, Barebells)

Senior Data Architect

Restructured Vitamin Well's (Nocco, Barebells) financial data warehouse in Azure Synapse to be harmonized across several countries and markets and utilize advanced row level access to properly serve financial data depending on each user's employment type and scope.

Challenges:

  • Harmonize financial data across multiple countries and markets
  • Implement granular access control for sensitive financial information
  • Ensure regulatory compliance for multi-market operations

Key Deliverables:

  • Restructured Azure Synapse data warehouse
  • Harmonized data model spanning multiple markets
  • Advanced row-level security implementation
  • Power BI reports with dynamic access control
  • Azure AD integration for user authentication

Impact: Delivered unified financial reporting across all markets while maintaining strict data governance and access control based on user roles and geographical scope.

Azure SynapsePower BIAzure ADSQLDAXRow-Level Security

Skills & Technologies

Data Platforms

SnowflakeAzure SynapseTimeXtenderdbtAzure Data FactoryDatabricks

BI & Analytics

Power BIQlik SenseQlikViewTableauExcel

Programming

SQLPythonDAXM (Power Query)TypeScript

Cloud Platforms

Microsoft AzureAWSAzure DevOpsGit
CV created byStormyran