- Engage the business users to assess their BI and Analytics needs.
- Review the business process 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 and work with database administrators to instantiate and manage the data.
- Collaborate with the BI and Analytics teams on creating the optimized, reusable dimensional model, complete with metadata and lineage information.
- Optimize the model to ensure predictable performance.
- Maintain the metadata -- the "data about the data" describing the data model, its structure, and semantics.
- Recommend and establish standards, guidelines, and procedures for design and maintenance.
Build models using Erwin and maintain these models in the Erwin mart.