Business Data Analyst

About Creme Castle

Creme Castle is a fast-growing consumer brand in the F&B and dessert space, operating across multiple locations and formats. As we continue to scale, we are looking for someone who can help us turn our growing volume of business data into clear insights, better decisions and measurable business outcomes.

About the Role

We are looking for a young, highly analytical and driven Business Analyst to work closely with the leadership team and business functions.

This is not a traditional reporting role.You will be expected to work with data, understand the business behind the numbers, identify trends and problems, build meaningful reports and dashboards, and help leadership make better decisions.

The role will have strong exposure to the Founder's Office / senior leadership, making it an excellent opportunity for someone who wants to develop a broad understanding of how a fast-growing consumer business operates.

You will work across areas such as sales, stores, operations, supply chain, people, finance, customer/order data and business performance.

What You'll Do:

• Business Analytics & Reporting, Own regular business MIS, dashboards and management reporting.
• Analyse sales, orders, revenue, margins, store performance and other business metrics.
• Build daily, weekly and monthly performance dashboards for leadership.
• Identify trends, anomalies, gaps and opportunities from business data.
• Convert large and complex datasets into simple, actionable insights.
• Develop automated reporting wherever possible rather than relying on repetitive manual MIS.
• Business Performance Analysis, Analyze performance across stores, cities, channels, products and time periods.
• Identify high-performing and under-performing locations/products/categories.
• Conduct variance analysis against budgets, targets, forecasts and previous periods.
• Identify key drivers behind changes in business performance.
• Support leadership in answering questions such as "What happened?", "Why did it happen?" and "What should we do about it?"
• Build analysis around new store performance, ramp-up, productivity and expansion.
• Decision Support, Work closely with the Founder's Office and leadership team on business problems.
• Prepare data-backed analysis for business reviews and leadership discussions.
• Support business cases, expansion decisions and strategic projects.
• Build models to evaluate different scenarios and assumptions.
• Translate business questions into analytical frameworks and actionable recommendations.
• Advanced Excel & Data Management, Work extensively with Advanced Excel / Google Sheets.
• Build complex models using Pivot Tables, XLOOKUP/INDEX-MATCH, SUMIFS, logical functions, dynamic formulas etc.
• Maintain clean, structured and reliable datasets.
• Identify data inconsistencies and work with teams to improve data quality.
• Build reusable templates and reporting systems.

The expectation is not simply to collect data from these teams, but to understand their business problems and help solve them through data.

What We're Looking For

We are looking for someone who is:

• 1–3 years of experience in Business Analytics, Business Intelligence, Management Consulting, Founder's Office, Data Analytics or a similar role.
• Extremely comfortable with Advanced Excel / Google Sheets.
• Strong analytical and problem-solving ability.
• Good understanding of business metrics and commercial thinking.
• Comfortable working with large datasets.
• Able to identify patterns and derive insights rather than simply prepare reports.
• Strong attention to detail and data accuracy.
• Comfortable presenting numbers and insights to senior stakeholders.
• Able to work independently with limited supervision.
• Curious about how businesses work, not just how spreadsheets work.
• Comfortable operating in a fast-paced, ambiguous startup environment.
• Good to Have Experience with Power BI / Tableau / Looker Studio or similar BI tools.
• Basic SQL knowledge.
• Experience working with databases / data warehouses.
• Exposure to F&B, QSR, Retail, FMCG, Consumer or other multi-location businesses will be a plus.
• Experience in a Founder's Office / Management Consulting environment.
• Exposure to financial modelling, forecasting or business planning.