Sr. Analytics Engineer

MSR Technology Group; India; On-site; INR 2,500,000 - 3,800,000; Full time

Job summary

MSR Technology Group is seeking a data professional to design, build, and maintain business-ready data products within the Medallion Architecture, focusing on the Gold and Semantic layers to deliver analytics-ready datasets and insights.

You will transform curated data into business models, define KPIs, and ensure alignment with governance and reporting standards.

Qualifications

• Strong SQL for data transformation, aggregation and analysis.
• Experience with BI tools (Power BI) and semantic modeling.
• Understanding of star schema and dimensional modeling concepts.
• Experience with curated datasets in Gold/Presentation layer and analytics-ready products.
• Familiarity with data governance, data quality and metadata management.
• Ability to translate business requirements into data models and KPIs.
• Experience with Snowflake, Azure, Databricks and related cloud data platforms.
• Familiarity with version control workflows (Git/GitHub).

Responsibilities

• Build and maintain business-ready data products and semantic models for analytics and reporting.
• Design semantic layer datasets aligned with business logic, KPIs and reporting standards.
• Perform data transformations, aggregations, and modeling in the Gold/Presentation layer.
• Write and optimize complex SQL queries to support analytics and performance.
• Collaborate with governance teams to ensure data model alignment and data quality.
• Resolve conflicts between business definitions, KPIs, and data models.
• Document data models, semantic layers, and analytics solutions with mappings and definitions.
• Contribute to data contracts, context layers, and ontologies for cross-team reuse.
• Support scalable, governed data products across enterprise teams.

Skills

SQL

Power BI

Semantic modeling

Dimensional modeling

KPIs

Data modeling

Gold/Presentation layer

Data governance

Data quality

Metadata management

Snowflake

Azure

Databricks

Git

GitHub

Tools

Snowflake

Azure

Databricks

Git

GitHub

Job description

• 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 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.