Job Description
Must Have Technical/Functional Skills:
Grafana dashboards, panels, visualizations and alerting
Click House architecture, schema design and data modeling
Click House SQL, SQL Server to ClickHouse migration and syntax differences
Query optimization, performance tuning and large-scale analytics
Near real-time analytics, observability practices and collaboration/documentation

Roles & Responsibilities
• 5 to 8 years of experience in BI/reporting, analytics engineering, observability, or data platform
implementation.
• Hands-on experience building Grafana dashboards using variables, templating, transformations,
drilldowns, annotations, alert rules, notification channels/contact points, and dashboard-as-code
practices where applicable.
• Strong understanding of Click House architecture including Merge Tree engines, partitions, primary/sort
keys, materialized views, projections, compression, distributed tables, and replication/sharding concepts.
• Experience converting SQL Server / T-SQL based analytics, stored logic, or SSRS report datasets into
Click House-compatible SQL and optimized analytical query patterns.
• Ability to analyze existing SSRS reports, identify metrics/KPIs, map datasets, validate business logic,
and recreate equivalent or improved visualizations in Grafana.
• Strong SQL skills with focus on aggregation, window functions, joins, time-series queries, query profiling,
explain plans, and performance tuning for high-volume analytical workloads.
• Working knowledge of near real-time analytics pipelines, ingestion patterns, data freshness, alert thresholds,
SLA/SLO monitoring, and dashboard performance best practices.
• Ability to work with cross-functional teams, communicate migration risks, document assumptions, and
support UAT/business validation.

Grafana & Click House Analytics

Similar Other Jobs