Requirements
Education
-
Bachelor/Honors, Bachelor of Science (BSc), in Management Information System
-
Bachelor/Honors, Bachelor of Science (BSc), in Computer Science & Engineering
Additional Requirements
Experience
- 1 to 5 years of relevant experience is preferred
- Candidates with experience in Dyeing Factory, Spinning, or Textile industries will be prioritized
- Freshers are also encouraged to apply
Additional Requirements
- Age requirement: at least 24 years
- Strong hands-on expertise in advanced Microsoft Excel
- Practical experience in Excel-based MIS reporting
- Working knowledge of Microsoft Power BI, including dashboard development, data transformation, and visualization
- Basic to intermediate knowledge of MySQL/SQL queries
- Strong understanding of data cleaning, reconciliation, backup, and reporting discipline
- Excellent analytical and problem-solving skills
- Ability to work independently, identify issues, and take initiative without constant supervision
- Strong communication and cross-functional coordination abilities
- Experience in textile, weaving, spinning, dyeing, inventory, or sales reporting environments will be an added advantage
Skills & Expertise
- Advanced Microsoft Excel
- Power BI
- SQL / MySQL
- Power Query
- MIS Reporting
- Dashboard Development
- Data Cleaning & Validation
- Data Analysis
- Reporting Automation
- Basic data security and backup practices
What We Are Looking For
- A candidate who can transform raw operational data into accurate and meaningful management reports
- Someone detail-oriented who can quickly detect data mismatches and inconsistencies
- A professional capable of building insightful dashboards, not just visual reports
- A proactive individual who follows up with departments to ensure data completeness and accuracy
- Someone eager to learn and grow into a strong Business Intelligence professional over time
Responsibilities & Context
SHATARUPA GROUP is seeking a proactive, analytical, and detail-focused MIS Executive / Junior BI Analyst to support management reporting, dashboard development, and business data analysis across multiple departments.
The selected candidate will be responsible for preparing accurate MIS reports, analyzing operational data, and developing insightful dashboards in Power BI to support effective decision-making. The role requires strong Excel skills and the ability to work with raw, unstructured, and multi-source data.
Key Responsibilities:
- Prepare and maintain daily, weekly, and monthly MIS reports using Microsoft Excel
- Design and develop interactive dashboards using Microsoft Power BI
- Generate reports related to sales, production, inventory, and overall operations for management review
- Utilize advanced Excel functions including VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, Pivot Tables, and Power Query
- Extract, clean, validate, and organize data from Excel sheets, ERP systems, and MySQL/SQL databases
- Reconcile data from multiple departments and identify inconsistencies, missing entries, and errors
- Ensure accuracy, consistency, and timely delivery of all reports
- Assist management with trend analysis, exception reporting, and actionable insights
- Automate recurring reports to minimize manual effort and improve efficiency
- Maintain proper documentation, backups, and organized reporting systems
- Provide basic support for troubleshooting dashboards, reports, and data-related issues when needed
Compensation & Other Benefits
- T/A
- Mobile bill
- Tour allowance
- Profit Share
-
Salary Review: Yearly
-
Lunch Facilities: Partially subsidize
-
Festival Bonus: 2
Other Benefits
Provided according to company policy.
Work Place
Work from Office
Employment Status
Type:
Full Time/Permanent
