What are the responsibilities and job description for the Grafana & Click House Analytics Engineer position at Centraprise?
Job title: Grafana & Click House Analytics Engineer
Job Location: Boise, ID - Onsite
Job Type: Fulltime
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.
Key Responsibilities
- 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.