Hey there! 👋 I'm Ilias, a passionate analytics engineer who combines data engineering, analytics, and automation to build scalable data solutions.

• Analytics Engineer II @ Snowplow ❄️ (Remote) 2024-Present

  • 🛠️ Maintain source-available dbt packages for multiple data warehouses and lakes (Snowflake, Redshift, Databricks, PostgreSQL, Spark/Iceberg, BigQuery)
  • 📊 Develop internal data models for product analytics
  • 🤖 Create and maintain the LLM Agent Tracking solution
  • ⚡ Co-led development of the Snowplow Signals Python SDK with automated dbt project generation
  • 🔄 Implement streaming components (Bento, Redis) for real-time data processing
  • 🎯 Design a dynamic API system with a pseudo semantic layer for flexible attribute definitions
  • 🐳 Drive DataOps initiatives (Docker, GitHub Actions, Spark deployments)

• BI Analyst @ Blueground 🏙️ (Athens) 2021-2024

  • 📈 Led domain ownership for Finance, Real Estate, Product, People, and Ops Excellence
  • 🚀 Pioneered self-serve analytics reaching ~200 daily active users
  • 💾 Spearheaded PostgreSQL to Snowflake/DBT migration
  • 💵 Architected financial model for management reporting and RE decisions
  • 🤖 Developed OpenAI-powered Slack bot with RAG and custom Metabase integrations
  • 📊 Unified departmental KPIs for 500+ employee performance tracking
  • 📱 Managed product analytics using GA data

• CVM Intern @ Vodafone 📱 (Athens) 2019

  • 📊 Prepared corporate account renewals and product mix reports
  • 🔍 Explored IoT solution opportunities

• IT Intern @ Roche 💊 (Athens) 2016

  • 🖥️ Managed IT inductions and workstation setups
  • 💡 Proposed productivity improvements through tech innovation

• University of Patras 🏛️
  • Integrated Master's in Electrical and Computer Engineering (300 ECTS)
  • Thesis: "Predicting Box Office Revenue Using ML Techniques" 🎬

• 🎥 Movie Search Engine: Streamlit-based ML recommendation engine using MovieLens dataset
• 📱 E-Learning Redesign: UX evaluation and redesign of Zoom's tablet app
• 📰 Fake News Detector: Neural network for news headline classification
• 🏎️ Fast & Curious: Python optimization techniques workshop (IEEE)
• 💾 SQL Zero to Hero: SQL fundamentals workshop (IEEE)
• 🐼 How to Train Your Pandas: Data manipulation masterclass (IEEE)

• Core Competencies

  • 📊 KPI Design & Implementation
  • 💰 Financial Modeling & Analysis
  • 🤖 Machine Learning
  • 🔍 Data Quality & Testing
  • ⚡ Process Automation
  • 📈 Metabase Expert (Development & Administration)

• Data Engineering & Processing

  • 🏭 Batch: dbt, Spark, Iceberg
  • 🔄 Streaming: Redis, Bento, Kinesis, Pub/Sub
  • 💾 Warehouses & Lakes: Snowflake, Databricks, BigQuery, PostgreSQL, Redshift
  • 🗄️ Storage: S3, GCS

• Programming & Development

  • 🐍 Python (SDK Development, API Design)
  • 📊 SQL (Analytics, Performance Tuning)
  • 🔄 Git, GitHub Actions, Docker

• Analytics & Data

  • 📈 BI: Metabase, Tableau, Looker
  • 🎯 Semantic Layer Design
  • 📊 Product Analytics & Tracking
  • 📐 Data Modeling & Quality

• Cloud Services

  • ☁️ AWS: S3, Kinesis, Glue, Athena
  • 🌐 GCP: BigQuery, Pub/Sub, GCS
  • 🚀 Infrastructure & Security

• 🌌 Science Festival Contributor.
• 🤖 IEEE Uni of Patras Leadership.
• 🌐 Love for Travel

• 📊 Data Product Manager Nanodegree (Udacity)
• 💼 Business Strategy by Section/Scott Galloway
• 📈 Customer & Operation Analytics (Wharton School)

• 📧 Email: ilias.xenogiannis@gmail.com
• 💼 LinkedIn
• 📝 Medium
• 🐙 GitHub

🌍 Fluent in English and Greek. Always excited to collaborate on projects that push the boundaries of data engineering and analytics. Let's connect! 🤝