JOB DESCRIPTION
Company: Somany Ceramics Limited
Designation: Executive – MIS
Department: Sales Operations / MIS
Location: Noida, Uttar Pradesh
Experience: 4–8 Years
Number of Positions: 2
Reporting To: Manager / Head – Sales Operations / MIS
About Somany Ceramics Limited
Somany Ceramics Limited is one of India's leading ceramic companies and a globally recognized brand in the building materials industry. Established in 1968, the company has a strong presence across domestic and international markets, exporting to more than 55 countries. Its product portfolio includes ceramic tiles, vitrified tiles, sanitaryware, and bath fittings.
Role Purpose
The Executive – MIS will be responsible for managing and maintaining comprehensive corporate MIS related to sales performance, product performance, dealer schemes, incentive structures, and sales team performance. The role involves developing accurate and timely reports, monitoring dealer targets and scheme achievements, tracking pending commitments, and providing actionable business insights to support sales management and decision-making.
Key Responsibilities
Corporate MIS Management
Prepare, maintain, and circulate comprehensive corporate MIS reports covering sales performance and product-wise business analysis.
Develop periodic reports on sales achievement, targets, growth trends, and business performance.
Ensure accuracy, consistency, and timely submission of MIS reports to management.
Dealer Scheme Management
Prepare and monitor dealer TOD (Turnover Discount) and Sankalp scheme reports.
Track dealer-wise monthly riders, eligibility, achievements, and scheme payouts.
Maintain and monitor dealer product schemes, including scheme applicability, performance, and achievement status.
Maintain dealer-wise MOU records and track agreed business commitments against actual performance.
Sales Team Incentive & Performance MIS
Prepare and maintain sales team incentive reports based on defined business parameters and achievement criteria.
Track team-wise and individual KRA performance against assigned targets.
Generate periodic reports highlighting target achievement, performance gaps, and incentive eligibility.
Scheme Tracking & Monitoring
Manage and monitor FTS (Field Trade Schemes) and in-kind schemes.
Maintain scheme-wise records, dealer eligibility, performance, outstanding commitments, and utilization.
Monitor the implementation and effectiveness of ongoing sales promotion schemes.
Dealer Target & Scheme Monitoring
Develop comprehensive MIS dashboards for tracking dealer-wise pending targets and running schemes.
Monitor dealer performance against assigned targets and highlight shortfalls or pending achievements.
Provide regular updates to the sales team regarding dealer-wise scheme progress, pending targets, and scheme deadlines.
Identify discrepancies and coordinate with relevant sales teams for timely resolution.
Data Analysis & Reporting
Analyse sales and dealer performance data to identify trends, deviations, and business opportunities.
Develop standardized reporting formats and dashboards to improve MIS efficiency.
Ensure data integrity and maintain proper documentation and records of all MIS activities.
Coordinate with Sales, Finance, and other internal stakeholders for data validation and reporting requirements.
Required Skills & Competencies
Technical Competencies
Advanced MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, and data analysis.
Working knowledge of MS PowerPoint and dashboard/report preparation.
Knowledge of Power BI and ERP/SAP systems will be an added advantage.
Strong data management, reconciliation, and analytical skills.
Functional Competencies
Sales MIS and business reporting.
Dealer scheme and incentive management.
Sales target and achievement tracking.
KRA and performance monitoring.
Scheme tracking and dealer performance analysis.
Business Competencies
Understanding of sales operations and dealer/distributor business models.
Ability to analyse business data and provide meaningful insights.
Strong coordination with cross-functional teams.
Focus on reporting accuracy and timely delivery.
Behavioural Competencies
Strong analytical and problem-solving abilities.
High attention to detail and accuracy.
Good communication and coordination skills.
Ability to manage multiple reporting requirements and deadlines.
Proactive approach and ownership of assigned responsibilities.