Total Experience : 8 - 16 years

Mandatory Skills : Dimensional Data Modeling, Oracle Database, SQL, PLSQL, 3NF Modeling

Detailed JD :

- Manage, maintain, and support Oracle databases including schema design, data storage, performance monitoring, and routine maintenance activities.
- Focuses on the design and maintenance of conceptual and logical data models (3NF) and their application within IT project and business data governance processes.
- Defines data modelling standards and applies within all work products.
- Owns and develops artefacts that exploit data models to understand data and data integrations. This may include modelling data flows, developing CRUD matrices to understand master data, and the use of process models to illustrate master data flows.
- Analyze complex datasets to identify trends, anomalies, data gaps, and business insights that support decision making. Ensure accuracy, consistency, completeness, and integrity of data across Oracle-based systems through validation and quality checks.
- Work with multiple IT roles including Data Analysts, Solution Architects,



and Information Architects to embed the use of data models within both project and strategic activities.
- Work with business data governance teams to embed the use of data models and associated definitions within governance processes.
- Work closely with multiple roles to build expert level knowledge of business data and apply in the creation of data models and supporting artefacts describing RD data and data flows.
- Locate and define current process improvement opportunities.

Technical Requirements :

- Experience with Oracle Database. Proficiency in SQL, PLSQL, and database query optimization.
- Experience of developing and applying conceptual and logical data models (3NF).
- Experience of using at least one data modelling tool, ideally ERStudio or Erwin.
- Understanding of fundamental design principles behind a scalable application and data design.
- Solid Exposure to IT Project Lifecycle.
- Life Science Domain Experience.
- Ability to interpret and communicate technical information into business language.

Educational Background : Any Bachelors or Masters Degree from a reputed institution.

📌 Data Modelling Architect (India)
🏢 NS Global
📍 India