Design and develop conceptual logical and physical data models for enterprise and application-level business requirements into well-structured data models that support analytics reporting and operational and maintain data standards naming conventions and metadata for consistency across with data architects engineers and analysts to implement models into databases and data warehouses/ existing data systems and provide recommendations for optimization refactoring and entity relationship diagrams (ERDs) and data flow diagrams to document data structures and data governance initiatives including data lineage quality and and validate data models with business and technical guidance on normalization denormalization and performance tuning of database models comply with organizational data policies security and regulatory requirements.