Position: MIS Executive
Job Summary: - The MIS (Management Information System) Executive will be responsible for collecting, compiling, and analysing company data. This role focuses on maintaining accurate spreadsheets, tracking daily operational metrics, and generating timely reports for senior management.
Key Responsibilities: -
- Daily Report Generation: Compile, update, and distribute daily, weekly, and monthly MIS reports regarding sales pipelines, booking statuses, outstanding collections, and project milestones.
- Data Integration & Consolidation: Systematically gather and aggregate raw data from different operational teams—including Sales, CRM, Accounts, and Project Sites—into a unified master database.
- Database Maintenance & Integrity: Maintain clean, error-free databases by performing routine checks to eliminate data duplication, fix formatting errors, and ensure absolute accuracy across all tracking sheets.
- Advanced Excel Operations: Design and optimize spreadsheets using complex formulas, Pivot Tables, VLOOKUP, HLOOKUP, and conditional formatting to make raw data easily readable for management.
- Trend Analysis & Dashboarding: Analyze data patterns to highlight key performance indicators (KPIs), track collection targets, and build simple performance dashboards for department heads.
- Ad-Hoc Reporting: Quickly pull specific datasets, generate customized summaries, and provide immediate data support whenever requested by senior management for urgent business decisions.
- Data Security & Backup: Ensure all spreadsheets and system entries are securely stored, properly version-controlled, and regularly backed up to protect sensitive company information.
Required Skills & Qualifications: -
- Experience: 2 to 4 years of proven experience as an MIS Executive, Data Analyst, or Senior Reporting Analyst.
- Advanced Excel Expertise: Mastery of advanced MS Excel and Google Sheets functionalities, including Pivot Tables, VLOOKUP/HLOOKUP, INDEX/MATCH, nested IF statements, data validation, and conditional formatting.
- Data Organization & Speed: Strong numeric data entry skills with an exceptional eye for detail to spot and correct reporting discrepancies instantly.
- Analytical Mindset: Ability to convert large, complex, and messy datasets into clean, executive-ready summaries and graphical charts.
- Education: Bachelor’s degree in Computer Science, Information Technology, Commerce (B.Com), Business Administration (BBA), or a related data-driven field.
Interested Candidates can share resume at "[email protected]" or What's App resume at "+91-8283846914".
Pay: ₹15,000.00 - ₹25,000.00 per month
Benefits:
Ability to commute/relocate:
- Ludhiana, Punjab (Ludhiana): Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- Do you have practical experience using Advanced Excel features like VLOOKUP, HLOOKUP, and Pivot Tables for report generation?
Education:
Work Location: In person
