Analytics Engineer(Position located in Bengaluru, India)

Overview

Analytics Engineer designing and building analytics transformation and semantic layers that deliver governed, analysis-ready datasets for reporting and analytics.

What you'll do

• Build and maintain the dbt transformation layer (staging → intermediate → marts) with dimensional modeling, tests, and documentation.
• Translate reporting and analytics requirements from business stakeholders into well-modeled, certified data definitions and BI-ready datasets.
• Design, build, and maintain Snowflake Semantic Views (tables, relationships, facts, dimensions, and metrics).
• Author and curate verified queries, synonyms, and metric definitions to power natural-language and AI-driven querying.
• Use AI/LLM tools (e.g., Claude, Copilot or similar) in daily workflows for code generation, query drafting, documentation, and model development support.
• Own data quality, testing, documentation, and support governance/certification of datasets and semantic views for self-service.
• Enable BI and downstream consumers (Looker/Tableau) by exposing consistent, trustworthy metrics.

What you'll need

• Hands-on production experience building analytics models with dbt (staging/marts patterns, tests, documentation).
• Strong dimensional and semantic data modeling skills (star schemas, facts vs. dimensions, grain, slowly changing dimensions).
• Production experience with Snowflake, including building or maintaining semantic views/semantic models (or comparable semantic/metrics layer such as LookML, dbt Semantic Layer/MetricFlow, or Cube).
• Ability to translate business metric definitions into governed, reusable data models and semantic objects.
• Git-based version control and code review workflows for analytics code.
• Strong SQL skills and hands-on Python experience for data transformation, testing, and tooling.
• Practical working knowledge of LLMs/generative AI, including prompting, capabilities/limitations, and comfort using AI coding/analytics assistants.

Details

• Position located in Bengaluru, India.