Oleg Agapov

I'm a Senior Analytics Engineer at Hiive, a fintech company that runs a private securities marketplace for pre-IPO shares. My job is turning messy transaction data into numbers people can actually trust. Most days that means writing dbt models, designing data pipelines, and having strong opinions about naming conventions.

Before that, I spent years working across the data stack — from raw ingestion to dashboards that executives pretend to read.

Teaching is probably the thing I'm most proud of. I write about analytics engineering on LinkedIn to an audience of 14,000+ data professionals — covering dbt, SQL, data modeling, career advice, and the occasional unpopular opinion about the industry.

I wrote a book: Cracking the Analytics Engineering Interview — a practical guide that walks you from resume prep through technical rounds to stakeholder interviews. It's for people who want to get hired, not people who want to feel smart.

More courses on data modeling and dbt are in the works.

The best analytics engineers are translators. They sit between messy data and clear decisions, and their job is to make sure nothing gets lost in translation.

I believe analytics engineering is a craft, not just a job title. Good data work is invisible — nobody notices when the numbers are right, but everyone notices when they're wrong. That asymmetry keeps me honest and a little paranoid, which is probably the right combination for someone who builds pipelines for a living.

Vancouver is a great place for outdoor activities, like hiking ⛰️, cycling 🚴, spending time in parks 🌳 and beaches 🏖️. I'm learning piano and drawing, both purely for the joy of being bad at something new.

If you're local or visiting Vancouver – feel free to reach out and connect!

The best way to reach me is via LinkedIn. I read everything, even if I'm slow to reply.

Also, I have a small (but active) community of my students in Discord!