Excel Automation Specialist

Key Responsibilities:
- Design, develop, and maintain advanced Excel automation solutions including VBA macros, user-defined 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 dynamic 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:
- 3-5 years of hands-on experience in Excel automation, VBA development, or business intelligence reporting roles
- Expert-level 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 problem-solving 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 cross-functional and stakeholder coordination
- Graduate in Computer Science, IT, Mathematics, Statistics, or a related discipline is preferred