Senior Data Specialist - MIS

Access Healthcare; Zone 7 Ambattur; On-site; INR 500,000 - 750,000; Full time

Job summary

Access Healthcare is seeking a data and MIS analyst to collect, consolidate, validate, and maintain data from multiple sources. You will prepare regular MIS reports and develop Power BI dashboards to track KPIs, while ensuring accuracy and timely delivery.

The role requires strong Excel, Power BI, SQL, and data visualization skills, with experience in automation using Power Automate and Power Query. You will collaborate with stakeholders to provide actionable insights.

Qualifications

• Advanced MS Excel skills.
• Knowledge of Power BI and SQL.
• Knowledge of Power Query and VBA is preferred.
• Strong analytical, data visualization, and presentation skills.

Responsibilities

• Collect, consolidate, validate, and maintain data from multiple sources.
• Prepare daily, weekly, monthly, and ad-hoc MIS reports.
• Ensure accuracy and timely delivery of reports.
• Identify data discrepancies and coordinate with stakeholders for resolution.
• Develop and maintain Power BI dashboards and KPI reports.
• Analyze trends, variances, and performance gaps and provide actionable insights.
• Support management with data analysis and presentations.
• Identify manual reporting activities and implement automation solutions.
• Use Excel, Power Query, VBA, SQL, and Power Automate to improve reporting efficiency.
• Develop and maintain automated data transformation and reporting processes.
• Maintain data validation and quality checks.

Skills

Excel

Power BI

SQL

Power Query

VBA

Data visualization

Data analysis

Presentation skills

Tools

Power BI

SQL

Power Automate

Job description

Key Responsibilities

• Collect, consolidate, validate, and maintain data from multiple sources.
• Prepare daily, weekly, monthly, and ad-hoc MIS reports.
• Ensure accuracy and timely delivery of reports.
• Identify data discrepancies and coordinate with stakeholders for resolution.
• Develop and maintain Power BI dashboards and KPI reports.
• Analyze trends, variances, and performance gaps and provide actionable insights.
• Support management with data analysis and presentations.
• Identify manual reporting activities and implement automation solutions.
• Use Excel, Power Query, VBA, SQL, and Power Automate to improve reporting efficiency.
• Develop and maintain automated data transformation and reporting processes.
• Maintain data validation and quality checks.

Required Skills

• Advanced MS Excel skills.
• Knowledge of Power BI and SQL is an added advantage.
• Knowledge of Power Query and VBA is preferred.
• Strong analytical, data visualization, and presentation skills.
• Ability to work with large datasets and multiple data sources.
• Basic understanding of ETL and data transformation processes.

Experience

• 3 to 5 years of experience in MIS, Reporting, Data Analytics, or a related field.
• Experience in Excel-based reporting and data analysis.
• Experience working with multiple stakeholders and handling ad-hoc reporting requirements.