The interview process for the Data Analyst role at ABHISHEK RANJAN included three distinct rounds. The first was an HR screening, which felt more like a casual conversation than an interview—it started with the recruiter joking about my Zoom background (a bookshelf I hadn’t dusted!). We talked about my journey into data analysis and why I love telling stories with numbers.
The second round, a technical assessment, was a wake-up call. I remember being asked to write a SQL query with nested subqueries—a topic I'd reviewed the night before. It was satisfying to see that prep pay off. One question involved analyzing grocery sales data, and I shared how I once manually tracked our family’s spending patterns to optimize monthly costs. That real-life touch caught their attention.
The final round with the analytics team focused on practical thinking. They gave me a case study on user engagement trends, and I instinctively broke it down with a mix of regression analysis and cohort charts—tools I picked up during a personal project on website traffic spikes during festivals. The team appreciated the unique angle.