Grafana & ClickHouse Analytics Engineer

Veriipro; Boise (ID); On-site; USD 110,000 - 170,000; Full time

Job summary

Veriipro is seeking a Grafana & ClickHouse Analytics Engineer to lead dashboard development, analytics engineering, and observability on large-scale data platforms. The role emphasizes Grafana dashboards, ClickHouse data modeling, SQL optimization, and migration of SQL Server/SSRS analytics solutions, collaborating with engineering and business teams.

Ideal candidates will bring strong SQL skills, experience with near real-time analytics, and a proven ability to implement alerts, runbooks, and

Qualifications

• 5+ years of experience in BI reporting, analytics engineering, observability, or data platforms.
• Strong experience building Grafana dashboards, visualizations, alerts, variables, templating, and dashboard-as-code.
• Deep understanding of ClickHouse architecture, schema design, data modeling, and ClickHouse SQL.
• Experience with SQL Server to ClickHouse migration and query conversion.
• Strong SQL skills including: complex queries, aggregations, joins, window functions, query optimization.
• Experience with ClickHouse features: MergeTree engines, partitions, primary/sort keys, materialized views, distributed tables, replication and sharding.
• Experience with near real-time analytics, monitoring, alerting, and observability practices.

Responsibilities

• Analyze existing SSRS reports and SQL Server analytics assets for migration.
• Design and develop Grafana dashboards to replicate and enhance reporting capabilities.
• Develop and optimize ClickHouse data models and analytical queries.
• Implement Grafana alerts, thresholds, and notification workflows.
• Validate migrated reports and ensure data accuracy.
• Collaborate with engineering and business teams on requirements, UAT, and documentation.
• Create migration documentation, runbooks, and knowledge transfer materials.

Skills

Grafana Dashboards

ClickHouse

SQL optimization

SSRS migration

Analytics engineering

Observability

Data platforms

Tools

Grafana

ClickHouse

Job description

We are seeking a Grafana & ClickHouse Analytics Engineer with strong experience in dashboard development, analytics engineering, observability, and large-scale data platforms. The ideal candidate will have hands-on expertise with Grafana, ClickHouse, SQL optimization, and migration of SQL Server/SSRS analytics solutions.

Required Skills

• 5+ years of experience in BI reporting, analytics engineering, observability, or data platforms
• Strong experience building Grafana dashboards, visualizations, alerts, variables, templating, and dashboard-as-code
• Deep understanding of ClickHouse architecture, schema design, data modeling, and ClickHouse SQL
• Experience with SQL Server to ClickHouse migration and query conversion
• Strong SQL skills including:
  • Complex queries
  • Aggregations
  • Joins
  • Window functions
  • Query optimization and performance tuning
• Experience with ClickHouse features:
  • MergeTree engines
  • Partitions
  • Primary/Sort keys
  • Materialized views
  • Distributed tables
  • Replication and sharding
• Experience with near real-time analytics, monitoring, alerting, and observability practices

Responsibilities

• Analyze existing SSRS reports and SQL Server analytics assets for migration.
• Design and develop Grafana dashboards to replicate and enhance reporting capabilities.
• Develop and optimize ClickHouse data models and analytical queries.
• Implement Grafana alerts, thresholds, and notification workflows.
• Validate migrated reports and ensure data accuracy.
• Collaborate with engineering and business teams on requirements, UAT, and documentation.
• Create migration documentation, runbooks, and knowledge transfer materials.