Job Summary:-

We are seeking a highly skilled Excel VBA Developer with strong expertise in SQL and Python to design, develop, and maintain desktop applications using the Excel VBA model. The candidate must have deep programming knowledge in Functions, Arrays, Dictionaries, and Collections to build scalable, high-performance automation solutions.

Key Responsibilities:-

- Develop desktop applications using Excel VBA (UserForms, Macros, Event-driven programming)
- Build scalable automation tools and dashboards in Excel
- Leverage Functions, Arrays, Dictionaries, and Collections for effective data processing
- Integrate Excel with SQL databases for reporting and data transformation
- Write optimized SQL queries, stored procedures, and views
- Use Python for data processing, automation, and performance tuning
- Optimize applications for large datasets and speed
- Troubleshoot and enhance existing VBA tools
- Collaborate with stakeholders and document solutions

Required Skills (must have):-

Advanced Excel MANDATORY





- Proficiency in Advanced Excel concepts is mandatory including complex formulas (INDEX/MATCH, XLOOKUP, array formulas), pivot tables, Power Query, data validation, conditional formatting, and named ranges
- Deep understanding of the Excel Object Model — Workbooks, Worksheets, Ranges, Charts, and their event-driven interactions
- Ability to build and audit formula-heavy spreadsheet models with large datasets while maintaining performance and accuracy

Excel VBA Development

- Strong experience developing desktop applications using Excel VBA
- Expertise in Macros, UserForms, Excel Object Model
- Experience applying OOP in VBA using Class Modules: defining properties, methods, events, and interfaces for reusable, maintainable components

SQL

- Strong knowledge in joins, aggregations, stored procedures, optimization

Python

- Experience with Pandas, NumPy, automation scripts

📌 Vba Developer (Hyderabad)
🏢 Orcapod Consulting Services
📍 Hyderabad