Key ResponsibilitiesKey Responsibilities
Data Modelling & Design
Design, develop, and maintain enterprise-level conceptual, logical, and dimensional data models.
Create and manage normalized (3NF) data models for operational systems and dimensional models for reporting and analytics.
Ensure data models align with business requirements, enterprise architecture standards, and data governance policies.
Define and maintain data modelling standards, methodologies, naming conventions, and best practices.
Perform data analysis and profiling to identify relationships, dependencies, and data quality issues.
Data Governance & Integration
Collaborate with business data governance teams to establish and maintain data definitions, business glossaries, and metadata standards.
Support enterprise master data management initiatives by defining data entities, relationships, and ownership structures.
Develop data flow models, CRUD matrices, and process maps to understand data movement across systems.
Ensure consistency and integrity of enterprise data assets across multiple applications and platforms.
Stakeholder Collaboration
Work closely with Data Analysts, Business Analysts, Information Architects, Data Engineers, Solution Architects, and Project Managers.
Translate complex technical data structures into business-friendly terminology and documentation.
Participate in project planning, solution design workshops, and architecture reviews.
Support strategic initiatives involving enterprise data transformation and modernization programs.
Data Quality & Process Improvement
Analyze existing data structures and identify opportunities for optimization and standardization.
Recommend process improvements related to data architecture, modelling, integration, and governance.
Conduct impact assessments for system changes affecting data structures and integrations.
Support data quality initiatives through effective data modelling practices.
Documentation & Standards
Create and maintain comprehensive data model documentation, data dictionaries, lineage diagrams, and metadata repositories.
Ensure compliance with enterprise data standards and regulatory requirements.
Provide knowledge sharing and mentoring to project teams on data modelling best practices.Must Have SkillsMandatory Skills
12+ years of experience in Data Modelling and Data Architecture.
Strong experience in developing and maintaining:
Conceptual Data Models
Logical Data Models
Physical Data Models
3NF (Third Normal Form) Data Models
Dimensional Data Models (Star Schema & Snowflake Schema)
Hands-on experience with data modelling tools such as:
ER/Studio
Erwin Data Modeler
PowerDesigner
Similar enterprise modelling tools
Strong knowledge of:
Relational Database Management Systems (RDBMS)
SQL Databases
NoSQL Databases
Experience creating:
Entity Relationship Diagrams (ERD)
Data Flow Diagrams
CRUD Matrices
Data Dictionaries
Understanding of Master Data Management (MDM) concepts.
Strong exposure to Software Development Lifecycle (SDLC) and IT Project Lifecycle.
Excellent analytical, problem-solving, and communication skills.
Ability to communicate technical concepts effectively to business stakeholders.
Domain Expertise
Mandatory experience in the Life Sciences / Pharmaceutical domain.
Understanding of pharmaceutical business processes, regulatory requirements, and enterprise data landscapes will be highly preferred.Good to Have SkillsPreferred Skills
Knowledge of Data Governance frameworks and Metadata Management.
Exposure to Cloud Data Platforms (Azure, AWS, or GCP).
Experience with Data Warehousing and Analytics environments.
Familiarity with ETL/ELT concepts and data integration patterns.
Understanding of enterprise architecture frameworks.
Experience working in global delivery models and stakeholder management.
Company Overview:LTIMindtree is a leading global technology consulting and digital-engineering .company created through the merger of LTI and Mindtree. With more than 80,000 employees operating across 40+ countries, the company delivers end-to-end services in cloud, AI, data, cybersecurity, ERP, and digital transformation. LTIMindtree works with some of the world’s largest enterprises across BFSI, tech, manufacturing, retail, and media. The organisation promotes innovation, learning, and internal mobility, offering employees exposure to complex global projects. For candidates seeking stability, scale, and fast growth in a modern technology environment, LTIMindtree is an excellent career destination.
Pay: ₹2,800,000.00 - ₹3,500,000.00 per year
Work Location: Hybrid remote in Chennai, Tamil Nadu
