Another commenter mentioned it as well, but "Designing Data-Intensive Applications" by Martin Kleppmann https://dataintensive.net/ https://dataintensive.net/ is

Another commenter mentioned it as well, but "Designing Data-Intensive Applications" by Martin Kleppmann https://dataintensive.net/ https://dataintensive.net/ is a _fantastic_ overview of the field and, I think, more approachable and enjoyable to read than Kimball's book. But Kimball is a classic, especially for how to do warehouse design. I'll also make a plug for the Meltano[0] project that my colleagues are working on. The idea is to have a simple tool for extraction, loading, transformation, and analysis from common business operations sources (Salesforce, Zendesk, Netsuite, etc.). It's all open source and we're tackling many of the problems you're interested in. Definitely poke around the codebase and feel free to ping me or make an issue / ask questions. [0] https://gitlab.com/meltano/meltano/ https://gitlab.com/meltano/meltano/