EY - Data Analyst - Land Acquisition Monitoring

Develop and maintain a centralized land acquisition data and monitoring framework for UPAVP projects across approximately 28 locations in Uttar Pradesh and other sites. Convert multi-source records into reliable progress information, exception reports, and management‑ready insights.

• Develop, structure, and maintain a comprehensive database of land acquisition activities and records.
• Collect, compile, standardize, and validate information from project/location offices and other sources.
• Maintain project‑wise and location‑wise information on acquisition progress, statutory approvals, compensation payments, possession status, and pending matters.
• Define and apply data‑quality checks to identify missing fields, duplicate records, inconsistent dates, conflicting figures, and outdated status information.
• Follow up with relevant offices to clarify data gaps, reconcile inconsistencies, and update records with an audit trail.
• Develop MIS reports, dashboards, analytical summaries, and periodic progress reports for management review.
• Track milestones, delays, and pending actions; identify bottlenecks, emerging risks, and issues that may affect completion of land acquisition.
• Prepare exception reports highlighting overdue actions, stalled cases, incomplete documentation, and other matters requiring management attention.
• Use spreadsheet, database, and visualization tools to organize data and present trends in a clear, decision‑oriented manner.
• Maintain version control, data dictionaries, reporting definitions, and documentation of key assumptions to promote consistent reporting.
• Undertake additional data analysis and reporting assignments for UPAVP locations or projects as required.

• Bachelor's degree in a quantitative discipline such as Statistics, Mathematics, Economics, Engineering, Computer Science, Information Systems, or Business Analytics.
• 6–10 years of experience in data analysis, MIS, project monitoring, reporting, database management, or analytics.
• Advanced spreadsheet skills (data cleaning, look‑ups, pivot tables, validation).
• Working knowledge of a dashboard/visualization tool such as Power BI or Tableau.
• Experience with SQL, Power Query, or other data‑management tools.