Excel Developer - Newport Beach, United States - Brillius

Brillius

Verified Company

Newport Beach, United States

2 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

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
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.

Job Types:
Full-time, Part-time, Contract

Pay:
$ $75.00 per hour

Schedule: