Implement Change Data Capture (CDC) mechanisms and incremental data loading strategies to ensure near real-time data freshness.
Lead the design and construction of the enterprise data warehouse (EDW) using industry-proven methodologies (Inmon, Kimball, or Data Vault).
Apply dimensional modeling expertise to design star schemas, snowflake schemas, and constellation models optimized for analytical query performance....