About this role
# 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.
