MIS Executive – Data & Reporting

Organization: Dr. Chate's Homeopathy Clinic

Job Overview

Dr. Chate's Homeopathy Clinic is looking for a detail-oriented and technically skilled MIS Executive to manage, extract, analyze, and report business data.

The role will primarily involve working with Excel and Google Sheets data, extracting and organizing data using SQL, and creating meaningful reports and dashboards using Power BI.

We are looking for a candidate who is comfortable working with large datasets, understands data structures, can identify and correct data issues, and can convert raw data into accurate reports for management.

This is a Data & MIS Reporting role and is not a web development position.

Key Responsibilities

- Manage and maintain large datasets in MS Excel and Google Sheets.
- Extract, clean, organize, and analyze data from Excel, Google Sheets, and other data sources.
- Use SQL queries to extract required data from databases.
- Perform data filtering, sorting, validation, and reconciliation to ensure data accuracy.
- Identify missing, duplicate, incorrect, or inconsistent data and take appropriate corrective action.
- Use Excel advanced functions such as VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, IF, and other relevant formulas.
- Create Pivot Tables, Pivot Charts, summaries, and automated reports in Excel/Google Sheets.
- Prepare daily, weekly, and monthly MIS reports for management.
- Use Power BI to import, transform, analyze, and visualize data.
- Create Power BI dashboards and interactive reports based on business requirements.
- Connect Power BI with relevant data sources and maintain existing dashboards/reports.
- Extract required information using SQL and prepare it for Power BI reporting.
- Analyze data and identify trends, discrepancies, and important insights for management.
- Maintain proper data records and reporting formats.




- Coordinate with different departments to collect required data and resolve data-related issues.
- Ensure reports are accurate and submitted within the required timelines.
- Maintain confidentiality of clinic and organizational data.

Technical Skills Required

- Advanced MS Excel
- Advanced Google Sheets
- SQL – Data Extraction and Querying
- Power BI – Data Analysis, Visualization and Dashboard Creation
- Pivot Tables and Pivot Charts
- Excel formulas and data functions
- Data Cleaning and Data Validation
- Data Analysis and MIS Reporting

Important Skills

- Strong data-handling and analytical skills
- Valuable understanding of databases and structured data
- Ability to extract data using SQL
- Ability to work with large Excel/Google Sheets datasets
- Strong attention to detail and accuracy
- Good problem-solving ability
- Ability to convert raw data into meaningful reports
- Good communication and coordination skills

Qualifications & Experience

- Graduate in any relevant discipline such as BCA, BSc, B.Com, BBA, Computer Science, IT, Statistics, or a related field.
- Strong practical knowledge of Excel/Google Sheets is required.
- Practical knowledge of SQL and Power BI is required.
- Previous experience in MIS, Data Analyst, Reporting, Business Intelligence, or Data Management will be preferred.
- Freshers can apply if they have strong practical skills in Excel/Google Sheets, SQL, and Power BI.

Key Note

This position is focused on MIS, data extraction, analysis, reporting, and dashboard creation.

Candidates primarily looking for Web Development, Software Development, Front-End Development, Back-End Development, or Website Development roles should not apply.

Skills

Advanced MS Excel | Google Sheets | SQL | Power BI | Data Extraction | Data Cleaning | Data Analysis | MIS Reporting | Dashboard Creation | Pivot Tables | Reporting

Pay: ₹15,000.00 - ₹20,000.00 per month

Work Location: In person

📌 MIS Executive (Aurangabad)
🏢 chate's homeopathy clinic
📍 Aurangabad