Let`s build a Data Warehouse with PIM functions

We want to summarize all the data that our suppliers provide us within one place so that we can process them (prices, product availability, product information, digital assets).  Data comes from different sources (FTP, URL), let's collect it and combine it in a master table.  Files are usually XML or CSV. Files can also be compressed (ZIP) in individual cases. Access to the files is usually password-protected.  The mapping is specified by us. Does not have to adapt or be editable by the user. Only basic function, no luxury (maybe in a second version).  The data must be retrieved regularly (usually every hour or every day).  The data serve as the basis for the (automated) preparation of offers for our e-commerce project. In addition to basic PIM functions, we also want to implement automated price calculation (both full cost accounting and rule-based sales price calculation).  We have the vision. Not the solution. Be our expert. Which solution is suitable and does not cause high monthly costs?  In-house development or use of open source (Akeneo, Pimcore)? We don't mind if it looks and works like Crystallize ([login to view URL]). Simply more automated.