An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsA 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
AI-generated from the job description. Check the full description before you apply.
Job Description
Lead Data & Analytics Engineer
Role Summary
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/CDApacheGrafanaCRMPayrollLeadershipIf 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 allLooking for something similar?
New Data Science Analytics & Machine Learning roles in BLR_Corporate Central.
One email a day. Unsubscribe any time.

