Flag job

Report

VBA Developer

Location

Chennai, Tamil Nadu, India

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

Business Integrity Services

Website: businessintegrityservices.com
Job details:

Job Title: VBA Macro Developer

Location: Chennai, India

Experience: 4-5 Years

Shift: Mid Shift

Employment Type: Full-Time


Job Summary:

We are seeking a Senior Excel VBA Macro Developer with deep expertise in Excel automation, VBA Selenium web automation (mandatory), and modernization of legacy VBA solutions into Python. This role requires strong ownership of MIS reporting, Power BI dashboard development, and advanced Power Query transformations.


Key Responsibilities:

  • Architect, develop, and maintain advanced Excel VBA macro solutions for large-scale automation
  • Build robust web automation frameworks using VBA Selenium (Must-Have)
  • Lead migration of VBA-based automation to Python, using VS Code for development
  • Design, publish, and maintain Power BI dashboards with optimized data models
  • Develop and manage Power Query transformations and complex formulas
  • Own end-to-end MIS reporting, including daily, weekly, and monthly Excel reports
  • Optimize Excel performance using advanced formulas, pivots, and automation best practices
  • Debug, refactor, and enhance legacy VBA codebases for stability and scalability
  • Collaborate with business stakeholders to convert requirements into automated solutions
  • Ensure documentation, version control, and maintainability of all deliverables


Required Skills & Qualifications:

  • Excel Advanced: Advanced formulas, Pivot Tables, Power Query, performance optimization
  • VBA Macros: Expert-level Excel VBA development and automation
  • VBA Selenium Web Automation (Mandatory)
  • Python: Automation scripting and VBA-to-Python migration
  • VS Code: Python development, debugging, and project structuring
  • Power BI: Dashboard development, maintenance, and reporting lifecycle
  • Power Query (M Language): Formula creation and complex transformations
  • MIS & Excel Report Handling: End-to-end ownership of reporting workflows


Education:

  • Bachelor’s degree in computer science, IT, Engineering, or equivalent experience
Click on Apply to know more.

Skills

Python
Power BI
data models
end-to-end
Selenium
version control
VBA