Senior Analyst || Business Reporting - COE || Pune

About FirmEstablished in 1978, M S K A & Associates is an Indian partnership firm registered with the Institute of Chartered Accountants of India (ICAI) and the PCAOB (US Public Company Accountancy Oversight Board). A member firm of BDO International that offers a range of Assurance services, led by 80+ Partner & Directors and 1900+ staff across 11 cities - Ahmedabad, Bengaluru, Chennai, Chandigarh, Goa, Hyderabad, Kochi, Kolkata, Mumbai, Gurugram, and Pune. Having extensive experience, knowledge and industry foresight, our experts deliver robust, transparent and technology-driven services and provide bespoke solutions to clients. Our portfolio includes services like Statutory, Ind AS Conversion, IFC, Tax, Accounting Manual, Limited Review, Group Reporting, Certification and Capital Market Support.About COEM S K As COE Practice supports Firms client serving Assurance teams with performing testing procedures including substantive and controls testing, vouching, verification etc. across industry sectors, including manufacturing, real estate, information technology etc. Firms COE enables its client serving Assurance teams to meet their requirements. As part of our COE Team, you would be the main point of contact for the tasks assigned by the client serving assurance teams and be responsible for test of controls, substantive testing etc. Also, you will be responsible for maintaining the timeliness and quality of deliverables along with managing day to day operations of those engagements.RequirementPosition - Business Reporting - Senior AnalystLocation - PuneExperience - 1 to 3 years of experience in reporting, MIS, business analytics, or related roles.Qualification- Master’s or Bachelor's degree in Business Administration, Commerce, Finance, Statistics, Computer Science, or related field. Microsoft certifications would be an added advantage.Skills - Knowledge of Advanced Excel, PPT, Power BI. Experience with data visualization and dashboard creation.Job SummaryWe are seeking a detail-oriented and analytical Excel and Reporting Analyst to support business reporting, data analysis, dashboard development, and management reporting activities.The candidate will be responsible for developing, maintaining, automating, and improving periodic and ad hoc reports using Microsoft Excel, while also leveraging Power BI for data visualization and dashboarding and PowerPoint for management presentations.The role requires strong expertise in Excel, the ability to consolidate and analyse data from multiple sources, identify trends and business insights, and present information through clear, structured, and visually effective reports and dashboards.The candidate will work closely with business and cross-functional teams to understand reporting requirements, ensure data accuracy, track KPIs, and deliver timely management information.Key Responsibilities

• Develop, maintain, and automate periodic reports using Microsoft Excel.
• Analyze large and complex datasets to identify trends, patterns, variances, and actionable business insights.
• Create and maintain dashboards, trackers, MIS reports, KPI reports, and performance reports.
• Use Power Query to clean, transform, merge, and automate data preparation wherever applicable.
• Develop and maintain Power BI dashboards and reports for business performance monitoring and visualization.
• Create meaningful charts, graphs, dashboards, and visualizations to communicate business performance effectively.
• Prepare professional PowerPoint presentations and management decks for leadership reviews, business meetings, and performance discussions.
• Convert complex data and analysis into clear management insights and visual storytelling.
• Identify opportunities to improve reporting processes through automation, standardization, and process optimization.
• Maintain reporting templates, data models, trackers, and reporting documentation.
• Perform data quality checks and reconciliation before publishing reports.
• Ensure timely and accurate delivery of management reports and business updates.
• Support continuous improvement of reporting processes, dashboards, and analytical outputs.Required Skills
• Advanced proficiency in Microsoft Excel / Power BI / PowerPoint
• Strong analytical, problem-solving, and data interpretation abilities.
• Ability to understand business requirements and collaborate with cross-functional teams.
• Strong focus on data accuracy, quality, and timely delivery.