Senior Analytics Engineer

Overview

The Senior Analytics Engineer takes hands-on ownership of complex Analytics Engineering deliverables, designing, building, testing, troubleshooting, and delivering production-grade data solutions. The role focuses on data modelling, quality, automation and AI, performance optimisation, squad delivery, and mentoring while remaining a hands-on individual contributor.

What you'll do

• Design and build domain, dimensional, and semantic data models using Snowflake and dbt.
• Develop scalable, reusable, and maintainable Data Products aligned with enterprise modelling standards.
• Build efficient incremental models and optimise complex transformations for performance and cost.
• Understand end-to-end data lineage and work with source teams to resolve data gaps.
• Identify and remove duplicated, redundant, and deprecated models where appropriate.
• Implement data quality, integrity, and testing controls across data models.
• Ensure models comply with established coding, naming, documentation, and testing standards.
• Participate actively in PR reviews and DCB, providing technical feedback to other engineers.
• Investigate data quality issues, perform root-cause analysis, and implement sustainable fixes rather than downstream workarounds.
• Support implementation and adoption of Data Contracts for critical data elements.
• Build practical automation that improves development, testing, deployment, documentation, and monitoring.
• Develop solutions using Snowflake Cortex, LLMs, AI Agents, Python, and other relevant technologies.
• Contribute to reusable AI and automation capabilities rather than creating isolated solutions.
• Identify repetitive engineering activities that can be automated to improve squad productivity.
• Optimise Snowflake queries, dbt models, and warehouse consumption.
• Support migration of complex Tableau/custom SQL workloads into governed dbt models.
• Identify opportunities to improve model performance, reduce compute costs, and simplify the warehouse.
• Contribute to platform modernisation and technical-debt reduction initiatives.
• Work closely with Product, BI, Data Engineering, Governance, and source-system teams to deliver end-to-end solutions.
• Support investigation and resolution of production and data quality issues.
• Proactively identify technical risks, dependencies, and blockers and drive them towards resolution.
• Support cross-squad initiatives where specialist Analytics Engineering expertise is required.
• Support and mentor Analytics Engineers through pairing, code reviews, and technical guidance.
• Share reusable patterns, solutions, and lessons learned across squads.
• Contribute to engineering standards and Communities of Practice.
• Help raise overall engineering capability while remaining a hands-on individual contributor.

What you'll need

• Strong hands-on Analytics Engineering/Data Engineering experience, with expertise in Snowflake, dbt, SQL, and data modelling.
• Proven ability to personally design, code, test, troubleshoot, and deliver production-grade data solutions.
• Strong understanding of dimensional modelling, incremental processing, data quality, and performance optimisation.
• Experience working with Git, CI/CD, code reviews, and modern software engineering practices.
• Strong problem-solving skills with the ability to investigate complex data issues across source and downstream systems.
• Ability to take ownership of complex technical problems and drive them through to resolution.
• Experience supporting and mentoring other engineers while remaining an active individual contributor.
• Interest or practical experience in applying GenAI, LLMs, AI Agents, or Snowflake Cortex to Analytics Engineering.

Nice to have

• Strong Python experience.
• Experience with semantic layers, data contracts, lineage, and observability.
• Experience developing AI/automation solutions for data engineering.
• Experience with AWS and modern data integration patterns.
• Experience supporting Tableau or other enterprise BI platforms.

Details

• Location: Mumbai.
• Hybrid work arrangement (work from home/office).