Advice on how to store and run queries on large amounts of medical data

I'm taking over a project that will involve receiving 15-20M rows of data monthly, do some basic analysis on them (just sorting/deduping), and then distributing this data to some 3rd party companies.

I have been more on the Data Analyst side of things and while I'm proficient with R, SQL and Python, but I've never had to build a storage/pipeline nor have I worked with this amount of data at once before. It makes sense to use a third party …

advice analysis analyst basic companies data data analyst datascience medical medical data project sorting them