Key Responsibilities Design develop and maintain advanced Excel automation solutions including VBA macros userdefined functions custom forms and automated reporting tools for diverse business functions Build and maintain complex Excel formula frameworks using advanced functions including INDEX MATCH XLOOKUP dynamic arrays LAMBDA functions and nested conditional formulas Develop and manage Power Query data transformation workflows for automating data extraction cleansing consolidation and loading from multiple internal and external data sources Build and maintain automated MIS dashboards management reports and operational scorecards using Excel and Power BI with scheduled data refresh and agile filtering capabilities Collaborate with operations finance HR sales and other business teams to understand reporting requirements and translate them into efficient and maintainable Excel automation solutions Identify and automate repetitive manual reporting data processing and reconciliation tasks across business functions to improve team productivity and reduce error rates Conduct Excel automation testing including unit testing user acceptance testing and regression testing to ensure automation solutions function accurately and reliably Train and support end users and business teams on developed Excel automation tools macros and reporting dashboards Maintain comprehensive documentation for all developed Excel automation solutions including solution design documents user guides and maintenance manuals Stay updated with latest Microsoft Excel Power Query Power Automate and Power BI features and evaluate applicability for improving existing automation solutions Required Skills and Qualifications 35 years of handson experience in Excel automation VBA development or business intelligence reporting roles Expertlevel proficiency in Microsoft Excel including VBA macro development advanced formula writing Power Query and dynamic array functions Strong experience with Excel VBA for developing automated reporting tools custom user forms and workflow automation solutions Good working knowledge of Power Query for data extraction transformation and loading from diverse data sources Experience with Power BI for developing interactive dashboards and automated reports connected to Excel and other data sources Familiarity with Power Automate for extending Excel automation workflows into broader business process automation scenarios Strong understanding of data modeling database concepts and SQL for integrating Excel automation solutions with relational databases Good analytical and problemsolving skills with a structured approach to identifying and automating manual reporting and data processing tasks Strong attention to detail with the ability to develop accurate reliable and maintainable Excel automation solutions Good communication skills in English and Hindi for crossfunctional and stakeholder coordination Graduate in Computer Science IT Mathematics Statistics or a related discipline is preferred

📌 Excel Automation Specialist (Mumbai)
🏢 NEWAGE TECH SOLUTION PRIVATE
📍 Mumbai