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

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