Vba and Excel Developer

Job Summary:

The ideal candidate will have 4-7 years of experience in developing, automating, and optimizing Excel-based solutions using VBA, Power Query, and advanced Excel functions.

Responsibilities:

Develop and enhance Excel-based applications using VBA and Power Query to streamline business processes. • Automate data extraction, transformation, and reporting using Power Query (M language) and advanced Excel functions. • Design, develop, and maintain macros, dashboards, and templates to improve data analysis and reporting efficiency. • Optimize existing VBA scripts for performance, reliability, and scalability. • Work closely with business teams to understand requirements and provide custom Excel solutions. • Integrate Excel models with external data sources (e.g., databases, APIs) for real-time reporting. • Troubleshoot and debug existing Excel/VBA applications to ensure seamless functionality. • Document processes, scripts, and best practices for future reference.