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.

Work arrangement
No