Business Analyst - instashop

Job description

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.

Qualifications

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.