> Markdown version of [/jobs/ext/1309038-grafana-click-house-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1309038-grafana-click-house-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Grafana & Click House Analytics Engineer - **Company:** Stanley David and Associates - **Location:** Boise, ID, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Data Analysis, Business Logic, Data Validation, Information Engineering, Data Infrastructure, Database Queries, Shard (Database Architecture), Microsoft SQL Server, Performance Tuning, Query Optimization, SQL Databases, SQL Server Reporting Services, Transact-SQL, Grafana, Templating, Data Management, Vertica - **Published:** July 17, 2026 - **Apply:** https://www.dice.com/job-detail/6b9a5a80-d464-4d0e-8384-5bef491a1e01 ## About the Role 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. ## Description Assess existing SSRS reports and SQL Server analytics assets, document report inventory, datasets, dependencies, calculations, filters, and migration complexity. - Design and develop Grafana dashboards that replicate or enhance existing SSRS reporting capabilities using reliable visualizations, variables, and user-friendly navigation. - Create and optimize ClickHouse SQL queries for large-scale analytics with appropriate data modeling, partitioning, sorting keys, materialized views, and query tuning techniques. - Collaborate with data engineering teams to define ingestion, transformation, and data validation requirements for ClickHouse as the target analytics platform. - Implement Grafana alerting for key operational/business metrics, including severity levels, thresholds, routing, and notification configuration. - Validate report outputs against legacy SSRS/SQL Server results, reconcile discrepancies, and document any changes in metric definitions or business rules. - Establish dashboard performance standards, reusable patterns, naming conventions, access controls, and monitoring best practices. - Prepare technical documentation, migration runbooks, KT materials, and support handover to operations/business users. ## Related Videos - [Backstage Software Templates for Java Developers](https://www.wearedevelopers.com/videos/1596-backstage-software-templates-for-java-developers) - [5 steps for running a Kubernetes environment at scale](https://www.wearedevelopers.com/videos/88-5-steps-for-running-a-kubernetes-environment-at-scale) - [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse) - [All your telemetry data from any source in one place](https://www.wearedevelopers.com/videos/57-all-your-telemetry-data-from-any-source-in-one-place) - [Keycloak case study: Making users happy with service level indicators and observability](https://www.wearedevelopers.com/videos/1599-keycloak-case-study-making-users-happy-with-service-level-indicators-and-observability) - [Backstage in Practice: Offloading Developer Operational Work Through Platform Self-Service](https://www.wearedevelopers.com/videos/1922-backstage-in-practice-offloading-developer-operational-work-through-platform-self-service) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Effortlessly Scale Prometheus With The Telemetry Data Platform – And Keep your Grafana Dashboards, Too!](https://www.wearedevelopers.com/magazine/3-effortlessly-scale-prometheus-with-the-telemetry-data-platform-and-keep-your-grafana-dashboards-too) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Dev Digest 139 - Soft and hard queries](https://www.wearedevelopers.com/magazine/487-dev-digest-139-soft-and-hard-queries) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)