MIS Specialist (VBA Macros Mandatory)

2 - 31 years

1 - 4 Lacs

Posted:2 days ago| Platform: Apna logo

Apply

Work Mode

On-site

Job Type

Part Time

Job Description

Job Title: MIS Analyst (Excel VBA Expert) Location: Sector 135 Noida Aykon Tower Department: Management Information Systems / Data Analytics Job Type: Full-Time or Part Time Job Summary: We are seeking a detail-oriented and technically skilled MIS Analyst with strong expertise in Excel VBA Macros to support and automate reporting functions, streamline data processes, and deliver insightful business reports. The ideal candidate will be responsible for managing and improving MIS systems, ensuring timely and accurate reporting, and automating recurring processes using Excel VBA. Key Responsibilities: Develop and maintain automated reports and dashboards using Excel and VBA Macros. Analyze large volumes of data to generate actionable insights for different departments. Create and maintain data validation tools, templates, and user forms using VBA. Work closely with business stakeholders to understand reporting requirements and deliver efficient MIS solutions. Ensure accuracy and consistency of data by implementing robust data integrity checks. Regularly update management with daily, weekly, and monthly MIS reports (Sales, Operations, Finance, etc.). Optimize and automate repetitive tasks and manual reporting processes. Provide ad hoc analysis and reports as requested by leadership. Collaborate with IT/Data teams for integration with other systems (e.g., ERP, CRM). Required Skills & Qualifications: Bachelor’s degree in Commerce, Business, Computer Science, or a related field. 2+ years of experience in MIS/Data Analysis or related role. Advanced Excel skills (Pivot Tables, Power Query, Formulas, Charts, etc.). Mandatory experience in VBA Macros – automation, user forms, and custom functions. Strong analytical and problem-solving abilities. Excellent attention to detail and accuracy in reporting. Good communication and stakeholder management skills. Preferred Skills (Optional but a Plus):Knowledge of SQL for querying databases. Experience with Power BI, Tableau, or other BI tools. Experience in process improvement and documentation. Understanding of ERP systems (SAP, Oracle, etc.). Reporting To: Manager – MIS / Head of Analytics

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You