Business Analyst

Business Analyst cum MIS Executive

Key Responsibilities:

• Collect, consolidate, and analyze business data from multiple sources to prepare daily, weekly, and monthly MIS reports.
  
• Design and maintain automated dashboards and reports using

  Advanced Excel tools (Pivot Tables, Power Query, Power Pivot, VBA, Macros, etc.)

  .
• Identify business trends, variances, and key performance indicators (KPIs) to support management decisions.
  
• Work with cross-functional teams ( Finance, Operations, etc.) to gather and validate data requirements.
  
• Provide analytical insights and recommendations for process optimization and cost efficiency.
  
• Ensure data accuracy, integrity, and timely delivery of reports to stakeholders.
  
• Assist in business forecasting, budgeting, and performance tracking.
  
• Support ad-hoc data analysis and presentation preparation for management reviews.
  

Required Skills and Competencies:

• Advanced Excel proficiency

  Pivot Tables, Power Query, Power Pivot, Lookups, Conditional Formatting, VBA & Macros.
• Strong analytical and problem-solving skills with attention to detail.
  
• Ability to handle large datasets and data visualization.
  
• Proficiency in

  MS Power BI

  (preferred but not mandatory).
• Excellent communication and presentation skills.
  
• Strong time management and organizational abilities.
  

Qualifications:

• Bachelor’s degree in

  Commerce, Business Administration, Statistics, Economics, Computer Science

  , or a related field.
• 0–3years of experience in

  MIS reporting, business analysis, or data analytics

  roles.
• Experience in data automation and dashboard creation preferred.

Key Performance Indicators (KPIs):

• Accuracy and timeliness of MIS reports.
  
• Efficiency in automating reporting processes.
  
• Quality of business insights and recommendations.
  
• Stakeholder satisfaction with analytical support.