Jan Milรกฤek
๐ I live in Prague
๐ ๏ธ Technical Expertise
Data Engineering
- PostgreSQL + TimescaleDB (data storage and time series)
- dbt (data transformations and modeling)
- Python + pandas (data processing and ETL)
- Airflow (workflow orchestration)
Business Intelligence & Analytics
- Power BI (enterprise dashboards and reports)
- Grafana (operational dashboards and data visualization)
- SQL (advanced querying and analytical functions)
- Excel/Power Query (business user analytics)
Cloud & Enterprise Platforms
- Microsoft Azure (certified Solutions Architect Expert)
- Microsoft 365 (enterprise integration and automation)
- Security & Compliance (certified Cybersecurity Architect Expert)
- Prometheus (monitoring and alerting)
๐ Teaching & Knowledge Transfer
SQL for IoT Data Analysis - High School Technical Education Program
Complete 9-week curriculum with custom-built learning tools
I designed, developed, and delivered a comprehensive program teaching SQL fundamentals through practical IoT data analysis to high school students. This project required building the entire technical infrastructure from scratch, including custom simulators and learning platforms.
Full-Stack Educational Solution:
- Custom SQL Simulator: Python-based platform built specifically for the course (GitHub)
- MQTT IoT Simulator: Real-time sensor data simulation for hands-on learning (GitHub)
- Complete Curriculum: 9-week structured program from SQL basics to professional dashboards
- Modern Pedagogy: Progressive skill building with practical, project-based learning
Technical Achievement:
- Built custom learning tools - No existing solutions met educational requirements
- Full-stack development - Python-based simulators, data processing, real-time IoT data
- Scalable architecture - Supported entire class with real-time interactions
- Open source contribution - Tools available on GitHub for broader educational use
Educational Impact:
- High school students successfully created professional Grafana dashboards
- Real-world skills - Students learned industry-standard tools and practices
- Technical literacy - Complex data concepts made accessible to teenage learners
- Career preparation - Direct pipeline to data engineering and analytics careers
๐ Certifications That Matter
Microsoft Certified Expert Level:
- Azure Solutions Architect Expert
- Cybersecurity Architect Expert
- Microsoft 365 Enterprise Administrator Expert
Current Data Platform Certifications:
- Microsoft Fabric Data Engineer Associate (2025)
- Microsoft Fabric Analytics Engineer Associate (2025)
- Azure Data Engineer Associate (2024)
- Power BI Data Analyst Associate (2023)
๐ญ Professional Philosophy
"Experience teaches you what actually works long-term"
- Sustainable over clever: I choose maintainable solutions that teams can support for years
- Proven over cutting-edge: Battle-tested tools beat the latest trends when reliability matters
- Business value first: Technical decisions should always serve clear business objectives
- Knowledge sharing: Complex systems need clear documentation and transferable skills