Metehan Ilter

Iiot Business Data Analyst @Factorypal

Berlin, DE

Led the overhaul of the Analytics Module at the intersection of Data Analytics and Analytics Engineering.• Built modular dbt models across raw, staging, intermediate, and mart layers in Snowflake, following modern data modeling best practices.• Increased dashboard refresh rate by 24x (from daily to hourly) while maintaining performance, providing near real-time visibility into key KPIs.• Reduced data model costs by up to 89% through incremental modeling and optimized range joins.• Reconfigured dbt project architecture to integrate Iceberg Tables into the staging layer.• Developed and maintained +15 Tableau dashboards, including 4 embedded in the FactoryPal application — one becoming a flagship \"killer feature\" and a key product differentiator.• Implemented 2 new KPIs into the FactoryPal application.• Collaborated with Product and Customer Success teams to evolve analytics capabilities, directly improving operational transparency and customer satisfaction via SQL-based ad-hoc analysis.