Techolution - Senior VBA Developer

About the Role :

Are you a master of Excel automation and VBA scripting? Do you thrive on turning data chaos into clarity through code? Techolution is looking for a Senior VBA Developer to play a crucial role in transforming our internal and client-facing data operations.

In this role, youll develop advanced Excel-based tools, automate workflows, and integrate systems using VBA, SQL, and occasionally Python.

Your solutions will help drive data-driven decision-making and unlock productivity across teams.

Key Responsibilities :

- Design, develop, and maintain advanced Excel macros and VBA applications to automate complex workflows.

- Build user-friendly dashboards, templates, and forms for business users.

- Create and optimize SQL queries for data extraction, transformation, and loading (ETL) into MS Access and Excel-based systems.

- Maintain data consistency and integrity across platforms.

- Analyze existing manual processes and recommend automation solutions using VBA.

- Identify performance bottlenecks in Excel applications and implement improvements.

- Work with business analysts, developers, and stakeholders to gather requirements and deliver tailored VBA solutions.

- Participate in discussions to scope new initiatives or enhance current tools

- Implement rigorous error-handling, testing frameworks, and debugging methods to ensure reliability.

- Provide ongoing support and maintenance for VBA applications in production.

- Create clear documentation and guides for end-users and internal stakeholders.

- Train business users on using automated Excel/VBA tools when necessary.

Required Qualifications :

- 4+ years of hands-on experience with VBA (Visual Basic for Applications) in Excel

- Strong expertise in Excel automation, advanced formulas, and data visualization

- Proficient in writing and optimizing SQL queries for MS Access or other relational databases

- Solid understanding of database design, data manipulation, and ETL processes

- Experience working with large datasets and optimizing Excel performance

- Strong analytical and problem-solving abilities with keen attention to detail

- Good understanding of Python and its integration with Excel (preferred but not mandatory)

- Excellent communication and interpersonal skills

- Experience working in agile teams or freelance settings, with a proactive and independent approach