Designs and maintains logical and physical data models for OLTP and data warehouse environments. Leads stakeholder requirements, develops dimensional and relational schemas (star/snowflake), implements SCD Type I/II, creates ETL mappings, documents metadata, and works with SSIS/Informatica, Erwin/ERStudio, SQL Server, and BI tools (SAP BusinessObjects).