Job Overview:

The Junior MIS Officer is responsible for managing, analyzing, and automating operational data to support efficient and seamless business operations. This role emphasizes advanced Excel work, data consolidation, online bid submissions, document management, and basic design support. The ideal candidate will ensure data accuracy, timely reporting, and optimized digital workflows in a highly organized, and in an autopilot working environment under the supervision of the Senior MIS Officer.

Key Responsibilities:

1. Data Management & MIS Reporting

• Maintain, update, and manage large datasets using MS Excel
• Prepare and manage MIS reports, dashboards, and trackers
• Merge, Demerge, Clean and Consolidate data from multiple sources into a single usable file.
• Ensure data accuracy, consistency, and confidentiality at all times

2. Advanced Excel & Automation

• Develop and apply advanced Excel functions (VLOOKUP, HLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS, Pivot Tables, etc.)
• Automate repetitive tasks using Excel functions and structured templates
• Optimize file size and performance for large datasets.

3. Online Bid & Tender Submission

• Prepare, compile, and submit online bids/tenders on portals as per requirements.
• Manage bid related documents, formats, and submission timelines
• Ensure compliance with all submission guidelines and deadlines

4. Document & File Management

• Organize, format, and standardize documents across Word, Excel, and PDF formats
• Compress and optimize files for email and online submissions
• Maintain a well-structured digital filing system

5. Design & Visual Support

• Perform basic photoshop and design work (image editing, resizing, layout adjustments)
• Support PowerPoint presentations designs and document visuals when required
• Ensure professional formatting and branding consistency.

Required Skills & Qualifications:

Technical Skills:

• Strong proficiency in Advanced MS Excel
• Excellent Knowledge of data handling, formulas and reporting.
• Familiarity with online bid/tender submission processes (preferred)
• Basic knowledge of Adobe Photoshop or similar design tools
• Proficiency in MS Word, PowerPoint, and PDF tools

Other Skills:

• High attention to detail and accuracy
• Strong organizational and time-management skills
• Ability to handle multiple tasks and meet tight deadlines
• Capability to work independently in an autopilot system.
• Basic understanding of digital workflows and cloud file systems

Experience Requirements:

• Minimum 2-4 years of relevant experience in MIS, data management, or operations support
• Experience in corporate, trading, supply, or project-based environments will be an added advantage