05 Feb
Kapiva
Bengaluru
Job Description: Business Analyst
About Kapiva:
Kapiva is a modern Ayurvedic nutrition brand on a mission to make clean, natural wellness accessible. Rooted in India’s ancient food wisdom, our high-quality range includes herbal juices, nutrition powders, Ayurvedic gummies, and healthy staples. Our products consistently perform on leading marketplaces like Amazon, Flipkart, and Big Basket, and we’re rapidly expanding offline with partners like Nature's Basket, Reliance Retail, and Noble Plus.
Base Location: Bangalore
Experience: 2 - 4 years
Technical skills: Strong SQL and advanced Excel
Roles and Responsibilities:
● Analyze large datasets using SQL and Excel (joins, aggregations, window functions, pivots, lookups) to answer business questions and identify trends.
● Build and maintain performance reports and dashboards in Excel (pivot tables, charts, automated templates) for business and leadership reviews.
● Work with business and operations teams to understand problems, define clear analytical questions, and translate them into SQL/Excel-based analyses.
● Perform root-cause analysis for KPI movements and propose data-driven actions for growth, cost reduction, and process improvement.
● Validate data quality,
reconcile numbers across sources, and ensure consistency of metrics and definitions.
● Document analysis logic, metric definitions, and data sources to enable reuse and transparency.
● Coordinate with cross-functional stakeholders to set priorities, manage dependencies, and communicate analytical findings clearly.
Required qualifications
● 2-4 years of experience as a Business/Data/Reporting Analyst or similar role.
● Strong hands-on SQL: joins, aggregations, subqueries, CTEs, window functions, and query optimization basics.
● Advanced Excel skills: pivot tables, advanced formulas (LOOKUPs, INDEX–MATCH, SUMIFS, IF formulas), charts, and basic automation using templates/macros.
● Experience working with large datasets from relational databases and collaborating with product/tech/ops teams.
● Excellent communication skills with the ability to present insights and influence decisions.
Preferred skills
● Experience with at least one BI/visualization tool Looker Studio
● Exposure to experimentation/funnel/cohort analysis.
● Prior experience in a rapid-paced startup or high-growth environment.
📌 Business Analyst (Bengaluru)
🏢 Kapiva
📍 Bengaluru
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.