Mis Executive

Effingut Brewerkz; Koregaon Park; On-site; INR 600,000 - 900,000; Full time

Job summary

Effingut Brewerkz is seeking a data-driven MIS analyst to prepare comprehensive management reports and dashboards. You will consolidate sales, expenses, inventory, and profitability across multiple outlets, and track variances against budgets and forecasts.

The role requires strong Excel skills, experience in MIS/reporting, and familiarity with POS and accounting software. Hospitality industry exposure is preferred. This is an on-site position in a hospitality setting.

Qualifications

• Experience in MIS, reporting, data analysis or similar role.
• Strong Excel skills and relevant capability for data consolidation.

Responsibilities

• Prepare and circulate daily, weekly, and monthly MIS reports for management within defined timelines.
• Consolidate outlet-wise sales, revenue, expenses, profitability, inventory, and operational data into standardised reports.
• Track actual performance against budgets, forecasts, and previous periods; highlight variances and trends.
• Prepare dashboards, KPI reports, and management-review summaries for business monitoring.
• Reconcile sales data across POS, aggregator reports, and accounting records; investigate discrepancies.
• Analyze discounts, refunds, and commissions; report material deviations.
• Assist in budgets, forecasts, and periodic financial projections using available data.
• Extract, consolidate, validate, and maintain data from Excel/Sheets, POS, accounting software, and other apps.
• Coordinate with Accounts, Operations, SCM, and outlet teams to obtain missing data and correct records.
• Maintain POS and IMS data, including icons, vendors, customers, and master data.
• Maintain standardised reporting formats, databases, and schedules for consistency and accuracy.
• Identify opportunities to streamline and automate reporting activities.

Skills

Excel skills

Data analysis

MIS reporting

Hospitality knowledge

Attention to detail

Education

Bachelor's degree in Commerce/Business Administration

Tools

MS Excel

POS systems

Accounting software

Job description

Role & responsibilities:

• Prepare and circulate daily, weekly, and monthly MIS reports for management within defined timelines.
• Consolidate outlet-wise sales, revenue, expenses, profitability, inventory, and operational data into standardised reports.
• Track actual performance against budgets, forecasts, and previous periods; identify and highlight significant variances, unusual trends, and areas requiring management attention.
• Prepare dashboards, KPI reports, and management-review summaries to support business monitoring and decision-making.
• Reconcile sales data across POS reports, aggregator reports, and accounting records; investigate and flag discrepancies for resolution.
• Analyse discounts, complimentary sales, refunds, and aggregator commissions, and report material deviations or irregularities.
• Assist in preparing budgets, forecasts, and periodic financial projections using available business data.
• Extract, consolidate, validate, and maintain data from MS Excel/Google Sheets, POS, accounting software, and other business applications.
• Coordinate and follow up with Accounts, Operations, Supply Chain Management (SCM), and outlet teams to obtain missing data and correct inaccurate or inconsistent records.
• Manage and maintain POS and IMS software data, including creation and updating of icons, vendors, customers, and other master data, as required.
• Maintain standardised reporting formats, databases, data records, and supporting schedules to ensure consistency, traceability, and accuracy.
• Identify opportunities to streamline and automate repetitive reporting activities and improve reporting efficiency.

Preferred candidate profile:

• Bachelors degree in Commerce, Business Administration or a related field with experience in Hospitality Industry is preferred
• Relevant experience in MIS, reporting, data analysis, or a similar role; candidates with strong Excel skills and relevant capability may also be considered.