Senior Executive - BI & MIS

Key Responsibilities Prepare daily, weekly, and monthly MIS reports and dashboards for management and business teams. Collect, validate, and analyze data from multiple sources to ensure accuracy and consistency. Develop and maintain automated reports using Excel, Power BI, Google Sheets, SQL, or other reporting tools. Monitor business KPIs and provide performance analysis to support strategic decisions. Create operational dashboards for sales, customer support, marketing, finance, and other functional teams. Identify data discrepancies and coordinate with respective teams for timely correction. Generate ad hoc reports and analytical summaries based on management requirements. Maintain and update master databases, user records, and operational trackers. Ensure data integrity, confidentiality, and compliance with company policies. Support process automation initiatives to reduce manual reporting efforts. Analyze trends, productivity, and operational performance and provide actionable recommendations. Coordinate with cross-functional teams to understand reporting requirements and deliver timely solutions. Maintain proper documentation of reports, data sources, and reporting processes. Train junior MIS executives on reporting standards, formulas, dashboards, and data validation processes. Continuously improve reporting efficiency and dashboard usability. Required Skills Advanced Microsoft Excel (Pivot Tables, Power Query, Power Pivot, XLOOKUP, INDEX-MATCH, advanced formulas, dashboards, and automation). Strong knowledge of Power BI or other BI tools. Good understanding of SQL and database concepts. Strong analytical and problem-solving skills. Excellent attention to detail and data accuracy. Ability to interpret business data and present insights in a simple and actionable manner. Strong communication and stakeholder management skills. Ability to handle multiple reporting requirements and meet strict deadlines. Knowledge of CRM, ERP, and operational reporting systems is an added advantage.