Develop and enhance the data warehouse utilizing best practices, including utilizing extract, transform, and load levels to build a framework for scalability and enablement of self-service analytics. Analyze complex table structures and document data elements, data flow, relationships and dependencies, describing how data is stores and how to access data.