Lead Data Engineer (Bengaluru)

Lead Data Engineer (Bengaluru)

17 Nov
|
Klay
|
Bengaluru

17 Nov

Klay

Bengaluru

Lead Data &

- Analytics Engineer

IT &

- Data — reports to SVP IT

Role Summary

KLAY's data is fragmented across school-management, CRM/admissions, finance, and attendance systems, making most reporting manual. As the first data hire, this role owns the architecture, end-to-end development, and operational performance of KLAY’s central data platform. You will build automated, reliable ELT/ETL pipelines, model operational data into ClickHouse, and deliver real-time operational and executive dashboards using Grafana.

The high-performance data engine you build will serve as the foundation for all downstream analytics and enterprise AI applications.

Key Responsibilities

- Data Platform &
- ClickHouse Architecture: Architect, deploy, and manage a scalable central data platform using ClickHouse as the core analytical engine to ingest, aggregate, and query data across school management systems, CRM/admissions, HR/payroll, finance/ERP, and center-level tools.

- Pipeline Engineering: Design, build, and maintain production-grade ELT/ETL pipelines leveraging modern orchestrators (e.g., Apache Airflow, Prefect, or custom Python pipelines) to stream and batch data reliably into ClickHouse.

- Data Modeling: Design ClickHouse schemas, MergeTree engines, materialization strategies, and data models tailored for fast analytical queries across key metrics—center performance, enrollment funnels, staff-to-child ratios, billing/collections, and parent engagement.

- Visualization &

- Dashboards via Grafana: Build and maintain Grafana dashboards as the primary monitoring and BI layer, enabling real-time self-service insights for finance, operations, marketing, and center management.

- Governance &

- Quality: Establish data quality checks, automated testing, access control standards, and data governance across all pipelines.





- Business KPI Alignment: Partner with business stakeholders to define and standardize core metrics (e.g., occupancy rates, churn, lead-to-enrollment conversions, collection efficiency).

- AI &

- Integration Readiness: Ensure ClickHouse data structures and query interfaces are optimized for fast retrieval by downstream AI agents and integration services.

- Team Leadership: Establish engineering best practices (version control, CI/CD for data, schema migration management) and assist in hiring future data engineers and analysts.

Requirements

- Experience: 6–10 years in Data Engineering or Analytics Engineering, with 2 years owning a production data warehouse/data engine end-to-end.

- Primary Analytics Database: Robust hands-on experience and expertise with ClickHouse (table engines, schema design, query optimization, and performance tuning).

- Visualization: Hands-on experience designing and building production dashboards in Grafana connected to SQL/ClickHouse datasources.

- Pipeline &
- Tools: Experience building ETL/ELT pipelines using Airflow, Prefect, or custom Python connectors to parse third-party SaaS REST APIs.

- Languages: Advanced SQL and Python proficiency.

Domain

Experience (Nice to Have): Experience in multi-location retail, education, franchising, or childcare environments, with awareness of data privacy standards (e.g., India’s DPDP Act).

Nice to Have

- Experience in a multi-location, franchise, retail, or education business.

- Experience handling data-privacy requirements for sensitive data, including children's data.

Success in the First 6 Months

- Production ClickHouse central data warehouse live with at least 3–4 core source systems integrated.

- Grafana dashboards operational for top recurring business metrics (enrollment, occupancy, collections), eliminating manual spreadsheet reporting.

-

📌 Lead Data Engineer (Bengaluru)
🏢 Klay
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: lead data engineer (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: lead data engineer (bengaluru) / bengaluru