MIS Reporting & Analyst

Job highlights

• Calculate and Maintain inter unit good transfer rate. Identify the lower contribution areas and report.
• Provide adhoc analysis as required by leadership. .

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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.