Business Analyst - instashop

Skills this role screens for

About the role

Strong hands-on SQL skills are essential, along with experience analysing business and marketing performance and an interest in using AI to make analytics faster, more scalable, and more impactful. • Analyse business performance across growth, customer behaviour, revenue, profitability, marketing, and operations. • Independently write and optimise SQL queries to extract and analyse large datasets. • Conduct deep dives to identify trends, performance gaps, growth opportunities, and key business drivers. • Analyse customer behaviour across acquisition, activation, retention, churn, frequency, cohorts, segmentation, and customer value. • Analyse marketing and campaign performance across relevant channels, connecting marketing activity to customer acquisition, engagement, conversion, retention, and revenue. • Evaluate marketing efficiency metrics such as CAC/CARC, ROAS, conversion, campaign uplift, and customer quality, and recommend opportunities to improve targeting and budget allocation. • Support customer segmentation and targeting strategies using behavioural, lifecycle, frequency, and value-based cohorts. • Conduct pre/post, cohort, benchmark, and incrementality-style analyses to evaluate campaigns, promotions, and business initiatives. • Support business cases, forecasting, scenario modelling, and impact estimation for new initiatives. • Build dashboards and recurring reports using BI and visualisation tools, with clear visibility across business and marketing KPIs. • Partner with Marketing, Product, Commercial, Operations, and other cross-functional teams to define KPIs and provide clear, commercially relevant recommendations. • Translate complex analysis into clear insights and actions for business stakeholders. • Ensure accuracy, consistency, and reliability of analytical outputs and underlying measurement logic. AI in Analytics The candidate should actively use AI as part of the analytics workflow, including: • Accelerating SQL development, debugging, and analysis. • Structuring analytical approaches and generating hypotheses. • Automating repetitive reporting and analytical tasks. • Supporting faster campaign, customer, and marketing performance analysis. • Improving insight generation, documentation, and stakeholder communication. • Building reusable analytical workflows or AI-assisted processes that improve team productivity and scalability. • 3-5 years of experience in Business Analytics, Data Analytics, Strategy Analytics, Growth Analytics, or a related field. • Strong hands-on SQL skills. • Strong Excel / Google Sheets skills. • Experience with BI tools such as Tableau, Power BI, Looker, Metabase, or similar. • Strong analytical, problem-solving, and structured thinking skills. • Ability to translate data into clear business recommendations. • Comfortable working with multiple stakeholders in a fast-paced environment. • Practical exposure to generative AI tools in analytical workflows. Nice to Have • Experience in e-commerce, marketplaces, quick commerce, retail, fintech, or consumer technology. • Exposure to Python. • Understanding of A/B testing and experimentation. • Experience with customer lifecycle, marketing, pricing, retention, churn, or unit economics.