Data Analytics Engineer

Job description

**Job Title: Data Analytics Engineer** **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 clear 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 environments **Experience Required** - 37 years of relevant experience in Analytics Engineering / Data Engineering / Data Analytics - Demonstrated experience working in a modern data stack environment **What Were Looking For** - Strong ownership of data quality and reliability - Ability to translate business requirements into scalable data models - Detail-oriented with a focus on usability and clarity - Strong collaboration and communication skills