Title: Sr. Data Analytics Engineer(Night Shift)Location: RemoteDuration: 6+ Months- Very robust SQL- Experience in ETL and complex data transformations- Strong attention to sematic modeling- Experience in 3-tier/medallion architectures- Understanding of warehouse modeling - fact and dimensions, star/snowflake schemas- Experience in BI tooling (understanding the data requirements for BI development and how data is sourced for BI)- Experience in Snowflake, Databricks, or similar cloud-native data warehouseAbout the RoleThis role focuses on designing, building, and maintaining business-ready data products within the Medallion Architecture, specifically the Gold and Semantic layers.The position is responsible for transforming curated data into business-ready models, defining KPIs, business logic, and semantic structures, and delivering trusted, analytics-ready datasets and insights.Key Responsibilities- Build and maintain business-ready data products and semantic models that translate curated enterprise data into accessible structures for analytics and reporting.- Design, develop, and maintain semantic layer datasets (e.g., models, views, tabular models) aligned with business logic, KPIs, and reporting standards.- Perform data transformations, aggregations, and modeling within the Gold/Presentation layer, applying business rules while maintaining data integrity and compliance.- Write and optimize complex SQL queries to support analytics, reporting performance, and data model efficiency.- Collaborate with enterprise data and governance teams to refine layer datasets, ensuring alignment between technical data structures and business requirements.- Identify and resolve data quality, performance, and model alignment issues in partnership with enterprise data and governance teams.- Resolve complex conflicts between business definitions, KPIs,



and data models while ensuring consistency with enterprise standards.- Document data models, semantic layers, and analytics solutions, including business definitions, mappings, and technical specifications.- Contribute to the creation, maintenance, and evolution of Data Contracts, contextual data layers, and business ontologies, including:- Defining and documenting data meaning, lineage, and ownership- Aligning datasets to business domains, entities, and standardized definitions- Supporting the development of a context layer that enables consistent interpretation and reuse of data products across teams- Collaborate with cross-functional teams to deliver scalable and governed data products.- Ensure adherence to data governance, security, and regulatory compliance through validation, documentation, and alignment with enterprise standards.Minimum Qualifications (Knowledge, Skills & Abilities)- Strong proficiency in SQL for data transformation, aggregation, and analysis.- Experience with Business Intelligence tools (e.g., Power BI) and semantic modeling.- Understanding of data modeling concepts, including star schema and dimensional modeling.- Experience working with curated datasets in the Gold/Presentation layer and analytics-ready data products.- Familiarity with data governance, data quality, and metadata management concepts.- Ability to translate business requirements into data models, KPIs, and analytics solutions.- Experience with modern cloud data platforms such as Snowflake, Azure, Databricks, or similar technologies.- Familiarity with version control and collaborative development practices (e.g., Git, GitHub, pull/merge request workflows).- Experience with CI/CD workflows and collaborative development methodologies.- Exposure to performance optimization within semantic models and reporting layers.- Strong analytical thinking, problem-solving, and stakeholder management skills.EoE

📌 Sr. Data Analytics Engineer(Night Shift) (Mumbai)
🏢 MSR Technology Group
📍 Mumbai