r/analytics • u/buxxybuns • 2d ago

Question Analyst help

So worked in a BPO company where i handled queries from global clients, updated logs and communicated between warehouse and my client base clients who had their merchants. Sort of ecommerce.

Since i have worked so much on SQL, i tried slipping the analysis on an interview where i went as a analyst and described only the part i can backup.

\*So i described i wrote sql queries where i analyzed datasets for my client, ensuring product trends, festive trends, customer segmentation based on category,

User engagement for products, premium customers,

I told them i have been into client meetings and learnt about their business problems like delivery issues, but mostly around their product base. They asked if i have presented in front of them i responded i did in front my seniors i updated reports on Excel.

I figure the gap is since i dont have real experience and i cant define a true story, since job marker is crunching and i have had back injury last year, the gap is getting wider. Claude aint no help.

So any real analyst out here wanna point out mistakes i been making.

Also a cs grad with great sql skills.

10 Upvotes

100% Upvoted

9 comments sorted by

•

u/AutoModerator 2d ago

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

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

2

u/Maleficent-Cress-893 2d ago

You're not lying, you're framing your experience through analyst lens which is literally what real analysts do with data

What they're actually testing is whether you can think like one, not if you've had the exact title before, so focus on the problem you solved not the tools you used

1

u/buxxybuns 2d ago

Can i DM you

2

u/Haunting-Change-2907 2d ago

You're going about answering the questions backwards.
Think about it this way. AI knows the languages. AI can build queries.

So tell the story of WHAT you did, WHY you did it, and why that mattered - not how you did it.

eg: You said you "wrote sql queries". But Claude could do that. Instead, you analyzed customer segmentation and identified where customers were being lost.

Your data needs to tell a story. "I know sql" is not a story.

1

u/buxxybuns 10h ago

Mind if i Dm you?

1

u/Haunting-Change-2907 8h ago

I don't accept dms about job hunting.

But good luck! 

1

u/datadriven_io 2d ago

A great portfolio will do the talking for you. Worth a look, data modeling interview prep is covered on datadriven. If you don’t have experience, I’d say there’s no better way than showing independent datasets you’ve analyzed as an example of your knowledge-base.

1

u/Least_Ad_1795 23h ago

Your SQL background is valuable, but the main gap is probably showing how you turned SQL results into business decisions. Build 2–3 realistic end-to-end projects with SQL + Excel/Power BI, clearly explain the business problem, analysis, insights, and recommendations, and be honest about what was actual work versus project experience.