Role Overview The MIS Executive will be responsible for managing and optimizing company data systems developing analytical dashboards and supporting automation initiatives The role requires strong expertise in Excel BI tools coding automations and reporting accuracy Key Responsibilities1 Data Reporting Generate daily weekly monthly MIS reports for management and CRM teams Create and maintain dashboards using Power BI and Looker Studio Identify and correct discrepancies in source data 2 Excel Google Sheets Management Maintain detailed spreadsheets and dashboards Use Advanced Excel functions Pivot Tables Power Query and Macros Fix formula errors linkage problems and inconsistencies in Google Sheets 3 Reconciliations Perform periodic reconciliations across CRM Sales Accounting and internal systems Resolve mismatches in coordination with concerned teams 4 Coding Automation Develop automation scripts using Java SQL VBA and Google Apps Script Integrate Google Suite tools for workflow and data automation Implement Mail Merge Email Automation for daily reports Assist in WhatsApp automation and bot workflows optional 5 AI Integration Use AI tools to automate repetitive tasks and improve data accuracy Implement AI for data extraction reporting and documentation automation 6 Data Management Maintain centralized databases with version control Ensure data accuracy integrity and confidentiality 7 Process Improvement Suggest improvements in reporting formats and dashboard structures Identify automation opportunities to streamline processes 8 Coordination Work closely with CRM Finance Sales and Operations teams to understand reporting needs Provide MIS support and solutions across departments Skills QualificationsEducation Bachelor s degree in Computer Science IT Business Administration or related field Master s degree preferred Experience Minimum 3 years in MIS data automation or business intelligence Proven experience in Power BI Looker Studio and advanced Excel Experience in automation of reports emails and workflows Technical Skills Power BI Looker Studio dashboard creation Advanced Excel Macros Pivot Tables Lookups Google Suite Sheets Forms Apps Script SQL data management querying Coding Java VBA Google Apps Script Mail Merge Email Automation WhatsApp automation added advantage Familiarity with CRM systems Tally software and data visualization tools Soft Skills Excellent analytical problem-solving abilities Robust attention to detail Good communicator and cross-functional coordinator Ability to handle large data sets Strong time management and task prioritization Proactive mindset for automation efficiency Key Attributes Detail-oriented and accuracy-focused Ability to work under strict deadlines Independent responsible and process-driven Job Type Full-time Pay 20 000 00 - 40 000 00 per month Work Location In person

📌 Mis Executive (Kalyan)
🏢 Kohinoor group
📍 Kalyan