Efficient alternatives to a cumbersome VBA macro

I'm not sure if I'm posting this in the most appropriate subreddit, but I got to thinking about a project at work.

My job role is somewhere between data analyst and software engineer for a big aerospace manufacturing company, but digital processes here are a bit antiquated. A manager proposed a project to me in which financial calculations and forecasts are done in an Excel sheet using a VBA macro - and when I say huge I mean this thing …

aerospace analyst big data data analyst datascience digital engineer job macro manager manufacturing processes project role software software engineer thinking vba work