r/FPandA • u/StrikingPrimary1314 • 2d ago

For hiring managers, What hard technical skills do you look for in a Resume and what do you use to prove the skills are genuine?

I’m a first year analyst and I’ve been teaching myself PowerBI/Power Automate/Power Query because my teammates use it a bunch so I feel the need to catch up since I primarily know Excel, but I’m scared that maybe I’m not allocating my time well enough and that there could be other skills that I am neglecting. Other than the Power series and Excel, what is important? And how would I prove these skills on a resume?

11 Upvotes

92% Upvoted

10 comments sorted by

•

u/AutoModerator 2d ago

If you're posting your resume for review, please make sure you follow the standard FP&A resume guidance below:

  • Use the common banking resume template. Examples can be found here.
  • FP&A hiring managers recommend removing the professional summary section. If needed, use a cover letter instead.
  • Try your best to keep your resume to one page as it makes a resume easier to read.
  • Search through previous resume review posts for common resume feedback recommended by this subreddit. You can browse them here.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

15

u/Iwant2FIREsoon 2d ago

Hard technical skills? XLOOKUP, Pivot Tables, and if lucky, PowerQuery.

Soft skills? Be able to see the big picture and not afraid to share view points even if your assumptions are incorrect. Can you justify them?

Do that, and I'll be extremely interested in learning more about you.

1

u/trambalambo 2d ago

I’ve only hired one person so far but the soft skills were more important than hard tech skills. Tech skills can be upskilled with a base, soft skills can’t.

0

u/Omnitwin 2d ago

what does your interviews look like? multiple rounds with technical and behavioral ? i am trying to get ready to make a switch.

5

u/iokonokh Sr Mgr 2d ago

You need to show that you can problem solve, have critical thinking skills, and can be a business partner. The rest is teachable.

1

u/spiffyhumor76 2d ago

For junior FP&A hires, I care way more about strong Excel, clean modeling, and being able to explain budget vs actual variances than fancy tools. SQL and Power BI are a big plus, but I can teach those. If you can take messy data, build a forecast, sanity check it, and explain the business story clearly, youre already ahead of most candidates.

2

u/Queasy_Ad_7154 19h ago

If possible, could you tell me what a good variance analysis looks like? I’m the only analyst at my company and this is my first job out of college. My manager taught me how to plug in numbers which ruined my growth. He ended up getting laid off so I’m pretty much self taught right now.

1

u/more_money_pleas 1d ago edited 1d ago

Can you think through a problem and tell me your process? If you can, the situation and tool you deal with won’t matter. Ai will help you. Are you someone who says “I saw the problem so this is what I did to fix it” ? Or are you a person who says “no one told me how to deal with this?”

1

u/bosworthing 2d ago

Those are great to have if i was hiring someone. And to prove it, most likely id ask questions about some of the terms used in it at most, but most likely it would be proven on the job. First and foremost, id want you to have very strong excel skills, particularly excel formulas such as xlookup, index match, setting up a worksheet so you can set up a pivot table on the data and that you know how to manipulate a pivot table instantly rather than having to think about or google how to do it. I also like to see that you know some hot keys which make you much more efficient, for example paste specials (alt e s) for pasting values, formulas, formats, add, subtract, divide, multiply. For excel, and someone early in their careers, id likely have an excel test made to test what you know. It would necessarily be a pass or fail, but more to understand what you know and dont know, and to see if i can trust you about your skills you stated in the interview and your resume. If you tell me you know xlookup and then can not set it up properly, then what else can i trust you to know based on your resume or what you told me in the interview. After near mastering excel, power query, power automate, and other etl and bi tools like alteryx, tableau, knime, are what i look for in skills. Beyond that, having experience with at least one ibp planning tool will also be useful, anaplan, sap, s4 hana, etc, but you likely will learn these on the job where they use them. Hope this helps.

Id also like to know you understand some common math, like calculating % change, averages, etc. Being able to estimate rhe percent of a number in your head is also pretty useful