Excel Vba jobs in Bengaluru, Karnataka

• Collect, analyze, and interpret business data to identify trends, opportunities, and areas for process improvement.
• Develop and maintain business performance dashboards, MIS reports, and management reports using Advanced Microsoft Excel.
• Perform data validation, cleansing, and reconciliation to ensure accuracy and reliability of reports.
• Prepare daily, weekly, and monthly business reports for senior management.
• Analyze sales, revenue, customer, and operational data to provide actionable business insights.
• Create automated reports using Advanced Excel functions, Pivot Tables, Power Query, Power Pivot, Macros, and VBA (preferred).
• Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
• Track Key Performance Indicators (KPIs) and recommend improvement initiatives based on data analysis.
• Support budgeting, forecasting, and business planning activities through detailed data analysis.
• Identify operational inefficiencies and recommend process optimization strategies.
• Work closely with stakeholders to gather business requirements and prepare functional documentation.
• Present analytical findings and recommendations to management through reports and presentations.
• Ensure timely delivery of accurate reports while maintaining data confidentiality and integrity.

Qualifications and Education Requirements

• Bachelor's Degree in Business Analytics, Statistics, Mathematics, Computer Science, Commerce, Economics, or a related field.
• MBA or Postgraduate qualification in Business Analytics or Data Analytics will be an added advantage.

Preferred Skills

• Advanced Microsoft Excel (Mandatory) – Expertise in Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Power Query, Power Pivot, Macros, VBA, Dashboards, and Complex Formulas.
• Strong analytical and problem-solving skills.
• Experience with Power BI or Tableau is preferred.
• Basic knowledge of SQL for data extraction and analysis.
• Strong understanding of business reporting, MIS, and KPI tracking.
• Excellent communication and presentation skills.
• High attention to detail and accuracy.
• Ability to manage multiple projects and meet deadlines.
• Experience in the Healthcare, Beauty, Retail, or Service industry is an added advantage.

Compensation & Benefits

• Not a constraint for the right candidate

Experience

• 3–5 years of experience is a must as a Business Analyst, MIS Analyst, Data Analyst, or a similar analytical role.
• Advanced Microsoft Excel expertise is mandatory.
• Experience in preparing business dashboards, management reports, and analytical presentations.
• Hands-on experience with data analysis, reporting automation, and business performance tracking is highly preferred.

6 Days Working
Bengaluru

Pay: ₹400,000.00 - ₹800,000.00 per year

Benefits:

• Health insurance
• Leave encashment
• Provident Fund

Work Location: In person