Location: Pune
Company: Sonata Software
Team: Services, Data Team
About the Role
We are hiring a Data Analytics Engineer to scale how datais modeled, documented, and consumed across the organization. This role focuseson building clean, reliable, and business-ready datasets while owning thesemantic layer and business metrics.
You will work closely with data engineering, analytics, and businessstakeholders to ensure data is accessible, trusted, and usable for analytics.
Key Responsibilities
1. Analytics Data Modeling (dbt +Snowflake)
- Build and maintain scalable data models using dbt on Snowflake
- Transform raw data into clean, analytics-ready datasets
- Design subject-area data models to simplify data consumption
- Ensure performance optimization and scalability of data models
2. Semantic Layer Metrics(Lightdash)
- Develop and manage semantic models and business metrics in Lightdash
- Define and standardize KPIs used across dashboards and reporting
- Ensure consistent business logic across all analytics use cases
- Maintain explicit documentation and metric definitions
3. Data Quality Trust
- Implement data validation and testing frameworks within dbt
- Monitor and troubleshoot data quality issues
- Perform root cause analysis for discrepancies
- Collaborate with upstream data engineering teams to fix data issues
Mandatory Skills (Strict Requirement)
- Hands-on experience with:
- Snowflake (data warehousing)
- dbt (data transformation modeling)
- Lightdash (semantic layer / BI tool)
- Strong SQL skills with experience handling large datasets
- Proven experience in building production-grade data models
- Solid understanding of data modeling concepts (dimensional modeling, star schema)
Additional Skills (Good to Have)
- Experience with orchestration tools (Airflow, etc.)
- Exposure to modern data stack environments
- Understanding of data governance and metadata management
- Experience working in client-facing or consulting e
📌 Data Analytics Engineer (Pune)
🏢 Sonata Software
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.