19 Aug
|
Policybazaar.com
|
Gurugram
19 Aug
Policybazaar.com
Gurugram
About the Role:
We are looking for a detail-oriented MIS Executive to manage data reporting, dashboards,
and analytics support for the team. The ideal candidate should be highly proficient in
Excel/Google Sheets, with working knowledge of SQL and Power BI to support data-driven decision-making.
Key Responsibilities
- Prepare, maintain, and update daily/weekly/monthly MIS reports and dashboards
- Consolidate data from multiple sources (portals, emails, internal systems) into structured reports
- Build and maintain advanced Excel/Google Sheet trackers (VLOOKUP, HLOOKUP,
Pivot Tables, INDEX-MATCH, Macros, etc.)
- Write and execute basic SQL queries to extract and validate data
- Support in creating and maintaining Power BI dashboards for management reporting
- Identify data discrepancies and ensure accuracy and consistency across reports
- Automate recurring reports to improve turnaround time
- Coordinate with cross-functional teams to gather data inputs
Required Skills
- 1+ years of experience in an MIS/Data reporting role
- Excellent knowledge of Advanced Excel & Google Sheets (Pivot Tables,
VLOOKUP/HLOOKUP, Macros, Conditional Formatting, Data Validation)
- Basic knowledge of SQL (SELECT, JOIN, GROUP BY, filtering/aggregation queries)
- Basic knowledge of Power BI (creating dashboards, visualizations, data modeling basics)
- Strong analytical and problem-solving skills
- High attention to detail and accuracy
- Ability to manage multiple reports/deadlines simultaneously
- Good communication skills to coordinate with internal stakeholders
Positive to Have
- Experience in the insurance/reimbursement/claims domain
- Familiarity with Google Data Studio / Looker Studio
- Basic understanding of automation tools (Power Automate, Google Apps Script)
📌 Management Information System Executive (Gurugram)
🏢 Policybazaar.com
📍 Gurugram