MIS Analyst / MIS VBA Developer - Excel VBA | SQL

Tata Consultancy Services; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services in Mumbai seeks an experienced MIS Analyst / MIS VBA Developer to design, automate and optimize MIS reports and dashboards. The role focuses on Excel VBA, MS Access, and SQL-driven data automation to deliver accurate, timely business insights.

The ideal candidate has 3–8 years in MIS reporting, strong communication with stakeholders, and a solid background in data analysis and automation. Join a collaborative team driving operations MIS and reporting excellence.

Qualifications

• 3–8 years of experience in MIS reporting and MIS VBA development.
• Proficient in Advanced Excel, VBA Macros, MS Access, SQL, and data automation.
• Experience in dashboarding and business reporting.

Responsibilities

• Develop, maintain, and enhance MIS reports, dashboards, and scorecards.
• Design and automate reports using Excel VBA, Macros, and MS Access.
• Analyze large datasets and generate actionable insights.
• Develop and maintain VBA applications and automation solutions.
• Create and optimize SQL queries, stored procedures, views, and DB objects.
• Deliver daily, weekly, and monthly reports to stakeholders.
• Support capacity planning, forecasting, SLA reporting, and performance tracking.
• Collaborate with stakeholders to understand requirements and automation opportunities.
• Ensure data accuracy and timely reporting delivery.

Skills

Advanced Excel

VBA Macros

MS Access

SQL Server

RDBMS concepts

Data analysis

Automation

BI Tools

Communication skills

Tools

Power BI

Business Objects

Job description

Hiring for MIS Analyst / MIS VBA Developer | Excel VBA | SQL | Automation | Mumbai

Job Overview

TCS is hiring experienced professionals for MIS Analyst and MIS VBA Developer roles in Mumbai. We are looking for candidates with strong expertise in Advanced Excel, VBA Macros, MS Access, SQL, Reporting, Automation, and Management Information Systems (MIS) who can support business reporting, data analysis, dashboarding, and automation initiatives

Experience

3 to 8 Years

Location

Mumbai

Key Responsibilities

• Develop, maintain, and enhance MIS reports, dashboards, and scorecards.
• Design and automate reports using Excel VBA, Macros, and MS Access.
• Analyze large datasets and generate actionable business insights.
• Develop and maintain VBA applications and automation solutions.
• Create and optimize SQL queries, stored procedures, views, and database objects.
• Deliver daily, weekly, and monthly business reports to stakeholders.
• Support capacity planning, volume forecasting, SLA reporting, and business performance tracking.
• Collaborate with stakeholders to understand reporting requirements and identify automation opportunities.
• Ensure data accuracy, governance, and timely reporting delivery.

Required Skills

• Advanced MS Excel (Formulas, Pivot Tables, Dashboards, Reporting)
• Excel VBA / Macro Development
• MS Access
• SQL Server
• RDBMS Concepts
• Data Analysis & Management Reporting
• Automation Development
• Power BI / Business Objects / BI Tools (Good to Have)
• Strong Communication & Stakeholder Management Skills

Preferred Background

• MIS Reporting
• Business Reporting
• Workforce Management Reporting
• Operations MIS
• Financial Services / BFSI Environment
• VBA Application Development
• Reporting & Analytics
• Data Automation Projects

Selection Process

Technical Interview
Technical Assessment/Test
Final Discussion