I'm a professional Financial Modeller and VBA Developer. I work with many accountants and actuaries on a daily basis, producing mainly VBA tools and integrated P&L, BS & CF models. In the past I produced my own Excel-based financial forecasting software which allows users to quickly build dynamic integrated financial models driven by VBA which got ICAEW approval as a software platform.
These days I specialise in automation projects of the nature you are describing, and I have a strong track record of delivering projects with minimal supervision. Please see my portfolio for examples of this.
Rgds,