About.
I build data platforms and make data ready for decisions and AI work.
Biography
The short version is ready for event listings; the long version gives the context.
Short bio · for event listings
Ahmet Kalafat is a Data Solution Architect at LC Waikiki, working on Google Cloud. Over 25 years he has moved from software engineering into data warehousing, big data and cloud. He designed and led the migration of the company's 80 TB enterprise data warehouse to BigQuery and designed Turkey's first Microsoft FastTrack data warehouse. He is a Google Cloud Certified Professional Data Engineer and writes on AI accountability.
Long biography
Data Solution Architect on Google Cloud. 25 years from software engineering into data warehousing, big data and cloud. For the last four years I’ve designed and led the migration and modernization of the enterprise data platform at LC Waikiki, a fashion retailer with 1,000+ stores in 50+ countries plus e-commerce: ~80 TB of analytical data, 100+ source systems, thousands of business users.
- Data platform architecture on GCP: BigQuery, Dataflow (Apache Beam, Java), Pub/Sub, Dataform, Cloud Composer, Cloud Storage, Cloud Run. Layered warehouse design (Landing / Staging / Core / Data Mart), dimensional modeling, ELT with versioned SQL, CI/CD and quality assertions across 3,000+ tables; catalog and lineage across 100+ sources.
- Cloud migration and cost engineering: designed and led the move of our SQL Server + Cloudera (15-node) warehouse to BigQuery: ~75% lower infrastructure cost, ~$550K saved per year, batch ~7x faster. A GA4 redesign cut monthly cost from $9K to $3K and took the heaviest queries from 46 minutes to 8 seconds.
- Streaming: the org-wide real-time pattern is Pub/Sub to Dataflow (Beam) to BigQuery via the Storage Write API, plus a reverse pipeline from BigQuery to SQL Server for operational systems.
- GenAI and AI governance: LLM agents with evaluation frameworks (golden, trajectory, injection, drift) for data onboarding, keeping production deterministic and auditable. I also write on AI accountability: who owns, stops and audits an AI decision.
Before GCP I built the SQL Server side of the same platform: Turkey’s first FastTrack data warehouse, a 15 TB SSAS OLAP estate, a metadata-driven SSIS framework; two were published by Microsoft as customer success stories.
I’ve also run the organisation: I built LC Waikiki’s first data engineering team and later led an 18-person data organisation with a $1M+ budget through the BigQuery migration. In 2024 I chose to step out of line management into a hands-on architect role, because the platform’s next phase (streaming, GenAI-enabled data products, FinOps at scale) needed design authority next to the code.
Today I set the target architecture, the modelling and quality standards and the reference implementations the data engineering and analytics teams build against, and run the architecture reviews and ADR process that keep them aligned.
Timeline
Role, organisation and a concrete outcome. Newest first.
— present
WorkNow
Data Solution Architect
LC Waikiki
Owns the target architecture, modelling standards and reference implementations for the Google Cloud data platform; runs architecture reviews and the ADR process.
—
Work
Senior Data Engineering and Data Architecture Group Manager
LC Waikiki
Led an 18-person data organization with a $1M+ budget through the 80 TB warehouse migration to BigQuery.
—
Work
Big Data Management and Data Architecture Manager
LC Waikiki
Owned the Cloudera Hadoop platform, the SQL Server warehouse and the OLAP layers; led a team of 8-12 and the ETL offload of 200+ jobs.
—
Work
Data Engineering Team Lead
LC Waikiki
Built the company's first data engineering team (4-6), a 15-node Cloudera CDH cluster and the first multi-source data lake.
—
Work
Data Architect
LC Waikiki
A 15 TB SSAS OLAP estate serving 4,800 users with sub-second response; columnstore indexes (35x compression); batch window cut from 7 hours to under 2.
—
Work
Senior Business Intelligence Developer
LC Waikiki
Designed Turkey's first Microsoft FastTrack data warehouse; built a metadata-driven SSIS framework adopted by 80+ pipelines.
—
Work
Senior Software Developer
Goldas Company
Developed a multi-language ERP (C#, SQL Server) for accounting, treasury and finance, and two e-commerce platforms.
—
Work
Technical Trainer
BilgeAdam Teknoloji
Taught software development, databases, web and Microsoft systems courses.
Education
MBA, Financial Economics
Marmara University
Education
BSc, Physics
Abant Izzet Baysal University
Skill groups
Tools and practices from the work above, grouped by area. No levels or ratings.
Cloud Data Platforms
- BigQuery
- Dataflow (Apache Beam, Java)
- Pub/Sub
- Dataform
- Cloud Composer (Airflow)
- Cloud Storage and Cloud Run
- Databricks and Delta Lake
- Azure Synapse and Data Factory
- Cloudera Hadoop
- SQL Server
Data Architecture
- Target architecture and reference implementations
- Layered warehouse (Landing, Staging, Core, Data Mart)
- Medallion layers (bronze, silver, gold)
- Batch and streaming architecture
- Cloud migration
- Architecture reviews and ADRs
Data Modeling
- Dimensional modeling (Kimball)
- Star schemas
- Semantic layer and OLAP (SSAS)
- Gold-layer data products
- Partitioning and clustering standards
Data Engineering
- ELT with versioned SQL
- Real-time pipelines with the Storage Write API
- Spark, Hive and Impala
- Metadata-driven ETL frameworks
- Orchestration with Airflow
- Python, Java and SQL
Governance & Quality
- Data quality assertions
- Anomaly detection
- Data catalog and lineage
- Metadata management
- Master data management (MDM)
- Data contracts
GenAI & AI
- LLM agents for data onboarding
- LLM evaluation (golden sets, trajectory, prompt injection, drift)
- Deterministic, auditable production runs
- LLM-based product normalization
- AI governance and accountability
DevOps & Cost
- CI/CD for data models
- Git, code review and automated testing
- On-call
- BigQuery FinOps (slot and storage design)
- Scheduled-query rationalisation
- Cost and performance guardrails
Recognition
Awards, customer success stories, talks and certification.
Two Microsoft global customer success stories
The FastTrack data warehouse and the OLAP semantic layer.
Komtas customer success story (2022–2024)
2nd place, IDC Turkey Awards
Azure reporting platform for 1,200+ business users.
Speaker, SQL Saturday Istanbul 2014
Google Cloud Certified Professional Data Engineer
Certification · Google Cloud · 2025–2027
Community
- Organizer, LCW Datathon 2019.
- Jury member and mentor, THY Travel Datathon 2019.
Shall we work together?