Lead Data Engineer

Department Icon Data Science Analytics & Machine Learning
Posted: 2 hours ago
8-15 years
BLR_Corporate Central, India
Data Science Analytics & Machine Learning
work from office
Full Time
Closes 16 Jan 2027

Posted: 2 hours ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

AI Summary
Job Description
Similar Jobs
Please verify your account first! Send OTP

AI summary of this job

Beta Read in 10 seconds

A Lead Data Engineer role at Klay in BLR_Corporate Central, India for people with 8–15 years of experience. You'll build automated, reliable ELT/ETL pipelines, model operational data into ClickHouse, and deliver real-time operational and executive dashboards using Grafana.

  • Work from office
  • 8–15 years

What you'll do

  • Build automated, reliable ELT/ETL pipelines
  • Model operational data into ClickHouse
  • Deliver real-time operational and executive dashboards

Good fit if you

  • Have advanced SQL and Python proficiency
  • Bring 8–15 years of experience
  • Build production dashboards in Grafana
Sounds like you? Applying takes under a minute.

AI-generated from the job description. Check the full description before you apply.

Helpful?

Job Description

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: 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.

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.

Skills

PythonSQLData EngineeringAirflowETLData ModelingCI/CDApacheGrafanaCRMPayrollLeadership

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Data Science Analytics & Machine Learning roles in BLR_Corporate Central.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.