Job Description
Position: MIS Executive
Department: IT / MIS
Industry: Building Material (Ceramic & Bathware)
Employment Type: Full-Time, Permanent
Location: Agra, Uttar Pradesh
Salary: ₹22,000 – ₹28,000 per month
About Ishan Ceramic Pvt. Ltd. (ICPL)
Ishan Ceramic Pvt. Ltd. (ICPL) was established with the vision of delivering world-class ceramic solutions backed by over two decades of industry expertise. Today, we have a strong presence across Western Uttar Pradesh, Madhya Pradesh, Uttarakhand, Punjab, South India, and international markets including the Middle East, Sri Lanka, and Europe.
Driven by cutting-edge manufacturing technology and continuous innovation, our in-house R&D team is committed to delivering premium-quality ceramic products that exceed customer expectations.
Position Overview
We are looking for a highly analytical and detail-oriented MIS Executive to manage business data, prepare insightful reports, develop dashboards, and support management with data-driven decision-making. The ideal candidate should possess strong analytical skills, advanced Excel expertise, and experience with Business Intelligence (BI) tools.
Key Responsibilities
MIS Reporting & Data Analysis
- Prepare Daily, Weekly, Monthly & Quarterly MIS reports.
- Design and maintain interactive dashboards for Sales, Finance, Inventory, HR, Purchase, and Operations.
- Analyze sales trends, customer performance, inventory movement, and business KPIs.
- Generate reports for management reviews and strategic planning.
- Ensure data accuracy, consistency, and timely report submission.
Dashboard Development & Business Intelligence
- Develop interactive dashboards using Power BI and Looker Studio.
- Create data visualizations and performance reports.
- Automate recurring reports to improve efficiency.
- Monitor KPIs and present actionable business insights.
Database & Data Management
- Manage and maintain large datasets.
- Perform data cleaning, validation, and reconciliation.
- Maintain master data and ensure database accuracy.
- Coordinate with various departments to collect business data.
Automation & Process Improvement
- Automate MIS reports using Excel formulas, Power Query, and Macros.
- Improve reporting processes to reduce manual effort.
- Document MIS processes and SOPs.
- Support ERP reporting and system improvements.
Cross-Functional Coordination
- Work closely with Sales, Accounts, HR, Purchase, Warehouse, and Management teams.
- Understand reporting requirements and deliver customized MIS reports.
- Provide analytical support for business planning and decision-making.
Required SkillsTechnical Skills
- Advanced Microsoft Excel (Pivot Tables, Power Query, Power Pivot, Dashboards, Advanced Formulas, Charts)
- Power BI
- Looker Studio
- Google Sheets
- Google Analytics (GA4)
- SQL (Basic to Intermediate)
- Microsoft Power Query
- Microsoft Power Pivot
- VBA & Excel Macros (Preferred)
- ERP Systems (Odoo ERP preferred)
- CRM Reporting
- Data Visualization Tools
- Microsoft Office Suite
- Data Cleaning & Validation Techniques
Analytical Skills
- Strong analytical and logical thinking
- Excellent numerical aptitude
- Data interpretation and reporting
- Problem-solving ability
- High attention to detail
Soft Skills
- Excellent communication skills
- Time management
- Team collaboration
- Ability to work under pressure
- Strong organizational skills
Qualifications
- Bachelor's degree in Computer Science, Information Technology, BCA, B.Sc. (Computer Science), B.Com, BBA, or any relevant discipline.
- Certification in Power BI, Advanced Excel, Data Analytics, or Business Intelligence will be an added advantage.
Experience
- 2–4 years of experience as an MIS Executive, Data Analyst, MIS Analyst, Reporting Executive, or Business Analyst.
- Freshers with exceptional skills in Advanced Excel and Power BI may also apply.
Pay: ₹22,000.00 - ₹28,000.00 per month
Work Location: In person
