MIS Executive

Advantmed India LLP; Ahmedabad District; On-site; INR 600,000 - 800,000; Full time

Job summary

Advantmed India LLP seeks a detail-oriented MIS Executive - IHA Reporting to join our growing team in India. The role focuses on preparing, validating, analyzing, and delivering operational reports to support business decision-making within the US Healthcare domain.

Strong expertise in Advanced Excel, SQL, and Power BI is essential, along with analytical and problem-solving skills. Responsibilities include report preparation, data validation, analysis for insights, and automation of repetitive

Qualifications

• Bachelor's degree in a related field.
• 2–3 years of MIS reporting, operational reporting, data analysis experience.
• Advanced Excel with PivotTables, lookups, conditional formulas, charts and data validation.
• SQL knowledge: joins, filters, aggregations, data quality checks.
• Experience in recurring/ad hoc reports in deadline-driven environments.
• Strong numerical ability, analytical thinking, attention to detail and problem-solving.
• Good written and verbal communication to explain results.

Responsibilities

• Prepare and deliver daily, weekly, monthly, quarterly and ad hoc operational reports.
• Validate data completeness, calculations and business rules before releasing reports.
• Analyze results to identify trends, variances and performance gaps and present insights.
• Build and maintain Power BI reports or dashboards.
• Automate repetitive reporting steps with improved procedures and automation.
• Maintain documentation, data dictionaries, SOPs and change controls.
• Collaborate with MIS, Automation, Operations, Planning, BI and other teams.

Skills

Advanced Excel

SQL

Power BI

Data analysis

Attention to detail

Communication skills

Education

Bachelor's degree in Commerce/Business/Statistics/Mathematics/Computer Applications/CS

Tools

MySQL

Excel macros/VBA

Python

Job description

Advantmed India LLP is looking for a detail-oriented and analytical MIS Executive - IHA Reporting to join our growing team. The ideal candidate will be responsible for preparing, validating, analyzing, and delivering operational reports that support business decision-making and performance management within the US Healthcare domain. The role requires strong expertise in Advanced Excel, SQL, and Power BI, along with excellent analytical and problem-solving skills.

Key Roles and Responsibilities:

1. Report Preparation and Delivery

• Prepare and distribute assigned daily, weekly, monthly, quarterly and ad hoc operational reports within agreed timelines.
• Maintain report calendars, distribution lists, source locations, dependencies and delivery evidence for assigned reports.
• Follow approved report formats, naming standards and communication protocols.
• Coordinate with report owners and stakeholders when source data, requirements or timelines change.

2. Data Collection and Validation

• Extract and consolidate data from approved databases, applications, Excel files and other authorized sources.
• Validate completeness, record counts, filters, calculations, date ranges and business rules before releasing reports.
• Reconcile report outputs against source data or control totals and investigate exceptions, duplicates or missing records.
• Escalate unresolved data-quality or system issues with clear examples, business impact and supporting evidence.

3. Data Analysis and Business Insights

• Analyze operational results to identify trends, variances, outliers and performance gaps.
• Prepare concise observations that explain what changed, where attention is required and what additional review may be needed.
• Support leadership and operational teams with drill-downs and ad hoc analysis based on approved requirements.
• Present data in a clear format using tables, charts, dashboards and summary views appropriate to the audience.

4. Reporting Tools and Automation

• Use advanced Excel functions, PivotTables, charts, lookups and formulas to build and maintain reporting solutions.
• Use SQL to retrieve, join, filter and summarize data from approved reporting databases.
• Build and maintain Power BI reports or dashboards where assigned and authorized.
• Identify repetitive reporting steps that can be standardized or automated and coordinate improvements with team leadership and automation resources.
• Support controlled automation of report generation and delivery through approved email, folder or FTP processes where applicable.

5. Documentation and Controls

• Maintain report definitions, data dictionaries, query logic, calculation rules, SOPs, process maps and backup instructions.
• Apply version control and change documentation to prevent unapproved or unexplained modifications.
• Maintain confidentiality and comply with approved privacy, security, access and data-handling requirements.
• Ensure critical reports have documented quality checks and continuity coverage.

6. Stakeholder Support and Team Collaboration

• Understand reporting requirements, clarify expected outcomes and communicate delivery status professionally.
• Respond to reporting questions with relevant data, clear explanations and appropriate supporting detail.
• Collaborate with MIS colleagues, Automation Analysts, Operations, Planning, BI and other departments to resolve reporting dependencies.
• Participate in team huddles, knowledge-sharing sessions, process reviews and training activities.

Required Qualifications and Experience:

• Bachelor's degree in Commerce, Business, Statistics, Mathematics, Computer Applications, Computer Science or a related field.
• Minimum 2 to 3 years of hands-on experience in MIS reporting, operational reporting, data analysis or a comparable role.
• Advanced proficiency in Microsoft Excel, including PivotTables, lookup functions, conditional formulas, charts and data validation.
• Working knowledge of SQL, including joins, filters, aggregations and data-quality checks.
• Experience preparing recurring and ad hoc reports in a deadline-driven environment.
• Strong numerical ability, analytical thinking, attention to detail and problem-solving skills.
• Good written and verbal communication skills with the ability to explain report results to business stakeholders.
• Ability to manage multiple priorities, maintain accuracy and work effectively in a fast-paced environment.

Preferred Qualifications:

• Experience supporting US healthcare, In-Home Assessment, contact-center, provider, planning or operations reporting.
• Working knowledge of Power BI, including data preparation, visual design and dashboard maintenance.
• Experience with Excel macros/VBA, Python or other reporting automation tools.
• Knowledge of database concepts, MySQL, scheduled reporting, FTP or automated email distribution.
• Exposure to process mapping, root-cause analysis, Lean Six Sigma or continuous-improvement methods.

Suggested Candidate Assessment Areas:

• Excel exercise covering lookups, conditional formulas, PivotTables, charts and data-quality checks.
• SQL exercise covering joins, filters, aggregations, date logic and duplicate identification.
• Report-validation scenario requiring reconciliation between source data and a summary output.
• Business-insight exercise requiring the candidate to identify trends, exceptions and a concise management summary.
• Documentation exercise requiring a short report definition or SOP for a recurring deliverable.