JOB DESCRIPTION
MIS Executive
Department
Management Information Systems (MIS)
Reporting To
Managing Director
Employment Type
Full-Time
Experience
3 – 5 Years in MIS / Data Operations
Salary Range
₹20,000 per month (based on experience)
Location
L-6 D-101 Swarnbhoomi, Vidhan Sabha Road, Raipur, Chhattisgarh
About the Role
We are looking for a detail-oriented and analytical MIS Executive to join our team. This role is central to building robust data systems, designing Standard Operating Procedures (SOPs), and providing actionable insights that drive business decisions. The ideal candidate is highly proficient in Microsoft Excel and Google Sheets, has strong systems-thinking ability, and is passionate about creating processes that improve operational efficiency.
Key Responsibilities
Data Management & Reporting
- Design, develop, and maintain daily, weekly, and monthly MIS reports for management review.
- Collect, validate, and organise data from multiple departments into centralised dashboards.
- Automate repetitive reporting tasks using Excel macros, Google Apps Script, IMPORTRANGE, and array formulas.
- Ensure data accuracy, integrity, and consistency across all reports and databases.
System & SOP Development
- Design and document Standard Operating Procedures (SOPs) for data collection, reporting, and operational workflows.
- Build and maintain structured tracking systems for sales, operations, HR, or finance as required.
- Consolidate fragmented data sources (e.g., multiple department files) into unified, single-source-of-truth systems.
- Continuously audit and improve existing processes for greater efficiency and accuracy.
Analysis & Decision Support
- Analyse trends, variances, and key metrics to provide actionable business insights.
- Build dynamic dashboards using Pivot Tables, charts, and Google Sheets — including key metrics like total sales, growth, and top performers.
- Identify gaps or inefficiencies in current data processes and proactively recommend solutions.
Coordination, Training & Collaboration
- Coordinate with cross-functional teams to gather data inputs and ensure reporting deadlines are met.
- Train team members on MIS tools, dashboards, and SOPs — including transitioning staff from older tools to new systems with patience and structured guidance.
- Troubleshoot formula errors and data issues (e.g., #REF, #VALUE, #N/A) with a systematic, documentation-first approach.
- Support management with ad-hoc data requests and special analyses.
Required Technical Skills
Excel & Google Sheets — Must Have
- Advanced Excel: Pivot Tables, VLOOKUP / XLOOKUP, INDEX-MATCH, SUMIFS / COUNTIFS, nested IF / IFS, Conditional Formatting, Data Validation, Charts.
- Google Sheets: IMPORTRANGE, ARRAYFORMULA, QUERY function, GOOGLEFINANCE, dynamic dropdowns using named ranges and the UNIQUE function.
- Ability to identify and fix common formula errors; knowledge of absolute vs. relative cell references.
- Experience building dynamic dashboards with auto-updating charts and date ranges.
Systems & Process Skills — Must Have
- Ability to consolidate multiple data sources into a single structured system with access control and data validation.
- Experience designing and writing clear SOPs that non-technical teams can follow.
- Structured troubleshooting approach: diagnose, document, fix, and prevent recurrence.
Good to Have
- Google Apps Script or Excel VBA / Macros for report automation.
- Power BI, Tableau, or Looker Studio for advanced visualisation.
- SQL or basic database management.
- Exposure to ERP systems (Tally, SAP, Zoho, etc.).
Key Attributes We Are Looking For
- Proactive learner — actively keeps up with new tools and formula updates; can name specific resources they use to stay current.
- Initiative & ownership — has identified and fixed inefficient processes without being asked.
- Documentation mindset — defaults to writing things down, creating guides, and building repeatable systems.
- Clear communicator — can explain data and process logic to non-technical colleagues.
- Team enabler — patient and structured when training others on new tools or workflows.
Educational Qualification
- Graduate in Commerce, Mathematics, Statistics, Computer Applications (BCA / B.Sc.), or a related field.
- Postgraduate qualification (MBA / M.Com / M.Sc.) is a plus but not mandatory.
Process Coordinator
Job Description - Process Coordinator Process Coordinator is someone who is mainly responsible for all the flowcharts running in every business process.
She coordinates all the steps in a flowchart to get work done in a specific timeline. Her main tasks is to provide all the relevant information with everyone in the workflow.
Skills:
● A pleasant personality with others on the job and displaying a good-natured, cooperative, polite attitude.
● She should be careful about all the details in flowchart and thorough in completing work tasks.
Requirements:
● She should be staying a maximum of 45 minutes from the office.
● She should have a sense of responsibility.
● Non-technical
Salary Bracket:
Salary for this position should be between 12-15 thousand rupees monthly basis or as per company norms.
Pay: ₹20,000.00 - ₹25,000.00 per month
Benefits:
- Paid sick time
- Provident Fund
Work Location: In person
