Job DescriptionAbout the Role

NAdvantmed 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 robust expertise in Advanced Excel, SQL, and Power BI, along with excellent analytical and problem-solving skills.

NKey Roles and Responsibilities:

N1. Report Preparation andDelivery

N

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

n2. Data Collectionand Validation

N

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

n3. Data Analysis and Business Insights

N

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

n4. Reporting Toolsand Automation

N

n




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

n5. Documentation and Controls

N

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

n6. Stakeholder Support and Team Collaboration

N

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

nRequired Qualifications and Experience:

N

n
- Bachelor's degreein Commerce, Business, Statistics,



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

nPreferred Qualifications:

N

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

nSuggested Candidate Assessment Areas:

N

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

📌 Hiring: Mis Executive (Ahmedabad)
🏢 Advantmed India
📍 Ahmedabad