Excel Automation - Queries, DAX, Power Query, SQL & Overall Automation

I am a co-owner of a company that has ~2000 employees and am looking to have a developer assist us in fixing some of our automated reports and help us automate more reports ongoing. We have multiple reports that are sent through windows scheduler using a bat file that open an excel file (in the background), refreshes the data, and then sends out emails from a VM. We had a great developer but has been missing/non-responsive months The developer would need deep expertise in the following areas
- excel queries with a SQL backend database
- Power Query
- Overall Excel Automation

. Please let me know if you have any questions