Data Modelling Architect
First seen by Alion on Sep 18, 2026.
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 new 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.
- Strong 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.
Skills
Data Modeling, Data Architect, Data Engineering, Oracle DB, SQL, PL-SQL, Erwin