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.
Read the full description and apply on the company’s own careers page.
