MIS Specialist / Data Analyst

Position: MIS Executive/Data Analyst

Department: IT / MIS
Industry: Building Material (Ceramic & Bathware)
Employment Type: Full-Time, Permanent
Location: Agra, Uttar Pradesh
Salary: ₹15,000 – ₹20,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.

Job Type: Full-Time, Permanent

Work Location: In-person (Agra)

Work Location: In person

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

Work Location: In person