Sr. Data Engineer/Sr. BI Developer-DA&A

Mastek Limited; India; On-site; INR 2,400,000 - 4,000,000; Full time

Job summary

Mastek Limited is seeking an experienced Senior Data Modeler / Sr. Data Engineer / Sr. BI Developer in India. You will design North Star data models, semantic layers, and source-to-target mappings to support BI, analytics, and GenAI use cases. 8–12 years of hands-on data modeling and SQL experience required.

You will collaborate with data engineering, BI, and AI teams to deliver scalable data architectures across Databricks and modern analytics platforms, ensuring data quality and performance.

Qualifications

• 8-12 years of hands-on experience in Data Modeling, Data Warehousing, and SQL.
• Experience designing North Star Data Models and semantic/ontology/context layers.
• Experience with source-to-target mappings and BI/Analytics consumption.

Responsibilities

• Design, develop, and maintain North Star Data Models delivering business-oriented data.
• Develop conceptual, logical, and physical data models from business needs.
• Design star and snowflake schemas and implement normalization/denormalization.
• Create detailed S2T mappings with transformation rules and business logic.
• Translate source systems into standardized target data models.
• Define entities, attributes, relationships, keys, hierarchies, metrics, and KPIs.
• Design semantic, ontology, and context layers for consistent business meaning.
• Support Power BI, Sigma, and AI/GenAI consumption with optimized models.
• Collaborate with data engineers, BI teams, and AI teams to align models.
• Review and improve models for scalability, usability, and performance.
• Maintain data-model documentation and data dictionaries.

Skills

Data Modeling

Data Warehousing

SQL

North Star Data Modeling

Semantic Layer

Source-to-Target mappings

Ontology/Context Layer

BI Collaboration

Documentation

Education

Bachelor's or Master's in CS/IS/Data Analytics or related field

Tools

Power BI

Sigma

Databricks

Snowflake

Job description

Job Title

Senior Data Modeler - North Star & Semantic Data Modeling / Sr. Data Engineer / Sr. BI Developer – DA&A

Expected Work Experience

8-12 years of hands‑on experience in Data Modeling, Data Warehousing, and SQL.

Job Location

India

Job Summary

We are looking for an experienced Senior Data Modeler / Sr. Data Engineer / Sr. BI Developer with strong expertise in enterprise data modeling and modern analytical data environments, focused on Data Automation & AI and Data Engineering - Data Analytics - Databricks (Technical). The candidate should have a strong understanding of fundamental and advanced data modeling concepts and hands‑on experience designing North Star Data Models, source-to-target mappings, and semantic/ontology/context layers that support downstream BI, analytics, and AI/GenAI use cases. Candidate must have relevant experience of 8-12 years.

Key Responsibilities

• Design, develop, and maintain North Star Data Models that provide a consistent and business-oriented representation of enterprise data.
• Develop conceptual, logical, and physical data models based on business and analytical requirements.
• Design normalized and dimensional models, including Star and Snowflake schemas.
• Create detailed source-to-target mappings, including source attributes, target attributes, transformation rules, business logic, and data relationships.
• Translate source-system structures and business requirements into standardized target data models.
• Define business entities, attributes, relationships, keys, hierarchies, measures, and KPIs.
• Design and maintain semantic, ontology, and context layers that provide consistent business meaning across data.
• Ensure the North Star Data Model and semantic layer can effectively support downstream consumption through Power BI, Sigma, and AI/GenAI applications.
• Work closely with data engineers, business analysts, BI teams, and AI teams to ensure the implemented models align with the approved data models.
• Review and enhance existing data models for consistency, scalability, usability, and performance.
• Maintain data-model documentation, data dictionaries, business definitions, and source-to-target mapping specifications.
• Participate in data-model reviews and ensure modeling standards and best practices are followed.
• Collaborate with Data Engineering - Data Analytics - Databricks teams to implement data models in modern data platforms and pipelines.
• Support data automation initiatives and AI/GenAI use cases by ensuring data models are optimized for analytical and machine learning workloads.
• Work across the complete data-modeling lifecycle: Source Systems - Source-to-Target Mapping - North Star Data Model - Semantic/Ontology/Context Layer - Power BI / Sigma / AI consumption.

Other Capabilities

• Ability to understand complex business requirements and convert them into clear, scalable, and business-friendly data models.
• Strong collaboration skills to work with cross-functional teams including data engineers, BI developers, AI/ML teams, and business stakeholders.
• Strong problem-solving and analytical skills with attention to data quality, consistency, and performance.
• Ability to operate in retail-focused analytical environments and adapt models to evolving business needs.
• Capability to contribute to Data Automation & AI initiatives and support advanced analytics and GenAI solutions.
• Strong documentation and communication skills to articulate data modeling decisions and standards.

Qualifications and Skills

• 8-12 years of Data Modeling experience, with hands‑on work in Data Warehousing and SQL.
• Strong understanding of:
• - Conceptual Data Modeling
• - Logical Data Modeling
• - Physical Data Modeling
• - Dimensional Modeling
• - Star and Snowflake schemas
• - Normalization and denormalization
• - Fact and Dimension modeling
• - Slowly Changing Dimensions (SCD)
• - Primary and foreign keys
• - Hierarchies and relationships
• - Business rules and data definitions
• Hands‑on experience with North Star Data Modeling or similar enterprise-wide canonical/business data modeling approaches.
• Strong SQL skills, including complex joins, CTEs, window functions, aggregations, and data validation.
• Strong understanding of Snowflake and its use in modern analytical data platforms.
• Strong experience creating Source-to-Target (S2T) mappings.
• Understanding of Semantic Layer, Ontology Layer, and Context Layer concepts.
• Understanding of how well-designed data models support BI, analytics, and AI/GenAI consumption.
• Experience with Power BI and/or Sigma is preferred.
• Experience working in the Retail domain is highly preferred, with understanding of:
• - Product and Product Hierarchies
• - Customer
• - Store and Location
• - Sales and Transactions
• - Inventory
• - Pricing and Promotions
• - E-commerce / Digital
• - Marketing and Advertising
• - Retail Media
• Experience in Data Engineering - Data Analytics - Databricks (Technical) environments.
• Exposure to Data Automation & AI initiatives and modern data and analytics architectures.
• Bachelor's or Master's degree in Computer Science, Information Systems, Data Analytics, or a related field (or equivalent experience).