Senior Data Modeler – AI & Advanced Analytics

Luxoft; Chennai District; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Luxoft is seeking an experienced Data Modeler with AI expertise to design and govern enterprise-scale data models for AI-driven analytics and GenAI initiatives.

You will work with Data Architects, Data Engineers, and AI/ML teams to build scalable data foundations on cloud platforms, ensuring data quality, governance, and compliance across Snowflake, Azure Synapse, Databricks, and traditional SQL stores.

Qualifications

• 10+ years of experience in data modeling and enterprise data management.
• Expertise in Data Vault 2.0, dimensional modeling, Kimball, star/snowflake, and 3NF.
• Hands-on with industry-standard modeling tools (ERwin, ER/Studio, PowerDesigner).
• Experience with Snowflake, Azure Synapse, Databricks, SQL Server, Oracle, PostgreSQL.
• Strong SQL, Python, PySpark, and Spark SQL skills for modeling and analytics.
• Knowledge of data governance, metadata, lineage, MDM, and security/compliance.

Responsibilities

• Design conceptual, logical, and physical data models for large enterprises.
• Develop dimensional models, star and snowflake schemas, and 3NF structures.
• Create AI-ready data ecosystems for ML, GenAI, and LLM use cases.
• Partner with Data Architects to align models with enterprise standards.
• Govern data quality, lineage, and metadata across platforms.

Skills

Data Modeling

Data Architecture

Data Warehousing

Dimensional Modeling

SQL

Python

Knowledge Graphs

Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

SQL Developer Data Modeler

Snowflake

Azure Synapse Analytics

Databricks

SQL Server

Oracle

PostgreSQL

Job description

Project description

We are seeking an experienced Data Modeler with AI expertise to design, develop, and govern enterprise-scale data models that support advanced analytics, Machine Learning (ML), Generative AI (GenAI), and business intelligence initiatives. You need to have strong experience in conceptual, logical, and physical data modeling, data architecture, cloud data platforms, and AI-ready data ecosystems.You will work closely with Data Architects, Data Engineers, AI/ML Engineers, Business Analysts, and Product Owners to build scalable and high-quality data foundations for AI-driven solutions.

Responsibilities

• Data Modeling & Architecture:Design conceptual, logical, and physical data models for enterprise applications.Develop and maintain dimensional models, star schemas, snowflake schemas, and normalized data structures.Create AI-ready data models supporting machine learning and GenAI use cases.Define data standards, metadata management, data lineage, and governance processes.Collaborate with Data Architects to align models with enterprise architecture standards.AI & Advanced Analytics Enablement:Design data structures optimized for AI, ML, NLP, and GenAI workloads.Support feature engineering frameworks and model training datasets.Develop semantic data models for Knowledge Graphs, Vector Databases, and RAG architectures.Work with AI Engineers to prepare and optimize data for LLM-based solutions.Ensure datasets meet quality, consistency, explainability, and regulatory requirements.Cloud & Data Platform Engineering:Partner with Data Engineering teams to implement data models on cloud platforms.Support modern data platforms including Data Lakes, Lakehouse, and Data Warehouse architectures.Design scalable data structures for structured, semi-structured, and unstructured data.Optimize data storage, partitioning, and retrieval strategies.Governance & Quality:Establish data quality rules and validation frameworks.Drive master data management (MDM) and reference data strategies.Ensure compliance with security, privacy, and regulatory standards.Conduct model reviews and architecture governance assessments.

SKILLS

Must have

• 10+ years of overall experience in Data Modeling, Data Architecture, Data Warehousing, and Enterprise Data Management.Proven expertise in designing conceptual, logical, and physical data models for large-scale enterprise platforms.Strong experience with Data Vault 2.0, Dimensional Modeling, Kimball Methodology, Star/Snowflake Schemas, and 3NF Modeling.Hands-on experience with industry-standard modeling tools such as ERwin Data Modeler, ER/Studio, PowerDesigner, or SQL Developer Data Modeler.Experience working with modern data platforms including Snowflake, Azure Synapse Analytics, Microsoft Fabric, Databricks, SQL Server, Oracle, PostgreSQL, MongoDB, and Cassandra.Strong understanding of AI/ML data foundations, including data preparation for Machine Learning, Generative AI, RAG architectures, Knowledge Graphs, Vector Databases, Feature Engineering, and AI Data Governance.Experience designing AI-ready data ecosystems that support advanced analytics, predictive modeling, and LLM-based solutions.Hands-on experience with cloud technologies such as Microsoft Azure, Azure Data Factory, Azure Databricks, Azure OpenAI, AWS, and GCP.Proficiency in SQL, Python, PySpark, and Spark SQL for data modeling, transformation, and analytics workloads.Strong knowledge of data governance, metadata management, data lineage, master data management (MDM), data quality frameworks, security, and regulatory compliance.Experience collaborating with Data Architects, Data Engineers, AI/ML Engineers, Business Analysts, and Product Owners in enterprise environments.Excellent analytical, communication, and stakeholder management skills with the ability to translate business requirements into scalable data solutions.

Nice to have

N/A