I’m currently more of a SaaS Product Manager, but yesterday I got stuck thinking about moving toward an analyst-type role: where to start, what skills to focus on, and what the current market actually asks for.
So I did this:
I copied around 70 job posts from a niche job board that posts roles from solid international companies.
Then I gave the posts to Claude and asked it to:
- Extract all mentioned companies.
- Find current or recently archived Product Analyst roles at those companies.
- Build a skills frequency table based on those job descriptions.
Something like:
SQL — mentioned in 100% of roles
A/B testing — mentioned in 70%
Python — mentioned in 80%
BI tools — mentioned in 100%
Then I asked it to break down each skill into subtopics and suggest where to learn them.
For example:
Statistics → confidence intervals, hypothesis testing, statistical significance
A/B testing → experiment design, sample size, MDE, interpretation
Python → pandas, notebooks, data cleaning, analysis workflows
Product analytics → funnels, cohorts, retention, LTV, ARPU
And then for each topic, I asked for practical resources: courses, YouTube videos, simulators, bootcamps, and project ideas.
The output was surprisingly useful. It turned a vague “I should learn analytics” into a very concrete roadmap based on actual job descriptions.
The main takeaway: don’t ask AI “how do I become an analyst?”
Give it real job posts from companies you actually care about, then ask it to reverse-engineer the skill map.
written by human, redacted by ai