MIS Executive

3 - 5 years

3 - 4 Lacs

Posted:6 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Role & responsibilities

1. Data Collection & Entry

  • Gather, clean, and structure raw data from various sources
  • Ensure data accuracy, completeness, and consistency
  • Import/export data between Excel and other platforms (e.g., databases, ERP systems, CSV files)

2. Data Analysis & Interpretation

  • Analyze datasets using Excel functions, formulas, and pivot tables
  • Identify trends, patterns, and anomalies in the data
  • Provide actionable insights to support business decisions

3. Advanced Excel Functionality

  • Use advanced formulas (e.g., VLOOKUP, INDEX-MATCH, IF, SUMIFS)
  • Create dynamic reports using PivotTables and Pivot Charts
  • Automate tasks with macros and VBA scripting
  • Design dashboards and interactive visual reports

4. Reporting & Visualization

  • Generate regular and ad-hoc reports for management and stakeholders
  • Develop visually appealing and easy-to-understand dashboards
  • Present findings using charts, graphs, and conditional formatting

5. Data Integrity & Quality Control

  • Perform data validation to prevent input errors
  • Audit spreadsheets to ensure correct calculations and logic
  • Maintain version control and secure sensitive data

Preferred candidate profile

Technical Skills:

  • Advanced MS Excel (PivotTables, formulas, Power Query, dashboards)
  • Proficiency in Macros/VBA and working knowledge of SQL
  • Familiarity with Power BI or similar BI tools
  • Strong analytical and problem-solving skills; detail orientation a must

Other Skills:

  • Excellent communication and presentation skills
  • Ability to handle multiple priorities in a fast-paced environment
  • Strong team player with a process-improvement mindset

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
Shore Group logo
Shore Group

Technology Consulting

Dover

RecommendedJobs for You

gurugram, haryana

gurugram, haryana

bengaluru, karnataka, india

anna salai, chennai, tamil nadu