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.