MIS/ Power BI / Data Specialist

Planning, Data Forecasting, Trend Analysis, Data Maintenance & Management (PAN India):
Align the MIS Plan with those of the Operations of the Arts & Rural Verticals
Obtain the planning data from Teams of both Arts & Rural Verticals:
o Number of Batches per Team
o Total Estimated Target to create the batches
o Count of beneficiaries to be trained by respective Team Leaders
Maintain data, Forecast Data Trends (PAN India)
Analyze PAN India Data which will include data cleaning, maintaining, calculations, computing recomputing variables etc for monitoring and evaluation purposes. The analysis would also be trade-wise, batch-wise, and city-wise, to understand the status of attendance and assessment of mid-term and final examinations conducted by PAN India in both verticals and submit the same to the General Managers of both verticals
Maintain the above data systematically as per the prescribed format
Perform regular backups to ensure data prevention
Be responsible for all clinical data management activities in compliance with Standard Operating Procedures (SOPs) and current industry/regulatory guidelines

Reporting & Documentation (PAN India):
Prepare Attendance Sheet data based on the above inputs
Prepare Monthly, Quarterly, Half-yearly, Annual Data Analysis Reports & Donor Reports from the Arts & Rural Teams and submit the same to the General Managers of both verticals
Use MS Excel and Power Business Intelligence (BI) software for the creation & analysis of Reports / Documentation purpose.

Training coordination (PAN India):
Facilitate Trainings for staff to guide them to effectively use Excel for operations
Coordinate with external Training Partners and guide them to effectively use Excel for operations

Events Management:
Support the Arts & Rural teams, technically and functionally, across the different events