Data Analytics Engineer

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