Oswal Computer & Consultants

We are seeking a detail-oriented and analytical Business Analyst cum MIS Executive with strong expertise in Advanced Excel to support business decision-making through data-driven insights. The ideal candidate will be responsible for preparing reports, analyzing performance metrics, automating dashboards, and assisting in process improvement initiatives. Key Responsibilities: Collect, consolidate, and analyze business data from multiple sources to prepare daily, weekly, and monthly MIS reports. Design and maintain automated dashboards and reports using Advanced Excel tools (Pivot Tables, Power Query, Power Pivot, VBA, Macros, etc.) . Identify business trends, variances, and key performance indicators (KPIs) to support management decisions. Work with cross-functional teams ( Finance, Operations, etc.) to gather and validate data requirements. Provide analytical insights and recommendations for process optimization and cost efficiency. Ensure data accuracy, integrity, and timely delivery of reports to stakeholders. Assist in business forecasting, budgeting, and performance tracking. Support ad-hoc data analysis and presentation preparation for management reviews. Required Skills and Competencies: Advanced Excel proficiency Pivot Tables, Power Query, Power Pivot, Lookups, Conditional Formatting, VBA & Macros. Strong analytical and problem-solving skills with attention to detail. Ability to handle large datasets and data visualization. Proficiency in MS Power BI (preferred but not mandatory). Excellent communication and presentation skills. Strong time management and organizational abilities. Qualifications: Bachelor’s degree in Commerce, Business Administration, Statistics, Economics, Computer Science , or a related field. 0–3years of experience in MIS reporting, business analysis, or data analytics roles. Experience in data automation and dashboard creation preferred. Key Performance Indicators (KPIs): Accuracy and timeliness of MIS reports. Efficiency in automating reporting processes. Quality of business insights and recommendations. Stakeholder satisfaction with analytical support.