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

Job description

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