Data Modeling

Responsibilities:
• Create Logical and Physical data models using Embarcadero ER/Studio, employing IDEF1X specification and 3rd Normal Form for OLAP and OLTP systems.
• Provide and enforce best practices and governance standards, normalization, data classification, quality data solutions for Enterprise Data Warehouse.
• Conduct modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.
• Lead discussion with stakeholders designed to transform Subscriber Data Requirements(SDR) into a logical model with clearly-written business definitions for logical entities and attributes data in a way that is consumable by a wide business audience.
• Enforce architectural standards and train Developers, Technical Leads, Project Managers, and Systems Analysts regarding best practices for Enterprise Data Warehouse Design.
• Perform light Data Analysis, Data Profiling using SQL queries on the metadata as needed.