I believe your question is asking about more advanced analytical/technical skills, and not the consulting Basics (Excel, Powerpoint) In addition to the basics, a number of tools are being increasingly used. While a basic knowledge of them is not expected for these (whereas everyone is expected to be able to use Excel and PPT), having these skills could definitely help you shine in certain cases:
1) Tableau / Power BI User: Similar data visualisation tools, these are becoming increasingly used to show data dynamically and make powerful dashboards. It can also be used as an alternative to Pivot tables / Pivot Charts - i.e. to quickly play with data and get some early insights
2) Alteryx: More powerful analytical tool to do more complex analysis, on larger data sets, than Excel.
3) Python: My understanding is that while Python is more powerful, it is also much less user friendly (especially to people without a programming background). So Alteryx fulfils most of the functionality required for consulting, but in a way that is much easier to learn and explain. That being said, I know that some firms (e.g. Oliver Wyman) are actually using Python nowadays and making all junior consultants learn how to use it.
4) SQL: I have not seen SQL being used at Bain, but I know that it is used at some other firms to manage particularly large data sets (e.g. government data sometimes with hundreds of millions of entries).
Having knowledge of additional tools (e.g. R) could be useful for you, but if you aren't able to share this with your colleagues, it is unlikely you will use it much as a consulting generalist. On the other hand, this would enable you to work with the analytics teams much more closely, so could be seen as an advantage and also enable you to potentially do a secondment into the advanced-analytics team (if your firm has one)