Senior Excel VBA Developer
Kpmg India Services LlpJob Description
Senior Excel VBA Developer
Job Summary
We are seeking an experienced Senior Excel VBA Developer with strong expertise in Excel, VBA, Macros, and SQL, along with domain knowledge in handling financial data and basic accounting concepts. The role involves close collaboration with global teams and clients to analyze requirements, design data‑driven solutions, build proofs of concept, and ensure high‑quality project delivery following SDLC best practices.
Skills & Technical Expertise
Required Skills
- Expert‑level proficiency in Microsoft Excel, including advanced formulas, pivot tables, and automation
- Expert‑level knowledge of VBA and Macros
- Expert‑level understanding of SQL concepts and query optimization
- Strong understanding of relational databases
- In‑depth knowledge of SDLC concepts
- Domain knowledge in handling financial data such as revenue, expenses, P&L, balance sheets, forecasts, or MIS reporting
- Basic accounting knowledge, including understanding of debits/credits, financial statements, and reconciliation concepts
Additional Skills (Good to Have)
- Elementary to working knowledge of Alteryx, Power BI, or similar BI tools
- Basic exposure to Power BI is an added advantage
Responsibilities:
• Understand high level requirements from Global team and work closely with product owners to plan and budget projects accordingly
• Manage the assignment of specific responsibilities relating to project by coordinating with peers within the team for relevant roles and job functions
• Interact with client, do requirement analysis, propose solution, estimation, listing down assumptions and risks
• Create working proof of concept for projects
• Must be good in reviewing client/peer build data models and evaluate the pros and cons
• Basic exposure to Power BI or similar BI tool will be helpful
• Good understanding in relational databases
• Handle large database of in GBs with ability to write/edit/modify Alteryx Workflows and build reports using Alteryx Reporting
• Analyze complex data sets and convert them into the information which drives business decisions
• Express strong voice for data integrity and reporting quality utilizing best practices and industry standards
• Experience writing technical documentation and user guides; providing end-user training and support
• Driven and accountable self-starter, with ability to identify and communicate priorities, and work independently in a fast-paced industry in a rapidly growing team
Qualifications
Education / professional qualifications
BE / BTech / MCA or Equivalent
Experience Level
Senior LevelJob role
Job requirements
About company
Similar jobs you can apply for
Software / Web DeveloperMarathi Native Speaker – AI Speech Recording Project (Remote)
Arctic EnginesUrdu Native Speaker – AI Speech Recording Project (Remote)
Arctic EnginesOdia Native Speaker – AI Speech Recording Project (Remote)
Arctic Engines