Key Responsibilities:
- Develop and enhance tools and applications using VBA, VBScript, and Excel formulas.
- Attend daily Scrum meetings and provide regular updates on task status and blockers.
- Participate in grooming sessions and contribute to requirement clarifications and estimations.
- Troubleshoot and resolve performance issues in existing VBA applications and suggest optimizations.
- Write and maintain SQL queries to extract or update data as part of automated solutions.
- Collaborate with business users to gather and validate requirements.
- Maintain documentation for scripts, workflows, and user guides.
Mandatory Skills:
- Strong knowledge of VBA and VBScript
- Advanced Excel formulas and functions
- Proficient in SQL (querying, joins, and basic database interaction)
Desirable Skills (Nice to Have):
- Familiarity with Agile/Scrum methodologies
- Understanding of Excel-based dashboards
- Experience integrating Excel/VBA with databases or web APIs
Soft Skills:
- Excellent problem-solving and debugging abilities
- Strong verbal and written communication
- Attention to detail and ability to work independently
- Comfortable working in a fast-paced, Agile environment
Let me know if you'd like:
- A custom resume template tailored for this role
- Sample VBA-focused interview questions
- A version of the JD for junior or automation-focused VBA developers
Skills Required
Excel, Vba, Sql, Scrum, Web Apis