Mis Executive

Bonito Designs; Ahmedabad District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Bonito Designs in Ahmedabad is seeking a skilled MIS analyst to develop, maintain, and drive dashboards and reports across business functions using Power BI. You will collect and clean data from ERP, CRM, Excel, and project tools to produce timely insights for leadership.

The role emphasizes data integrity, KPI tracking, and automation of reporting processes, with collaboration across teams to define requirements and deliver periodic daily, weekly, and monthly reports.

Qualifications

• Bachelor's degree in Business, Statistics, CS, or a related field.
• 2–5 years in MIS, data analysis, or reporting roles.
• Mandatory: strong Power BI skills (DAX, data modeling)
• Advanced Excel skills (Pivot, VLOOKUP, Power Query)
• Strong analytical, detail-oriented, and stakeholder communication skills

Responsibilities

• Develop, maintain, and manage MIS reports and dashboards.
• Design interactive dashboards using Power BI.
• Collect, clean, and analyze data from ERP, CRM, Excel, and project tools.
• Track KPIs such as timelines, cost, vendor performance, and sales metrics.
• Automate reporting processes for efficiency and accuracy.
• Provide actionable insights to management for strategic decision-making.
• Ensure data integrity, consistency, and accuracy across reports.
• Coordinate with cross-functional teams to understand reporting requirements.
• Prepare periodic reports (daily, weekly, monthly) for leadership review.

Skills

Power BI

Excel

Data Analysis

Reporting

Stakeholder Management

Education

Bachelor's degree in Business/Statistics/CS

Tools

SQL

Power BI

Job description

Key Responsibilities

• Develop, maintain, and manage MIS reports and dashboards for various business functions
• Design interactive dashboards and visualizations using Power BI
• Collect, clean, and analyze data from multiple sources (ERP, CRM, Excel, project tools)
• Track key performance indicators (KPIs) such as project timelines, cost efficiency, vendor performance, and sales metrics
• Automate reporting processes to improve efficiency and accuracy
• Provide actionable insights to management for strategic decision-making
• Ensure data integrity, consistency, and accuracy across reports
• Coordinate with cross-functional teams to understand reporting requirements
• Prepare periodic reports (daily, weekly, monthly) for leadership review
• Identify trends, risks, and opportunities within business data

Required Skills & Qualifications

• Bachelors degree in Business, Statistics, Computer Science, or related field
• 2–5 years of experience in MIS, data analysis, or reporting roles
• Mandatory: Strong proficiency in Power BI (dashboard creation, DAX, data modeling)
• Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUP, Power Query)
• Experience working with databases and data extraction (SQL is a plus)
• Strong analytical and problem-solving skills
• High attention to detail and accuracy
• Good communication and stakeholder management skills