Data & MIS Analyst - Excel, Power BI & VBA Automation

Guidehouse; Indiana (PA); On-site; USD 6,000 - 9,000; Full time

Benefits offered by this job

In-house physician consultations

Employee Assistance Program

Learning & development programs

Healthy workplace & wellness offerings

Job summary

Guidehouse India is seeking a data-focused professional to support MIS reporting and backend PMO activities. You will develop advanced Excel-based reports, manage timesheets and invoices, and drive data quality across multiple sources.

The role emphasizes automation with VBA and Power Query, plus dashboard development with Power BI. Strong analytical ability and clear stakeholder communication are essential.

Qualifications

• Bachelor’s degree in science, business, IT, analytics or related field.
• Minimum 1 year of experience in data analysis, MIS reporting or backend PMO activities.
• Strong analytical skills and ability to translate data into insights.
• Advanced MS Excel skills including Power Pivot, Power Query and macros.
• Working knowledge of PowerBI and VBA for automation.

Responsibilities

• Understand client requirements and define detailed tasks and solutions.
• Manage backend PMO activities, including timesheets, invoicing, and compliance tracking.
• Develop and maintain reports and dashboards using MS Excel and MIS tools.
• Perform data analysis and communicate findings to stakeholders.
• Support process automation using VBA, macros, Power Pivot and Power Query.
• Transcribe information into client-ready formats and ensure accuracy.

Skills

MS Excel

Power Pivot

Power Query

PowerBI

VBA

Data analysis

Communication

Problem solving

Education

Bachelor’s degree in science, business, IT, Analytics

Tools

Power Platform

Job description

Guidehouse India is seeking a data-focused professional to support MIS reporting and backend PMO activities. You will develop advanced Excel-based reports, manage timesheets and invoices, and drive data quality across multiple sources.

The role emphasizes automation with VBA and Power Query, plus dashboard development with Power BI. Strong analytical ability and clear stakeholder communication are essential.