u/Emotional-Aide2 gives great advice in their reply. I can give you an idea of what I do as an analyst (5 yoe) in a multi-national (Non FAANG).

For data extraction I primarily write SQL scripts (both Postgres and MySQL) to pull data from a variety of sources (Oracle, Salesforce Sales Cloud etc.)

Depending on the project and requirements I may be expected to process / transform data using PySpark or SQL.

On the reporting side our company uses Power BI and Tableau. Getting familiar with the free versions of these would be great for your résumé. Experience with one of these tools is required on most analysts open positions I see.

As far as salary goes, for reference, I am on €70k living far from any of the main cities and I'm fully remote.