VBA Developer

Location: Sydney CBD, New South Wales
Job Type: Permanent
Posted: 28 days ago
Contact: Aparna Sharma
Discipline:
Reference: 188913_1539822275

  • 12 months Fixed Term Contract
  • Location: CBD



Our client a global financial company is currently looking for a VBA Developer to join its IT team on a fixed term contract (initial 12 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
  • Competent understanding of Agile development practices
  • ITIL certification



For further details, contact Aparna on aparna.sharma@peoplebank.com.au