Mis Executive

Incanus Technologies; Gurugram District, Bengaluru, Mumbai; On-site; INR 300,000 - 540,000; Full time

Job summary

Incanus Technologies is seeking an MIS Executive to manage data, develop MIS reports, and build dashboards for clients. The role requires strong Excel skills, data management, and the ability to translate data into actionable insights.

The ideal candidate can work with cross-functional teams, maintain reporting templates, and drive data-driven decision making. Freshers with up to 2 years of experience are welcome and must be prepared for a face-to-face interview at the location.

Qualifications

• Freshers or up to 2 years of relevant MIS/analytics experience.
• Strong Advanced Excel skills are mandatory.
• Experience with data collection, consolidation, and validation.
• Ability to create and maintain reports, dashboards, and trackers.

Responsibilities

• Prepare, maintain, and distribute daily, weekly, and monthly MIS reports.
• Collect, consolidate, clean, and organize data from multiple sources.
• Ensure accuracy and consistency of reports and datasets.
• Maintain databases, trackers, and reporting templates.
• Monitor KPIs and highlight deviations from targets.
• Perform data reconciliation and ad hoc analyses.
• Develop dashboards and visualizations for stakeholders.
• Support automation of reporting processes.

Skills

Advanced Excel

MIS reporting

Data management

Dashboard creation

KPI monitoring

Data analysis

Reporting automation

Stakeholder communication

Education

Bachelor's degree in Commerce / Business Administration / Engineering / CS / Statistics

Tools

Excel Macros & VBA

Power BI

Power Query

Power Pivot

SQL (basic)

Job description

ABOUT THE ROLE:

Incanus Technologies is looking for an MIS Executive with strong analytical thinking, advanced Excel skills, and hands‑on knowledge of data management, MIS reporting, dashboard creation, and business performance analysis for its clients.

The role involves working closely with Business, Operations, Sales, Finance, and other cross‑functional teams to manage business data, prepare accurate reports, monitor key performance indicators (KPIs), and support data‑driven decision‑making.

You will work with datasets from multiple sources, create and maintain MIS reports, build dashboards, perform data analysis using Excel, track operational and business metrics, identify reporting discrepancies, and provide actionable insights to stakeholders.

This role is ideal for freshers and candidates with up to 2 years of relevant experience who have strong Excel skills, enjoy working with data, and are interested in MIS reporting, business analytics, and reporting automation.

Important: This opportunity involves a face‑to‑face interview process. Candidates should be available to attend the interview in person at the relevant location.

KEY RESPONSIBILITIES:

MIS Reporting & Data Management

• Prepare, maintain, and distribute daily, weekly, and monthly MIS reports.
• Collect, consolidate, clean, and organize data from multiple business sources.
• Ensure accuracy, completeness, and consistency of reports and underlying datasets.
• Maintain structured databases, trackers, and reporting templates.
• Monitor key business and operational KPIs and highlight deviations from targets.
• Perform data reconciliation and validation to identify discrepancies.
• Generate ad hoc reports and analyses based on business requirements.
• Maintain historical reporting data for performance tracking and trend analysis.

Advanced Excel & Data Analysis:

• Use Advanced Excel extensively for data processing, analysis, and reporting.
• Work with functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, IFS, and other logical and lookup functions.
• Create and manage Pivot Tables, Pivot Charts, dynamic reports, and interactive dashboards.
• Use conditional formatting, data validation, filtering, and other Excel features to manage datasets.
• Apply advanced formulas to automate calculations, reporting, and data consolidation.
• Analyze business data to identify trends, patterns, anomalies, and performance gaps.
• Perform variance analysis, target-versus-achievement analysis, and period-over-period comparisons.
• Optimize Excel workbooks and reporting processes for accuracy and efficiency.

Dashboarding & Business Performance Reporting:

• Create and maintain dashboards to track business performance and operational efficiency.
• Develop structured reports covering key metrics, productivity, performance, and business outcomes.
• Present data using charts, tables, visualizations, and summary reports.
• Identify performance trends and highlight areas requiring management attention.
• Support business reviews by preparing performance summaries and analytical reports.
• Ensure reports are easy to understand, accurate, and aligned with stakeholder requirements.
• Improve reporting formats and dashboards based on evolving business needs.

Reporting Automation & Process Improvement:

• Identify opportunities to reduce manual effort in recurring reporting activities.
• Improve existing MIS templates, reporting workflows, and data‑management processes.
• Use Excel formulas and built‑in tools to streamline data consolidation and reporting.
• Support automation of repetitive tasks to improve reporting efficiency and accuracy.
• Work with datasets while maintaining consistency and data integrity.
• Explore the use of Macros, VBA, Power Query, and other automation tools where applicable.
• Standardize reporting processes and documentation across business functions.

Stakeholder & Cross-functional Collaboration:

• Collaborate with Business, Operations, Sales, Finance, and other teams to understand reporting requirements.
• Gather and translate business requirements into structured MIS reports and dashboards.
• Provide timely and accurate information to support operational and management decisions.
• Communicate key findings, performance gaps, and trends to relevant stakeholders.
• Coordinate with different teams to resolve data discrepancies and reporting issues.
• Support management with ad hoc analysis, performance reviews, and business reporting.
• Ensure timely delivery of reports and maintain confidentiality of business information.

REQUIRED SKILLS

• 02 years of relevant experience in MIS Reporting, Data Management, Business Reporting, Operations Analytics, or a similar role. Freshers with strong Advanced Excel skills are welcome to apply.
• Strong hands‑on proficiency in Advanced Microsoft Excel is mandatory.
• Good working knowledge of Excel formulas, including VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, and other commonly used functions.
• Ability to work with Pivot Tables, Pivot Charts, conditional formatting, and data validation.
• Ability to clean, consolidate, validate, and analyze datasets.
• Understanding of MIS reporting, business reporting, and data management.
• Ability to create and maintain reports, dashboards, and trackers using Excel.
• Basic understanding of business metrics, KPIs, and performance reporting.
• Strong numerical reasoning, analytical thinking, and problem‑solving skills.
• Ability to identify data discrepancies and maintain reporting accuracy.
• Good communication and stakeholder coordination skills.
• Strong attention to detail and ability to manage reporting requirements within deadlines.

PREFERRED QUALIFICATIONS

• Hands‑on experience with Excel Macros and VBA for automating repetitive reporting tasks.
• Experience with Microsoft Power BI for dashboard creation, data visualization, and business reporting.
• Knowledge of Power Query and Power Pivot for data transformation and reporting.
• Exposure to automating recurring MIS reports and consolidating data from multiple sources.
• Familiarity with Google Sheets and advanced spreadsheet functions.
• Basic knowledge of SQL for extracting and analyzing data is an added advantage.
• Experience creating management dashboards and performance scorecards.
• Understanding of business operations, sales reporting, finance reporting, or operational analytics.
• Exposure to reporting automation, data visualization, and process improvement initiatives.
• Bachelor's degree in Commerce, Business Administration, Engineering, Computer Science, Statistics, Mathematics, or a related field.

IDEAL CANDIDATE

We are looking for someone who:

• Has strong hands‑on knowledge of Advanced Excel and is comfortable working with data.
• Can use Excel formulas, Pivot Tables, and other advanced features to solve practical reporting problems.
• Can independently prepare, validate, and maintain accurate MIS reports.
• Understands the business purpose behind reports rather than simply compiling data.
• Is curious about understanding why business performance changed, not just reporting the numbers.
• Can identify inconsistencies, investigate discrepancies, and ensure data accuracy.
• Can translate raw data into meaningful business reports and actionable insights.
• Has strong numerical reasoning, logical thinking, and attention to detail.
• Can manage multiple reports, priorities, and deadlines efficiently.
• Is interested in improving reporting processes through automation and better data management.
• Has exposure to, or is willing to learn, tools such as Macros, VBA, and Power BI.
• Can communicate findings clearly and collaborate effectively with business and operational teams.
• Is proactive, detail‑oriented, and comfortable taking ownership of assigned reporting tasks.
• Is eager to learn new tools, reporting techniques, and business processes.