Abstract: Systems and methods for transforming data using database are provided. In examples, a method includes instantiating a base schema having template metadata and deriving a plurality of stage schemas from the base schema. Each stage schema is associated with a respective data source, includes a respective stage table populated from the respective data source, and includes metadata inherited from the template metadata when the respective stage schema was derived from the base schema. The method further includes receiving a plurality of sets of raw data being associated with respective data sources of the plurality of data sources. The method further includes extracting one or more respective data items from each stage table using a respective mapping from the corresponding stage schema to a master schema.