Position Overview & Specifications
Position: Excel Developer Location : Newport Beach, CA Duration : Long Term Key responsibilities: Typical end-users have intermediate MS Excel/Excel VBA skills and require assistance adding advanced functionality to their workbooks. You will be located in the Front Office and will respond to advanced MS Excel queries about functionality required during the trading day with a priority on the Trade Floor, although you might be asked to assist other business areas at times, so the ability to prioritize is important. You will need to be responsive and tenacious with a βcan doβ attitude. You will also have longer-term development projects of your own. Required Skills And Experience 10+ years of experience supporting and developing in MS Excel and MS Excel VBA in a financial services Front or Middle Office role. Ability to understand business requirements and translate them Superb problem solving skills Strong interpersonal and communication skills Thriving under pressure Excel front end β Advanced native functions/formulas, array formulas Charting, data visualisation Workbook design and optimisation, calculation trees Pivot tables/listobjects/query tables Names, custom properties Data validation and conditional formatting External data connections (including Oracle) Power Query/M-Language VBA βThe VBA library and language syntax, the Excel object model Debugging, error handling, logging Classes and interfaces Automating other Office applications from MS Excel Developing sophisticated VBA Excel add-ins (.xlam) Ribbon UI, XML Microsoft Scripting Runtime VBA UDFs ADO Userforms Windows API (32/64-bit declarations), conditional compilation Oracle to the level of aggregate functions and joins in SELECT statements. You will not be developing in SQL but must be able to understand the SQL that end-users have written.