Business Analyst

Livspace; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Livspace is seeking a data-driven Business Analyst to turn business questions into actionable insights. You will write optimized SQL, build dashboards and recurring reports, and leverage advanced Excel; Python is preferred.

The role involves collaboration with cross-functional teams in Bengaluru to drive data-backed decisions. You will translate requirements into clear metrics, monitor KPIs, identify trends and anomalies, ensure data quality, and support stakeholders across Sales, Ops, and

Qualifications

• 3–6 years of experience in business analysis or data analysis.
• Strong SQL skills with joins, aggregations, subqueries and window functions.
• Advanced Excel skills with PivotTables, lookups and data analysis.
• Ability to translate data into clear recommendations and actions.
• Attention to detail and ability to manage multiple priorities.
• Python knowledge for analysis or automation is preferred.
• Experience with Power BI, Tableau or Looker is advantageous.

Responsibilities

• Write and optimise SQL queries to extract, join, validate, and analyse data.
• Build, maintain, and improve dashboards and recurring reports.
• Translate business requirements into metrics, analyses, and recommendations.
• Monitor KPIs, identify trends, anomalies, and root causes.
• Partner with teams to define requirements and improve reporting processes.
• Ensure data accuracy and consistency through quality checks and documentation.
• Use Python for data cleaning, analysis, or automation where applicable.

Skills

SQL

Advanced Excel

Python (preferred)

Tools

Power BI

Tableau

Looker

Job description

About Livspace

Livspace is a leading home interiors and renovation platform that brings homeowners, designers, and execution partners together to make the journey of designing and transforming a home simpler. We combine technology, design expertise, and operational capabilities to deliver a more seamless customer experience.

About the Role

We are looking for a data-driven Business Analyst to turn business questions into actionable insights. In this role, you will work with cross-functional teams to analyse performance, build and maintain reports, identify trends and process gaps, and support data-backed decisions. Strong SQL and advanced Excel skills are essential; Python is preferred.

What You Will Do

• Write and optimise SQL queries to extract, join, validate, and analyse data from multiple tables or sources.
• Build, maintain, and improve dashboards, recurring reports, and business-performance trackers.
• Use advanced Excel features and formulasincluding XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS,COUNTIFS, IF, nested formulas, PivotTables, and data validation—to analyse and reconcile data.

• Translate business requirements into clear metrics, analyses, and recommendations for stakeholders.
• Monitor key performance indicators, identify trends, anomalies, and root causes, and highlight opportunities for improvement.

• Partner with teams across business, sales, operations, finance, and technology to define requirements and improve reporting processes.

• Ensure data accuracy and consistency through quality checks, reconciliation, and documentation.
• Use Python for data cleaning, analysis, or automation where applicable (preferred).

What You Will Need

• 3–6 years of experience in business analysis, data analysis, reporting, or a related analytical role.
• Strong SQL skills, including joins, aggregations, subqueries, CTEs, and window functions.
• Advanced Excel skills are a must, with strong command of formulas, PivotTables, lookups, and data analysis.
• Ability to interpret data, spot patterns, investigate variances, and present clear, practical recommendations.
• Strong attention to detail, structured problem-solving, and the ability to manage multiple priorities.
• Clear communication skills and confidence working with stakeholders across teams.
• Python knowledge for analysis or automation is preferred.
• Experience with visualisation tools such as Power BI, Tableau, or Looker is an advantage.

Success in This Role

You will help teams make faster, better-informed decisions by delivering reliable analysis, clear reporting, and actionable business insights.