One of the good things about renewable energy projects is that largely they don't require a ton of labor to maintain, but they do need a fair bit of spin up to get planned and permitted and installed. Wind tends to require more specialized installation, so you may have a traveling install crew there, but solar often relies on local labor pools. So there are a few years of community jobs generated but it's very small for the life of the project.
Some project developers (the good ones at least) are working to invest in local communities like other member businesses- sponsoring little league teams, creating community gardens, funding science education, etc. Is that enough? Hard to say, but I think the idea that projects can bring value to communities should be decoupled from the amount of local jobs they bring at least. Ideally that's through some means of UBI, but more likely some form of tax on profits going to community reinvestment (that's broad enough to cover Walmarts and more too).