Excel Developer - ConsultNet

Our client is searching for an MS Excel Rapid Application Developer to support and develop the Office 2016 applications used by Portfolio Managers, Traders and Risk Managers.

Essential Job Functions

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.

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

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.