Question

We use many JetBrains products and are looking to purchase some JetBrains licenses to give Data Analysts a database IDE that isn't an open source solution and can be used consistently

Answer

Choice may depend on the daily routine of engineers. If Data Analysts only check databases and no scripting is necessary (e.g. Python), then DataGrip would be the best option

If both working with a database and coding in Python is required, then PyCharm would be a better choice. Most features from DataGrip should be available in PyCharm via a plugin

There is also an All Products Pack option available for more advanced cases