@Ryan Donaghy Thanks for posting your question in Microsoft Q&A, apologize for any inconvenience caused on this.
Based on the shared above information, I understand that you are facing some issue with RBAC roles on storage account for the blob storage account.
Instead of adding "Storage Blob Data Contributor" and "Contributor" on storage account you need to add Storage Blob Data Owner to make your function host connect to storage via identity.
Refer to this documentation, to know which RBAC role you need use based on the type of triggers.
Also, From the above discussion we understood that your function app is hosted on consumption plan and your storage account in behind the virtual network.
As per the design, Consumption Function app doesn't support Vnet integration. Instead you can host your function app in Flex Consumption plan which supports Vnet Integration.
Refer the below documentation for more information about Flex Consumption Functions.
- Flex Consumption Plan Hosting.
- Work/Create Flex Consumption Plan Functions
- Cmdlets to check which regions this Flex Consumption Plan is supported.
Hope this helps, let me know if you have any further questions on this.
Please accept as Yes if the answer is helpful so that it can help others in the community.