MIS Reporting & Analyst

Aditya Birla Insulators; Mumbai; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Aditya Birla Insulators in Mumbai seeks a Sales MIS analyst to consolidate revenue, budgeting, and forecasting data. You will automate reporting with Power BI and Excel, build dashboards, and present insights to senior leaders to support strategic decisions.

The role involves coordinating with cross-functional teams, preparing detailed revenue analyses, and delivering timely monthly/quarterly reports to drive business performance.

Qualifications

• Experience in sales MIS and data analysis.
• Proficiency in building dashboards and reports for business review.
• Ability to interpret revenue trends and pricing impact.

Responsibilities

• Regular Sales MIS reporting
• Prepare Monthly Customer Invoice level volume, gross sales, net sales and realization (NCR).
• Monthly Reconciliation of NCR with Trail balance NCR Tally.
• Prepare Productwise / sales area wise / segment wise contribution
• Prepare variance analysis against budget, forecast, and previous periods
• Present data related to sales volume performance, revenue trends, and other key metrics to seniors.
• Analyze sales trends, pricing impact, realization, discounts, and schemes.
• Prepare presentations for Business Head/CEO reporting
• Provide insightdriven analysis to support strategic and tactical decisionmaking.
• Reports for Business review meeting/ Corporate fice cell Quarterly reports
• Prepare details for predecided volume and revenue formats
• Arrange 2 players market share
• Prepare Urban and Rural performance report
• Prepare trade and nontrade performance
• Prepare presentations
• Budget and latest estimate working
• Prepare revenue and logistic cost as per given volume
• Assist in budgeting process across departments. Coordinate with department heads to collect and consolidate budget data.
• Support management in revised forecasts and rolling budgets.
• Identify and explain price, volume, mix.
• Additional various data preparation
• Sales and Marketing reports
• Prepare related party transaction details based on revenue model
• Arrange requisite sales data for govt statistical department
• Calculate and Maintain inter unit good transfer rate
• Identify the lower contribution areas and report
• Timely incorporation of changes in schemes and price circulars in NCR as implemented by management
• Arrange revenue related data to auditors
• Support in tax assessment related data preparation
• Track actual performance against approved budgets on a monthly/quarterly basis.
• Prepare supply and distributions reports to show logistic and depot effectiveness.
• Depot landing cost comparison for optimum plant supply allocation
• Work out imported cement contribution
• Provide adhoc analysis as required by leadership
• Automated / BI report
• Improve reporting efficiency through Power BI, Excel automation, SAP reports, and analytical tools.
• Work with SAP/TM1 team on report automation
• BI based report

Skills

Sales analysis

Reporting

Forecasting

Tools

Power BI

Excel automation

SAP reports

TM1

Analytics tools

Job description

Key Result Areas/Accountabilities

Supporting Actions

Regular Sales MIS reporting

• Prepare Monthly Customer Invoice level volume, gross sales, net sales and realization (NCR).
• Monthly Reconciliation of NCR with Trail balance NCR Tally.

• Prepare Productwise / sales area wise / segment wise contribution

• Prepare variance analysis against budget, forecast, and previous periods
• Present data related to sales volume performance, revenue trends, and other key metrics to seniors.
• Analyze sales trends, pricing impact, realization, discounts, and schemes.
• Prepare presentations for Business Head/CEO reporting
• Provide insightdriven analysis to support strategic and tactical decisionmaking.

Reports for Business review meeting/ Corporate fice cell Quarterly reports

• Prepare details for predecided volume and revenue formats
• Arrange 2 players market share
• Prepare Urban and Rural performance report
• Prepare trade and nontrade performance
• Prepare presentations

Budget and latest estimate working

• Prepare revenue and logistic cost as per given volume
• Assist in budgeting process across departments. Coordinate with department heads to collect and consolidate budget data.
• Support management in revised forecasts and rolling budgets.
• Identify and explain price, volume, mix.

Additional various data preparation

• Sales and Marketing reports
  • Prepare related party transaction details based on revenue model
  • Arrange requisite sales data for govt statistical department
  • Calculate and Maintain inter unit good transfer rate
  • Identify the lower contribution areas and report
  • Timely incorporation of changes in schemes and price circulars in NCR as implemented by management

• Arrange revenue related data to auditors
• Support in tax assessment related data preparation
• Track actual performance against approved budgets on a monthly/quarterly basis.
• Prepare supply and distributions reports to show logistic and depot effectiveness.
• Depot landing cost comparison for optimum plant supply allocation
• Work out imported cement contribution
• Provide adhoc analysis as required by leadership

Automated / BI report

• Improve reporting efficiency through Power BI, Excel automation, SAP reports, and analytical tools.
• Work with SAP/TM1 team on report automation
• BI based report