Senior Analytics Engineer

Job Title: Senior Analytics Engineer

Position: Full Time | Bengaluru

About BrightCHAMPS

BrightChamps is a fast-growing EdTech company building learning experiences that help children

develop real-world skills and confidence. We blend pedagogy, technology, and data to create scalable

learning programs.

About the Role

We are looking for a Senior Analytics Engineer to build and maintain reliable data pipelines, analytics models and reporting datasets across marketing, sales, finance and learning operations. This is a hands-on role requiring strong SQL, Python and data engineering skills. You will work closely with analysts, Technology and business stakeholders to deliver accurate, timely and secure data while improving infrastructure reliability, performance and cost.

Key Responsibilities

● Build scalable pipelines: Integrate databases, CRM, marketing platforms and application events using

reliable ETL/ELT workflows.Ensure trusted data:

● Develop reusable analytics models and automate validation, reconciliation, freshness and

schema-change checks.

● Own reliability: Monitor pipelines and reporting dependencies, resolve incidents within agreed SLAs and

prevent recurring failures.

● Improve performance and cost: Optimise queries, scheduling and infrastructure capacity; reduce manual

effort and technical debt.

● Maintain engineering standards: Apply code reviews, deployment checks, rollback procedures and

tested recovery processes.

● Secure analytics systems: Manage access across the warehouse and BI tools, protect sensitive data and

coordinate with Technology/Security.

● Deliver business requirements: Partner with analysts and stakeholders to establish consistent metric

definitions and deliver datasets and automation within agreed timelines.

● Document and improve: Maintain documentation and knowledge resources, share best practices and use

validated AI tools to improve productivity.

Required Skills & Experience

● 3–4 years of hands-on experience in analytics engineering, data engineering or a similar role.

● Strong SQL, including complex joins, window functions, query optimisation and indexing.

● Proficiency in Python for data processing, automation and API integrations.

● Experience building and supporting production ETL/ELT pipelines, including incremental loads, retries

and backfills.

● Strong understanding of data modelling, warehousing and reusable reporting datasets.

● Experience with PostgreSQL and/or MySQL, including performance troubleshooting.

● Working experience with AWS services such as S3, Glue, Lambda and DMS, or comparable cloud

services.

● Experience implementing data quality checks, monitoring, alerting and failure recovery.

● Familiarity with Git, code reviews, deployment practices and secure handling of sensitive data.

● Hands-on experience using AI tools to improve SQL/Python development, troubleshooting, data

validation and documentation, with responsibility for validating outputs and protecting sensitive data.

Good to Have

● Experience with Metabase, Amazon QuickSight and Zoho CRM.

● Exposure to dbt, Airflow or similar transformation and orchestration tools.

● Experience integrating Meta Ads, Google Ads or other marketing platforms.

● Understanding of marketing attribution, customer funnels and event-level data.

● Experience handling multiple time zones, currencies and customer identity mapping.