Grafana & Click House Analytics Engineer

Tata Consultancy Services; Boise (ID); On-site; USD 120,000 - 180,000; Full time

Job summary

Tata Consultancy Services in Boise, ID is seeking a seasoned Analytics Engineer to design, build, and maintain advanced dashboards and analytics pipelines using Grafana and ClickHouse. You will migrate and optimize SQL workloads, model data, and drive near real-time analytics and observability practices with cross-functional teams.

Responsibilities include assessing existing reports, creating reliable visualizations, implementing alerting, and documenting migration runbooks for operations and

Qualifications

• Strong experience designing Grafana dashboards with variables, templating, and alerting.
• Deep knowledge of ClickHouse architecture including merge tree engines, partitions, and materialized views.
• Expertise in converting SQL Server analytics and SSRS datasets to ClickHouse‑friendly SQL.
• Proficiency in query optimization and performance tuning for large-scale analytics.
• Experience with near real‑time analytics, data freshness, and SLA/SLO monitoring.

Responsibilities

• Assess existing SSRS reports and SQL Server assets; document datasets and migration complexity.
• Design and develop Grafana dashboards that replicate or enhance SSRS capabilities.
• Create and optimize ClickHouse SQL queries for large-scale analytics with proper data modeling and partitioning.
• Collaborate with data engineering to define ingestion and validation requirements for ClickHouse.
• Implement Grafana alerting for key metrics and configure routing/notifications.
• Validate outputs against legacy results and document changes in metrics or rules.
• Establish dashboard standards, naming conventions, access controls, and monitoring practices.
• Prepare migration runbooks and KT materials for operations.

Skills

Grafana dashboards

ClickHouse architecture

SQL

Query optimization

Near real‑time analytics

Observability practices

Collaboration & documentation

Tools

Grafana

ClickHouse

SQL Server

SSRS

Job description

Job Description

We are seeking a seasoned analytics engineer with deep experience in ClickHouse and Grafana orchestration, responsible for designing, building, and maintaining advanced dashboards and analytics pipelines.

Must Have Technical/Functional Skills

• Grafana dashboards, panels, visualizations and alerting
• ClickHouse architecture, schema design and data modeling
• ClickHouse 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

Qualifications

• 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 ClickHouse 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 ClickHouse‑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.