12 Sep
|
MSR Technology Group
|
India
12 Sep
MSR Technology Group
India
Title: Sr. Data Analytics Engineer(Night Shift)
Location: Remote
Duration: 6+ Months
- Very solid 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 warehouse
About the Role
This 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 layer
📌 Sr. Data Analytics Engineer(Night Shift) (India)
🏢 MSR Technology Group
📍 India