Analyst / Senior Analyst - Controlling

Metromakro; Pune District; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Metromakro is seeking a highly analytical FP&A professional to support budgeting, forecasting, margin analysis, and category performance across our wholesale and retail portfolio. You will partner with Category, Merchandising, Supply Chain, and Business Finance to drive data-driven decisions and profitability.

Responsibilities include building revenue and margin models, variance analyses, multi-channel performance tracking, and dashboarding with Excel/BI tools.

Qualifications

• Bachelor's/Master's degree in Finance, Accounting, Commerce, Economics, or related fields.
• Qualified CMA/CCA, CA Inter or similar.
• 2-7 years of FP&A/Business Finance experience in retail, FMCG, e-commerce, or consumer-focused industries.

Responsibilities

• Prepare the monthly, quarterly, and annual budgeting and forecasting processes for sales, margins, category performance, and operating expenses.
• Develop revenue and margin forecasting models using historical trends, pricing strategies, market dynamics, and promotional plans.
• Provide variance analysis and insights against budget, forecast, and prior period performance.
• Analyze daily/weekly/monthly business performance including sales, GMV, ASP, sell-through, conversion rates, and customer behavior trends.
• Track revenue drivers across channels-online, offline, marketplace, all multichannel sales-highlighting risks and opportunities.
• Support pricing, discounting, and promotional effectiveness studies to improve top-line and margin outcomes.
• Conduct category-level profitability analysis including gross margin, net margin, contribution margin, and SKU-level economics.
• Partner with Category & Merchandising teams to evaluate assortment mix, price positioning, markdown strategy, and product lifecycle profitability.
• Produce margin bridge analysis (price, mix, cost, discounting, shrinkage, etc.) to identify improvement levers.
• Prepare weekly/monthly business review decks with key metrics, KPIs, and performance commentary.
• Build and maintain dashboards (Excel/BI tools) for real-time monitoring of sales, margins, and category health.
• Ensure data accuracy, integrity, and timely delivery of reports to stakeholders.

Skills

Excel advanced

Power BI

Tableau

Financial modeling

Analytical thinking

Stakeholder mgmt

Presentation skills

SQL knowledge

Education

Finance/Accounting degree

CMA/CCA/CA Inter

Tools

Power BI

Tableau

SAP BW/FI/CO

Tagetik

MicroStrategy Datawarehouse

BigQuery

SQL

Excel (macros)

Job description

We are seeking a highly analytical and detail-oriented FP&A professional to support financial planning, margin analysis, category performance evaluation, and revenue forecasting across our wholesale/ retail portfolio. The ideal candidate will partner closely with Category, Merchandising, Supply Chain, and Business Finance teams to drive data‑backed decision-making, optimize profitability, and enhance business performance.

Job Responsibilities:

• Prepare the monthly, quarterly, and annual budgeting and forecasting processes for sales, margins, category performance, and operating expenses.
• Develop revenue and margin forecasting models using historical trends, pricing strategies, market dynamics, and promotional plans.
• Provide variance analysis and insights against budget, forecast, and prior period performance.
• Analyze daily/weekly/monthly business performance including sales, GMV, ASP, sell-through, conversion rates, and customer behavior trends.
• Track revenue drivers across channels-online, offline, marketplace, all multichannel sales-highlighting risks and opportunities.
• Support pricing, discounting, and promotional effectiveness studies to improve top-line and margin outcomes.
• Conduct category-level profitability analysis including gross margin, net margin, contribution margin, and SKU-level economics.
• Partner with Category & Merchandising teams to evaluate assortment mix, price positioning, markdown strategy, and product lifecycle profitability.
• Produce margin bridge analysis (price, mix, cost, discounting, shrinkage, etc.) to identify improvement levers.
• Prepare weekly/monthly business review decks with key metrics, KPIs, and performance commentary.
• Build and maintain dashboards (Excel/BI tools) for real-time monitoring of sales, margins, and category health.
• Ensure data accuracy, integrity, and timely delivery of reports to stakeholders.

Business Partnering

Collaborate cross-functionally with Buying, Merchandising, Supply Chain, Operations, and Marketing teams to support commercial decision-making. Present financial insights to leadership, highlighting actionable recommendations and performance drivers.

Process Improvement & Automation

Identify opportunities to improve financial processes, reduce manual work, and enhance reporting accuracy. Drive automation using Excel macros, Power BI, or other tools to streamline financial workflows.

• Bachelor's/Master's degree in Finance, Accounting, Commerce, Economics, or related fields. Qualified CMA/CCA, CA Inter or similar
• 2-7 years of relevant FP&A / Business Finance experience in retail, FMCG, e-commerce, or consumer-focused industries.
• Strong understanding of retail business drivers-pricing, margins, category dynamics, inventory management, and promotions.
• Advanced Excel skills; working knowledge of Power BI/Tableau preferred.
• Excellent analytical skills with the ability to interpret complex data and translate insights into actions.
• Strong communication, presentation, and stakeholder management capabilities.
• Ability to work in fast-paced, dynamic environments with tight deadlines.
• Strong problem-solving skills, attention to details and ability to work independently.

Preferred Skills

• Experience in budgeting and forecasting tools (SAP 1BW/FI/C, Tagetik, Microstrategy Datawarehouse, Bigquery).
• Experience working with large datasets and SQL plus.
• Strong financial modeling expertise.