Lead Data Engineer
KLAY SchoolsBangalore, IndiaOn-Site
Needs a free Superjobs account. You'll finish on KLAY Schools's site.
Skill score
Summary
This person owns the architecture, build, and operation of KLAY's central ClickHouse data platform, building ELT/ETL pipelines from school, CRM, finance, and attendance systems and delivering Grafana dashboards. The role suits a senior data engineer with deep ClickHouse and pipeline experience who can also set team engineering practices as the company's first data hire.
- Function
- Data Science
- Estimated salary
- Est. ₹16–25 LPA
- Estimated for a manager role, ~6 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Bangalore, India
- Experience
- 6–10 yrs
Job description
Overview
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.
Roles and 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.
Skills required
Top skills
- ClickHouse
- Grafana
- ELT/ETL pipelines
- Data modeling
All skills (8)
- Data governance
- CI/CD for data
- Python
- Advanced SQL
- REST API integration
- Apache Airflow
- Prefect
- Data privacy
Qualifications
- 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: Strong 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.
Other details
- 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.
Company info
About KLAY Schools
KLAY Schools operates preschool and daycare centres in India, offering playgroup, nursery, kindergarten and afterschool childcare programs for young children. Its services are used by families who want early childhood learning and care for their children.