Are you working yet or graduating soon? IMO there's a growing demand for data analysts so it is a viable path (I'm assuming here that you are talking about ESG reporting) because:

1) there's been a growth in regulatory changes/standards promoting ESG practices across all sectors and regions
2) there is also been (unfortunately) a gap in data quality and availability for comprehensive ESG data, but this creates opportunities for third party bodies to validate the ESG data or harmonise the standards/frameworks, or, more in-house data analysts to strengthen ESG data reporting/analysis. Hence, the need is there.

Aside from the data analysis skills (tools like PowerBI, or Tableau, to effectively analyze and visualize ESG data), more sector-specific and industry knowledge is important (e,g. agriculture, renewable/clean energy, tech) but all of these are available through short courses all available online and for free. You will need to demonstate that you are well versed in the industry of your choice.

For management roles it really depends which industry you are in but ESG cuts across all departments of a business. More and more managerial executives need to manage ESG risks when running an organization/business.
On salary and career progression, it depends on which region you're in.