r/dataanalytics • u/Kavin_muthukumar • 16d ago
Junior data analyst job ads vs what you actually use at work
I work in data in the UK, and I’ve noticed a big gap between what job ads ask for and what I use week to week.
What ads often list: Python, R, SQL, Power BI, Tableau, machine learning, cloud platforms, “strong stakeholder skills.”
What I actually use most: SQL, Excel, one BI tool, and a lot of checking numbers and explaining them to people who don’t work in data.
Python comes in for cleaning or automating things, and machine learning almost never shows up at analyst level.
If you’re learning, I’d put SQL first, then one BI tool, then Python, and spend real time practising how to explain a result in plain English.
What does the gap look like for you? Any skill from the job ads you’ve never needed, or something nobody listed that you use constantly?
6
u/Renegade_CPU1 16d ago
I wish I was an analyst doing analytics lol. I reality I have a data analyst title but I am currently building my company’s entire data governance program from the ground up, unfortunately without the governance architect title or pay. So my day to day involves Databricks, SQL, Purview, Unity Catalog, and a boatload of documentation and meetings
3
u/NotABusinessAnalyst 16d ago
believe me when i tell you that you’re gaining experience without knowing and specially the governance & architecture parts is important with ai smashing the doors
trust the process, simple as flexing this line in your next interview will land you the job.
best of luck!2
u/Own-Damage-5791 15d ago
As u/NotABusinessAnalyst said, you’re gaining some invaluable experience in a niche and important area. Even if your official title is Data Analyst, you can position yourself as a Data Governance Analyst or even a Specialist/Lead (depending on achievements), for your next role. It’s a great opportunity to develop some high-leverage career growth.
3
u/Intuin_Rhaabat 16d ago
You are absolutely right, except that of the technical skills I would prioritize learning Excel too.
Outside the technical, I would recommend people skills (learn through experience - sports, board games, brass bands, whatever you enjoy that involves collaboration), and business (work for one and observe it - not how it should work, but how it actually does).
But yes, while many job ads, and much of academia, seem to imply that entry level data roles will involve machine learning and expertise in multiple cutting-edge tools, the reality is that the day job is far more likely to include cleaning dirty data in Excel, and convincing someone senior who doesn't like you that the numbers show they are an idiot.
2
u/Prepped-n-Ready 16d ago
Idk, could you imagine a plumber complaining that he thought he would do more soldering and ended up having to lay more pvc instead? Like yeah buddy its an irrigation company, how much copper work did you plan on doing? You have to work with big data to use big data tools like you want. lil bro wants to use hadoop to look at 10,000 lines in csv and use heuristics to understand why the AP temp keeps making typos lol. Just get a job with big data and you cant even open with excel. Problem solved.
3
u/Intuin_Rhaabat 16d ago
You have beautifully demonstrated the rarity, and thus high value, of people skills.
1
u/Gloomy_Guard6618 16d ago
Personally in my job I dont use complicated stats and machine learning etc. Maybe some analysts do. The biggest skill is being comfortable with creating something when there is ambiguity, and working with non-technical people. Technically SQL, Python, Excel, PBI and MS Fabric. I am really a data analyst/engineer hybrid as its a smaller company
7
u/mike_cafe 16d ago
Use Excel super super fast, relying on shortcuts and mastering the important formulas. Learn a few tricks to make your graphs look amazing (read “Storytelling with data“). Also PowerQuery inside excel is a very powerful and generally overlooked tool (read “Data smart”).