# **Job Title:** MIS Executive (Management Information Systems) **Location:** F-128, Laxminarayan Industrial Area, BRC Compound, Udhna–Sachin Road, Surat, Gujarat **Employment Type:** Full-time, On-site **Reporting To:** Managing Director / Operations Head --- ## **About the Role** The MIS Executive will be responsible for building, automating, and maintaining accurate management reports across sales, production, inventory, and finance. This role supports daily decision-making in a fast-paced textile/embroidery manufacturing and trading environment. It requires strong Excel/Google Sheets skills, disciplined data hygiene, and coordination across departments. --- ## **Key Responsibilities** - Design and automate MIS reports (daily/weekly/monthly) for: - Sales orders, dispatches, receivables - Purchases, production status, WIP, rejections - Inventory aging - Consolidate data from ERP, Google Sheets, and manual registers with version control and audit trails. - Run Daily Management System (DMS), publish dashboards on time, and escalate delays. - Build trackers for: - Order lifecycle (enquiry order production QA dispatch) - TAT/SLA compliance - Vendor performance - Customer-wise profitability - Create standardized data-entry templates with validations. - Perform variance analysis (plan vs actual), root-cause analysis, and propose corrective actions. - Prepare management review decks and maintain a central repository of report definitions and SOPs. - Partner with Accounts for receivables/payables MIS, credit control, and cash flow visibility. - Collaborate with Production to track: - Machine utilization - Efficiency - Rework and rejection analysis - Maintain data security, access controls, backups, and clean master data (items, customers, vendors, SKUs). --- ## **Skills Required** - **Advanced Excel/Google Sheets**: - Pivot tables, lookups, nested/array/text formulas - Data validation, conditional formatting - Basic Apps Script and JavaScript (preferred) - Strong data cleaning, reconciliation, and validation discipline. - Business understanding of: - Order-to-cash - Procure-to-pay - Inventory and production cycles - Clear communication and stakeholder management. --- ## **Qualifications & Experience** - Bachelor’s degree in Commerce, Science, or Engineering. - Background in Mathematics is a plus. - 3–5 years of experience in MIS roles within manufacturing/trading. - Experience in textiles/garments/embroidery preferred. - Exposure to ERP systems or structured spreadsheet operations. - Familiarity with BI tools (Google Data Studio, Looker, Power BI) is a plus. --- ## **Compensation** - **Salary Range:** 20,000 – 40,000 per month (based on experience and skills) - Additional benefits as per company policy. - Growth opportunities in analytics and automation. --- ## **KPIs & Success Metrics** - Timely publishing of dashboards/reports as per SLAs. - High data accuracy and reduced reconciliation cycle time. - Increased automation and reduced manual effort. - Adoption of standardized templates and improved visibility of receivables, WIP, and inventory aging. --- ## **How to Apply** Please send: - Updated resume - Portfolio of sample dashboards/reports (Excel/Sheets files) demonstrating: - Pivot tables - Lookups - Data validation - Automation - Expected CTC and notice period
Skills Required Advanced Excel/Google Sheets: pivot tables, lookups, nested/array formulas, text functions, datavalidation, conditional formatting. Basic knowledge of Apps Script / JavaScript is a plus. Strong data cleaning, reconciliation, and validation discipline. Solid understanding of order-to-cash, procure-to-pay, inventory, and production flows inmanufacturing/trading. Job Type: Full-time Pay: ₹10,586.88 - ₹25,000.00 per month Benefits: Cell phone reimbursement Commuter assistance Internet reimbursement Work Location: In person
Skills Required Advanced Excel/Google Sheets: pivot tables, lookups, nested/array formulas, text functions, datavalidation, conditional formatting. Basic knowledge of Apps Script / JavaScript is a plus. Strong data cleaning, reconciliation, and validation discipline. Solid understanding of order-to-cash, procure-to-pay, inventory, and production flows inmanufacturing/trading. Job Type: Full-time Pay: ₹10,586.88 - ₹25,000.00 per month Benefits: Cell phone reimbursement Commuter assistance Internet reimbursement Work Location: In person