Executive Assistant

Position: Executive Assistant

Location: Chandigarh University, Gharuan, Mohali, Punjab

Position Summary:

We are looking for a highly organized, analytical, and tech-savvy Executive Assistant who can provide comprehensive administrative and analytical support to senior management. The ideal candidate should have strong expertise in MS Excel, data analysis, MIS reporting, Power BI, dashboards, XLOOKUP, VLOOKUP, Pivot Tables, and data visualization.

The candidate will be responsible for preparing management reports, analyzing data, maintaining dashboards, tracking KPIs, coordinating with various departments, and providing accurate and actionable insights to support management decision-making.

Key Responsibilities:

Provide day-to-day administrative and coordination support to senior management.

Manage schedules, meetings, appointments, follow-ups, and important deadlines.

Prepare meeting agendas, presentations, reports, and action-point trackers.

Coordinate with different departments to collect information and ensure timely completion of assigned tasks.

Maintain confidential records, documents, and management information.

Collect, consolidate, clean, and analyze data from multiple departments and sources.

Prepare daily, weekly, monthly, and customized MIS reports for management.

Monitor departmental KPIs, targets, achievements, and performance trends.

Identify discrepancies, data gaps, and trends and highlight them to management.

Develop automated and standardized reporting formats to improve efficiency and accuracy.

Maintain data accuracy and ensure reports are delivered within defined timelines.

Proficiency in:

Advanced MS Excel

XLOOKUP / VLOOKUP / HLOOKUP

INDEX & MATCH

Pivot Tables & Pivot Charts

Conditional Formatting

Data Validation

Sorting, Filtering & Data Cleaning

Advanced formulas and spreadsheet automation

Ability to work with large datasets and create dynamic management reports.

Knowledge of Power Query and Excel automation will be an added advantage.

Power BI & Dashboarding

Required Qualifications:

Bachelor's in Business Administration, Data Analytics, Statistics, Computer Applications, Commerce, Management, or a related field.

3 years of relevant experience in Executive Assistant, MIS, Business Analytics, Data Analyst, Management Reporting, or a similar role.

Strong proficiency in MS Excel and Power BI.

Excellent analytical and problem-solving abilities.

Strong written and verbal communication skills.