DATA MANAGEMENT & BUSINESS REPORTING Department Location Role Purpose Merchandising & Planning DLF Cyber Park, Gurgaon Employment Type Reporting To Contractual Department Manager The MIS Executive will manage, validate, consolidate, and analyze business data to ensure accurate and timely reporting. The role will maintain structured databases, automate recurring reports, develop dashboards, and translate operational data into actionable insights for business teams and management. Key Responsibilities • Collect, consolidate, and maintain data received from different departments and business systems. • Perform data validation, cleansing, reconciliation, and quality checks to ensure accuracy, consistency, and completeness. • Maintain master data, reporting trackers, databases, and standardized reporting templates with proper version control. • Prepare and circulate daily, weekly, and monthly MIS reports within agreed timelines. • Develop and maintain dashboards for tracking KPIs, trends, variances, and operational performance. • Extract, organize, and analyze data using advanced Excel, SQL, and business intelligence tools. • Automate repetitive reports and data-processing activities to reduce manual effort and reporting errors. • Conduct trend, variance and root-cause analysis and highlight exceptions, risks and improvement opportunities. • Prepare ad-hoc reports and analytical summaries based on business and management requirements. • Coordinate with cross-functional stakeholders to understand data requirements and resolve data gaps. • Maintain confidentiality, access control, and appropriate handling of business data. • Document reporting definitions, data sources, calculation logic, and standard operating procedures. Key Deliverables • Accurate and timely MIS reports and dashboards. • Clean, structured, and reliable data repositories. • Clear data insights supporting business decisions and process improvement. • Consistent KPI definitions and reporting standards across stakeholders. Education & Experience • Bachelor's degree in commerce, Management, Statistics, Mathematics, Computer Applications, Business Analytics or related discipline. • 2 to 5 years of relevant experience in MIS, data management, reporting, operations analytics, or business analytics. • Experience in handling large data sets and coordinating reporting requirements across departments is preferred. Technical Skills • Advanced Microsoft Excel, including PivotTables, XLOOKUP, logical formulas, charts and data validation. • Working knowledge of Power Query and report automation. Behavioral Competencies • Strong attention to detail and commitment to data accuracy. • Analytical thinking and structured problem-solving ability. • Ability to prioritize recurring and ad-hoc reporting requirements. • Clear communication and effective stakeholder coordination.

Bachelor's degree in commerce, Management, Statistics, Mathematics, Computer Applications, Business Analytics or related discipline.