Term of Reference for Consultant- Data Analytics
Position Name: Consultant – Data Analytics
Reporting Line: Sr. Program Manager – THR
Tenure: September 2026 – May 2027
Positions: 1
Location: Lucknow, Uttar Pradesh
About PCI India: –
PCI India, a registered Indian society, has been working in India for the past 26 years. We drive interventions to transform the lives of communities at scale by solving complex development problems. In the past year, PCI India reached more than 1.5 crore, i.e. 15 million people in1649 Blocks of 163 Districts in 14 States.
About the Project: –
PCI India is providing technical assistance to the Uttar Pradesh State Rural Livelihood Mission (UPSRLM) around the integration of Health & Nutrition interventions with community platforms promoted by UPSRLM. UPSRLM has converged with the Department of Child Development, Government of Uttar Pradesh, to produce and supply Take Home Ration (THR) / supplementary food products to ICDS beneficiaries through Self-Help Groups (SHGs). The initiative is being implemented across 43 districts of Uttar Pradesh.
The Consultant – Data Analytics will support the THR programme in strengthening data management, data quality, MIS, analytics, dashboards, performance monitoring and reporting systems. The Consultant will work closely with the Senior Program Manager, PCI State Team, THR units, field teams, UPSRLM, government stakeholders and other relevant partners.
Key Roles & Responsibilities: –
- Data Management and Governance
- Review and strengthen existing data-management systems, processes and reporting mechanisms for the THR programme.
- Develop and maintain standardized data formats, trackers, databases and data dictionaries.
- Ensure data accuracy, completeness, consistency and timely availability.
- Establish data validation and quality-assurance mechanisms across different data sources.
- Identify and address data gaps, inconsistencies, duplication and reporting bottlenecks.
- Data Collection and MIS
- Support the design, development and improvement of digital data-collection tools and MIS systems.
- Consolidate and manage data received from districts, THR enterprises, field teams and other programme platforms.
- Strengthen systems for regular data entry, validation, consolidation and reporting.
- Support integration of data from multiple sources, including field-level and technology-enabled systems.
- Explore opportunities for automation of routine data management and reporting processes.
- Data Analytics and Performance Monitoring
- Analyse programme data to identify trends, performance gaps, operational bottlenecks and emerging issues.
- Conduct district-, THR-unit- and indicator-level performance analysis.
- Develop performance trackers and analytical frameworks for monitoring programme progress.
- Generate actionable insights to support programme planning, review and decision-making.
- Undertake advanced/predictive analysis wherever relevant and feasible.
- Dashboard and Data Visualization
- Develop, update and maintain interactive dashboards using Power BI, Tableau or other appropriate tools.
- Develop dashboards for monitoring key THR programme indicators and performance.
- Ensure dashboards provide simple, timely and actionable information for programme and government stakeholders.
- Regularly update dashboards using validated programme data.
- Develop data visualizations, charts and presentations for management and stakeholder reviews.
- Reporting and Documentation
- Prepare regular monthly, quarterly and annual analytical reports.
- Provide data-backed inputs for programme review meetings and management presentations.
- Prepare analytical briefs, performance summaries and data visualizations for senior management, government and other stakeholders.
- Support donor and government reporting requirements.
- Document key trends, findings, challenges, good practices and programme learnings.
- Capacity Building and Technical Support
- Train and mentor programme and field teams on data collection, data quality, MIS, analytics and dashboard use.
- Provide technical support to teams for interpretation and utilization of programme data.
- Develop simple SOPs, guidance notes and tools for data management and reporting.
- Strengthen the capacity of relevant teams to use data for programme improvement.
- Stakeholder Coordination
- Coordinate with UPSRLM, district-level government officials, THR functionaries, PCI State Team and other stakeholders on data and reporting requirements.
- Support data requirements for programme reviews, assessments and evaluations.
- Coordinate with external evaluators, donors and government agencies wherever required.
- Field Engagement and Data Validation
- Undertake field visits as required to understand data-generation processes and validate reported information.
- Work with district and field teams to identify and resolve data-quality issues.
- Provide field-level support for strengthening data collection and reporting processes.
- Innovation and Continuous Improvement
- Identify opportunities to improve the efficiency, reliability and usability of programme data systems.
- Introduce appropriate digital and analytical solutions for improved programme monitoring.
- Review and refine MIS, dashboards and analytical systems based on user feedback and evolving programme requirements.
- Support to Programme Management
- Provide timely data, analysis, performance summaries, presentations and analytical inputs to the Senior Program Manager and PCI State Team.
- Support evidence-based decision-making and identification of priority areas requiring management attention.
- Undertake any other data analytics, MIS, reporting or programme-related responsibilities assigned by the Reporting Manager and aligned with the scope of the consultancy.
Month-wise Key Deliverables
| S. No. | Timeline | Key Deliverables |
| 1 | Month 1
Sept 2026 |
• Conduct an initial assessment of existing THR data systems, MIS, reporting formats, databases, dashboards and data flows.
•Map key data sources, indicators, reporting requirements and stakeholders. •Identify major data-quality gaps, duplication, inconsistencies and reporting bottlenecks. •Develop/strengthen a data-management and reporting framework. • Establish baseline performance indicators and data-quality monitoring mechanisms. • Develop/strengthen standard data formats, trackers and validation checks. •Submit a consolidated monthly report covering baseline findings, key gaps, actions taken, achievements, challenges and next-month priorities |
| 2 | Month 2
Oct 2026 |
•Strengthen data collection, consolidation and validation processes across THR programme locations.
•Develop/standardize key MIS and performance-monitoring trackers. • Conduct data-quality assessment and reconciliation of available datasets. •Develop initial analytical reports covering key programme indicators. •Initiate development/upgradation of management dashboards. •Support programme teams in interpreting data and identifying performance gaps. •Submit monthly analytical report and management update. |
| 3 | Month 3
Nov 2026 |
•Strengthen district- and THR-unit-level performance monitoring systems.
•Develop/update dashboards for key programme indicators. •Analyse trends, performance gaps and operational bottlenecks using available programme data. • Establish regular data-quality and exception-reporting mechanisms. • Support field/district teams in improving data accuracy and timely reporting. •Provide analytical inputs for programme review meetings. • Submit consolidated monthly report with key insights and recommended actions. |
| 4 | Month 4
Dec 2026 |
• Conduct deeper analysis of programme performance and identify key trends and gaps.
•Strengthen Power BI/other dashboard-based reporting and visualization. • Develop automated/standardized analytical reports wherever feasible. • Analyse district/THR-unit performance and identify priority areas for management action. • Review effectiveness of existing MIS and recommend improvements. • Provide data-backed inputs for quarterly/programme reviews. •Submit monthly analytical report and updated dashboards. |
| 5 | Month 5
Jan 2027 |
• Strengthen advanced analytics for programme performance monitoring.
• Conduct comparative analysis across districts/THR units and identify high- and low performing areas. • Develop performance trend analysis and exception reports. • Support management in using data for operational planning and corrective actions. • Strengthen dashboard functionality and data visualization for management use. • Provide analytical inputs for donor/government presentations and reports, as required. • Submit consolidated monthly report. |
| 6 | Month 6
Feb 2027 |
• Review the effectiveness and utilization of MIS, dashboards and data systems developed during the assignment.
• Conduct data-quality review and reconciliation across key programme datasets. • Identify recurring data and reporting challenges and recommend corrective measures. •Strengthen analytical products for programme performance reviews. • Support capacity building of relevant teams on data interpretation and dashboard utilization. • Document key data-driven programme insights and emerging good practices. • Submit monthly report covering progress, findings, actions and recommendations. |
| 7 | Month 7
Mar 2027 |
• Conduct advanced analysis of programme performance trends and operational indicators.
• Strengthen predictive/analytical approaches, where appropriate, to identify emerging risks and performance issues. • Review district-level performance and support identification of priority interventions. • Further improve dashboard visualization and management information products. • Support programme leadership with evidence for strategic and operational decision making. • Document key analytical findings and programme learning. • Submit consolidated monthly analytical report. |
| 8 | Month 8
Apr 2027 |
• Conduct a comprehensive review of programme data and performance trends during the assignment period.
• Consolidate key programme indicators and develop trend/performance summaries. • Review achievements against established data and performance benchmarks. • Identify key lessons, data gaps and opportunities for strengthening the programme data architecture. • Develop recommendations for institutionalization and sustainability of MIS, dashboards and analytics systems. •Support preparation of programme review/donor/government presentations and reports. • Submit monthly report and consolidated analytical findings. |
| 9 | Month 9
May 2027 |
• Conduct final review of data systems, dashboards, MIS and analytical processes strengthened during the consultancy.
• Prepare a consolidated programme performance and data analytics report covering major trends, achievements, gaps and key insights. • Document key learnings, good practices, innovations and recommendations for future programme implementation. • Develop recommendations for sustaining and further strengthening data-driven programme management. • Ensure handover of dashboards, trackers, reporting formats, documentation and other analytical products to the relevant PCI/programme team. • Provide final analytical inputs for programme planning and future scale-up. • Submit Final Consultancy Report along with all agreed data, dashboards, analytical outputs and knowledge products. |
Expected Outputs
- Strengthened THR programme data-management and MIS system.
- Improved data quality, completeness and consistency across programme datasets.
- Functional and regularly updated management dashboards.
- Regular district/THR-unit performance analysis and data-backed management reporting.
- Timely monthly, quarterly and annual analytical reporting.
- Data-backed identification of performance gaps and operational bottlenecks.
- Improved capacity of programme teams in data management and data utilization.
- Consolidated programme insights, learning and recommendations.
- Sustainable systems for continued data-driven decision-making.
Application closure date: – 14th October 2026