VBA Developer

FR  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

About Brickendon Consulting

Brickendon Consulting is a rapidly growing Transformational Consulting firm that provides solutions to global Banks and asset managers. The company was established in 2010 by 2 partners, one of which is our CEO, Chris Burke, and since we have grown to over 100 people with a target to double in size over the next 1-2 years.

We have five core practices covering Strategy, Data, Risk and Regulation, Quality & Digital and provide solutions via 3 types of services...ADVISE CHANGE DO. Do is our delivery offering. Innovation encompasses everything we do through our R&D and Knowledge Leadership functions. Our consultants both deliver projects and provide new solutions to the challenges our clients face.

Overview of initial assignment

Brickendon Consulting are engaged with several banking institutions to provide large teams delivering Data Governance Change and Macro Remediation through VBA Development. As a result, we are looking to hire Excel Macro Developers to join our French based consulting teams.

There will be infrequent travel for this France-based team, to London, Luxembourg and Poland as part of this long-term programme.

Key Responsibilities

The successful candidate will join our Digital Practice, based in France, as a Consultant. They will work as part of a Brickendon Consulting team to drive Practice thought leadership and deliver Technical Transformation engagements on-site with our Banking clients.

An overview of responsibilities:

  • Work with business users to develop and enhance systems/macro based applications.
  • Developing and maintaining automated solutions to business and operational problems
  • Work to understand the data and database schema held within associated systems and macro based applications to enable to lead data migrations to other systems
  • Develop macros, databases and end-user applications to allow for bulk processing and enhancement of process controls
  • Design and develop VBA application using the Best practices.
  • Participate with team in designing conceptual model and working model and ensure consistency in architecture and design/code practice.
  • Perfom data operations in SQL server.
  • Provide ongoing support and maintenance of existing applications.
  • Design custom UI pages, SQL Server, exporting data to the Microsoft Excel file.
  • Prepare Test Case and perform n-unit testings in coordination with Business owners and be able to test the applications before deploying it in production.
  • Maintain Internal Control standards

Essential Experience

  • 1 - 5 years of experience in VBA excel development
  • Experience in creating Macro/VB Code within MS Excel.
  • Working knowledge of Visual Basic Editor (VBE).
  • Proficient skills in advanced spreadsheets using validation, coding, ruling and macros.
  • Must have strong communication skills and proven ability in understanding business objectives and providing solutions accordingly.
  • Preferably have experience with SQL server.
  • Ability to create scripts, developing functions, adding control flow logic, loops etc.
  • Solid understanding of Object Oriented programming, design and debugging skills.
  • Experience gained working within financial markets and Management Consultancy desirable.
Start date
n.a
From
Brickendon Consulting Limited
Published at
23.01.2018
Project ID:
1489333
Contract type
Freelance
To apply to this project you must log in.
Register