Job Role: Excel Developer

Job Location: CA (HYBRID)

Job Type: Full-Time

Required Skill Sets/Qualifications:

Note:

• We don t accept third parties or employers
• Need Mobile Number and Email for consideration
• Overall 8 years of experience must

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.

Desirable Skills and Experience

• Bloomberg and Bloomberg Excel Tools
• Office 365, version compatibility and 32/64 bit considerations
• Some Python and or C# .Net
• Experience using GitLab source control
• Windows 10, including basic knowledge of infrastructure to assist in trouble-shooting
• IT Help Desk experience