Key responsibilities：
Design and develop BI dashboards in Power BI or Grafana for facial recognition analytics
Extract, transform, and model data from ClickHouse to optimize dashboard performance Write efficient SQL queries for data extraction and aggregation
Ensure dashboards are user-friendly, performant, and scalable
Optimize dashboard performance for large datasets
Skills & Qualifications：
Strong experience in Power BI or Grafana
Proficiency in SQL, with experience in ClickHouse (or other columnar databases)
Knowledge of data modeling (star schema, dimensional modeling)
Experience with ETL processes
Familiarity with time-series data
Basic knowledge of Python for data processing
Knowledge of dashboard optimization for large datasets
Knowledge of Apache Kafka
Familiarity with cloud platforms (Azure)
Preference on communication in Cantonese/English