VBA Developer

Location: Sydney CBD, New South Wales
Job Type: Contract
Posted: 20 days ago
Contact: Aparna Sharma
Discipline:
Reference: 198462_1569975929

Our client a financial company is currently looking for a VBA Developer to join its IT team on a contract (initial 3 months). Woking closely with business stakeholders, you will be responsible for developing Microsoft based applications using Excel User Interface. You will also be responsible for documenting functional and technical requirements.

Responsibilities will include:

  • Analysing, supporting and developing Microsoft based applications utilising Excel User Interface (with extensive knowledge of writing formulas, using functions, conditional formatting etc.)
  • Writing macros (VBA)
  • Writing complex Stored Procedures / Queries / Functions using SQL as back -end database
  • Business process modelling where you will document and model AS-IS and TO BE business processes
  • Business problem identification, analysis and resolution as required
  • Identifying, documenting and engaging peers and Global IT teams where required, in providing solution options and recommendations to business requirements
  • Documenting and executing test plans and test scripts, and where required facilitating business testing



Essential Skills and Experience

  • Degree in business or technical discipline
  • Advanced Excel UI skills, writing macros (in Visual Basic for Applications) and handling databases (SQL, Access or equivalent)
  • Advanced knowledge of Microsoft Office Applications (Excel, Word, Outlook)
  • Exposure to SharePoint / InfoPath or other Electronic workflow solution will be highly regarded
  • Advanced knowledge of IT concepts and frameworks

For more information, contact Aparna on aparna.sharma@peoplebank.com.au