MIS Executive

Info Edge; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Info Edge in Chennai requires an MIS professional to design, develop, and maintain Excel reports and dashboards, leveraging advanced Excel features such as pivot tables, VLOOKUPs, HLOOKUPs, and macros. The role emphasizes data visualization with Power BI/Dynamics and collaboration across teams to meet reporting needs.

Ideal candidates have 3-8 years in MIS, strong SQL basics, and the ability to translate business requirements into robust reporting solutions that drive decision-making.

Qualifications

• 3-8 years of experience in an MIS role with expertise in Advanced Excel (pivot tables, VLOOKUPs, HLOOKUPs).
• Proficiency in creating complex reports using Microsoft Office Suite (Excel) as well as other tools like Power Query/Power BI/Dynamics.
• Strong understanding of SQL concepts including joins, aggregations, subqueries; ability to write simple queries for data retrieval.

Responsibilities

• Develop and maintain complex Excel reports, dashboards, and datasets using advanced Excel skills such as pivot tables, VLOOKUPs, HLOOKUPs, macros.
• Design and implement data visualizations to effectively communicate insights to stakeholders through Power BI or Dynamics.
• Collaborate with cross-functional teams to gather requirements for reporting needs and develop solutions that meet business objectives.
• Troubleshoot issues related to report development, data quality, and performance optimization.

Skills

Advanced Excel

Pivot tables

VLOOKUP

HLOOKUP

Macros

Power BI

Dynamics 365

Power Query

SQL basics

Tools

Power BI

Dynamics 365

Power Query

Job description

Roles and Responsibilities :

• Develop and maintain complex Excel reports, dashboards, and datasets using advanced Excel skills such as pivot tables, VLOOKUPs, HLOOKUPs, macros, etc.
• Design and implement data visualizations to effectively communicate insights to stakeholders through Power BI or Dynamics.
• Collaborate with cross-functional teams to gather requirements for reporting needs and develop solutions that meet business objectives.
• Troubleshoot issues related to report development, data quality, and performance optimization.

Job Requirements :

• 3-8 years of experience in an MIS role with expertise in Advanced Excel (pivot tables, VLOOKUPs, HLOOKUPs).
• Proficiency in creating complex reports using Microsoft Office Suite (Excel) as well as other tools like Power Query/Power BI/Dynamics.
• Strong understanding of SQL concepts including joins, aggregations, subqueries; ability to write simple queries for data retrieval.