MIS Executive

Job Description — MIS Executive
About the Role
KollegeApply works with universities across India on lead generation and enrollment marketing. The Central
Operations team maintains the reports and trackers that our sales and campaign teams run on.
As an MIS Executive, you will own the preparation and timely delivery of these reports. We are looking for
someone accurate with numbers, quick to learn, and comfortable working to a fixed daily schedule.
Key Responsibilities
Reporting
• Publish daily reports on lead flow, campaign delivery, and team-wise numbers at the fixed reporting time.
• Prepare weekly reports covering performance trends, pending items, and zone/client-wise summaries.
• Prepare monthly reports for management review, including month-on-month comparison and closing
numbers.
Data Accuracy
• Ensure 100% accuracy in numbers — every figure shared must be verified and must tally across sources
before the report goes out.
• Download, clean, and consolidate lead data from CRM, landing pages, and partner portals; remove
duplicates and fix missing or invalid entries.
• Flag discrepancies to the reporting manager instead of adjusting numbers to make them match.
• Maintain confidentiality of student and client data at all times.
Coordination & Upkeep
• Update team trackers and follow up with concerned team members for pending inputs.
• Keep report formats and backups updated so reporting continues smoothly in your absence.
• Support the team with ad-hoc data pulls and basic analysis as required.
Automation & AI (Important)
• Should know how to use AI tools to automate reports in Google Sheets and Excel — we are not looking for
manual data entry.
• Use AI to build and correct formulas, clean messy data, and cut down repetitive report preparation time.
• Willingness to learn Google Apps Script / macros, and to suggest simpler, faster ways of running existing
reports.
Required Skills
Must have
• Graduate in any discipline.
• Excel certification is mandatory — a free online certification is acceptable.
• Hands-on command of MS Excel and Google Sheets formulas and functions (listed below).
• Strong attention to detail — errors in published reports are not acceptable.
• Ability to work under pressure and meet deadlines without follow-up.
• Basic communication skills in English and Hindi.
Excel & Google Sheets — Formulas and Functions
• Lookup: VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP
• Logical: IF, Nested IF, IFS, AND, OR, IFERROR
• Aggregation: SUM, SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, AVERAGE,
AVERAGEIF, MIN, MAX, SUBTOTAL
• Text: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCATENATE / TEXTJOIN,
SUBSTITUTE, FIND, SEARCH
• Date: TODAY, NOW, DATEDIF, EOMONTH, DAY, MONTH, YEAR, WEEKDAY, TEXT
• Tools: Pivot Tables, Pivot Charts, Remove Duplicates, Text to Columns, Flash Fill, Data Validation,
Conditional Formatting, Filters, Freeze Panes
• References: Absolute vs. relative ($), named ranges, linking across sheets and workbooks
Good to have
• Internship or prior experience in an MIS, back-office, or data operations role.
• Exposure to CRM tools or digital marketing / lead generation reports.
What We Offer
• Full training on our reporting processes, tools, and data sources.
• Hands-on learning in data handling, Excel automation, and business reporting.
• Clear growth path to Senior MIS Executive / Business Analyst based on performance.

Work arrangement
No