Develop Microsoft Access Databases, including tables, queries, forms and reports, using standard IT processes, with data normalization and referential integrity
Use Visual Basic in Microsoft Applications, including Excel, Access, Word and PowerPoint
Use Advanced Excel capabilities, complex formulas and graphing to streamline business processes
Develop custom solutions using one or more programming languages: Visual Basic, SQL
Develop test plans and software documentation to support new releases and code modifications
Confer with client and various other teams to gain understanding of needs
Participate in code reviews to ensure best practices and established standards are in use
Ability to develop custom solutions using one or more programming languages: Visual Basic, SQL
Training supporting other teams with developmental activities
TECHNICAL REQUIREMENTS
Knowledge of list object-tables, query tables, array formulas, data connections workbook
housekeeping skills in excel
Experience of re-factorization, class module support, and ribbon manipulation in VBA
Expertise in SQL and ability to troubleshoot are a must
Experience in Bloomberg Excel with knowledge of Bloomberg Query Language
5 plus years of wide support experience
Excel Financial Services Support experience
Advanced Excel skills and knowledge of complex formulas
Experience of Object-oriented programming
Experience with complex dashboards, run time reports COM Add-ins
Expert knowledge of Excel Object Model
Experience with Excel macros, which requires Visual Basic skills
Must possess problem solving skills and be proactive in researching solutions