- Engage the business users to assess their needs to build the suitable model.
- Review the business process, if needed, and conceptualize the entities that interoperate within the business process.
- Determine how the various entities are related and develop entity relationship diagrams that represent the connections among the entities.
- Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model.
- Develop a logical data model and validate the model to ensure that it serves the needs of the business application and its consumers.
- Transform the logical representation of the model into a physical representation on Denodo and work with database administrators to instantiate and manage the data.
- Collaborate with the concerned teams on creating the optimized, reusable semantic model, complete with metadata and lineage information.
- Optimize the model to ensure predictable performance.
- Maintain the metadata; describing the data model, its structure, and semantics.
- Recommend and establish standards, guidelines, and procedures for design and maintenance.