Should be able to analyse the business requirement & convert it into automation
Candidate should be able to independently develop, maintain & support existing Excel VBA applications this would include the Financial Models created by the team.
Should have experience to integrate database like MS Access/SQL Server/MySQL with VBA. Some experience in Web Scraping tools would be preferred
Primary Skills
Should have experience in VBA programming
Should be able to analyse the business requirement & convert it into automation
Candidate should be able to independently develop, maintain & support existing Excel VBA applications this would include the Financial Models created by the team.
Should have experience to integrate database like MS Access/SQL Server/MySQL with VBA. Some experience in Web Scraping tools would be preferred
Hands-on experience in creating new dashboards & manage the existing excel based financial models
Candidate should be aware of Excel terms such as Pivot Table, Complex Formulas (Sum product, Index Match etc), charts & name manager etc.
Secondary Skills
Strong & quick in implementing programming algorithm\'s
Preferable candidate should have fundamental knowledge about Power BI & should be able to create simple Power BI dashboards independently