MIS Executive

Duflon Industries; Mahad; On-site; INR 500,000 - 800,000; Full time

Job summary

Duflon Industries is seeking a data-driven MIS Analyst to design and maintain daily, weekly, and monthly reports, dashboards, and operational trackers. You will ensure accuracy and timely delivery to stakeholders, while coordinating with cross-functional teams to gather requirements and provide insights.

The role emphasizes data governance, data cleansing, and automation using Excel, Power Query, VBA, and Power BI, enabling real-time visibility into performance and enabling informed

Qualifications

• Experience in creating MIS reports and dashboards.
• Strong data governance and data cleansing capabilities.
• Proficiency with SQL data extraction and Power BI.

Responsibilities

• Design, develop, and maintain daily, weekly, and monthly MIS reports.
• Ensure accuracy and timely delivery of reports.
• Manage large datasets from multiple sources and validate data.
• Analyze data to identify trends and insights for decision-making.
• Automate reporting processes using Excel, Power Query, and VBA.
• Develop and maintain Power BI dashboards for real-time visibility.

Skills

MS Excel

MIS reporting

Data analysis

Dashboard creation

Stakeholder communication

Tools

Power BI

Power Query

VBA/Macros

SQL

Database management systems

Job description

Role & responsibilities

1. MIS Reporting & Management

• Design, develop, and maintain daily, weekly, and monthly MIS reports and operational trackers.
• Ensure 100% accuracy and timely delivery of reports to stakeholders.
• Prepare ad-hoc reports and analysis based on business requirements.
• Develop standardized reporting templates and reporting mechanisms.

2. Database Management & Data Governance

• Manage and maintain large datasets and databases from multiple sources.
• Ensure data integrity, consistency, and confidentiality.
• Audit source files and databases to identify discrepancies and anomalies.
• Perform regular data cleansing and validation activities.

3. Data Analysis & Business Insights

• Analyze operational and business data to identify trends, patterns, and opportunities.
• Prepare management summaries and analytical reports.
• Support decision-making through data-driven recommendations.
• Conduct root cause analysis for performance deviations.

4. Process Automation & Continuous Improvement

• Identify inefficiencies in existing reporting processes.
• Automate repetitive activities using advanced Excel formulas, Power Query, and VBA/Macros.
• Develop efficient data extraction and transformation mechanisms.
• Drive continuous improvement initiatives in reporting processes.

5. Dashboard Development & Business Intelligence

• Develop and maintain interactive dashboards using Power BI or similar BI tools.
• Create visual representations of KPIs and business metrics.
• Provide real-time visibility into operational performance.
• Customize dashboards based on stakeholder requirements.

6. Stakeholder Management & Communication

• Coordinate with cross-functional teams to gather reporting requirements.
• Present analytical findings and reports in a clear and concise manner.
• Support management reviews and business meetings with relevant data and insights.
• Train users on reports and dashboard utilization where required.

Skills Required

Technical Skills

• Advanced proficiency in MS Excel
• Strong working knowledge of SQL for data extraction and querying.
• Hands-on experience with Power BI or similar Business Intelligence tools.
• Strong understanding of database management and data structures.
• Knowledge of data cleansing, validation, and governance practices.

Functional Skills

• MIS reporting and dashboard creation.
• Data extraction and consolidation.
• Data analytics and interpretation.
• Process automation and continuous improvement.
• Database management and administration.

Behavioral Competencies

• Strong analytical and problem-solving ability.
• Attention to detail and high accuracy orientation.
• Excellent numerical aptitude.
• Ability to manage large volumes of data.
• Strong communication and presentation skills.
• Stakeholder management and collaboration.
• Ability to work under tight timelines and manage multiple priorities.
• Continuous learning and improvement mindset.