Data Analyst position at a Pharmaceutical Manufacturing company. Significant inexperience in pharmaceutics and manufacturing data. Really could use some tips and advice from anyone with useful experience, as well as macros and VBA

After being unemployed for about 4 months, I was offered a position at a pharmaceutical manufacturing company/plant as a Data Analyst. I've been in Data Analytics for about 3 years and don't have much experience in useful tools and apps e.g. SQL, Python, VBA, etc. I also don't have any experience in pharmaceutics and manufacturing. I could really use some friendly advice as far as data grooming and mining i.e. common pitfalls, successful implementations, etc. TL;DR at the bottom.

Situation: …

advice analyst data data analyst datascience experience macros manufacturing pharmaceutical tips vba