MIS Executive

Pay: ₹20,000.00 - ₹25,000.00 per month

Job Description

Position: MIS Executive

Department: IT / MIS
Industry: Building Material (Ceramic & Bathware)
Employment Type: Full-Time, Permanent
Location: Agra, Uttar Pradesh

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.

Job Type: Full-Time, Permanent

Work Location: In-person (Agra)

Job Type: Full-time

Work Location: In person

• It is a Full Time IT / Software / Data Analyst job for candidates with 2 - 3 years of experience.