IT VBA Consultant

Support several end user computing applications (the EUCAs) i.e. VBA and Python applications macros and PowerBI dashboards for the different divisions;

Maintain customer relationships within different divisions manage the change process and ensure smooth communication;

Act as a change agent to help facilitate effective deployments/modifications tnew and current industry practices;

Identify risks and liaise on issues related to changes;

Work with the ESMs subject matter experts to gather business requirements and any other relevant input.

Tasks:

• Develop new required features in the VBA / Python applications/macros and PowerBI dashboards;
• Follow up on deliverables related to these applications with internal and external parties;
• Prepare documents to support internal decision making testing or training material;
• Develop and execute an internal communication plan for changes and new features to the business;
• Perform testing change management documentation and support the deployment of the technology and hand over to production support;
• Ensure all material is stored on the ESMs SharePoint environment for audit purposes;
• Support other division related tasks as applicable such as organizing and running meetings;
• Develop agendas prepare minutes follow up on open actions identifying risk and issues with appropriate mitigating actions;
• Participate in handover of VBA Java and SQL applications and their corresponding documentation;
• Participate in handover of development and change management processes;
• Provide handover protocol tdocument the completeness of handover tasks.

DELIVERABLES

• The Consultant will be responsible for providing the following deliverables tthe ESM (the Deliverables):
• Produce files in MS Office formats including the project VBA code if applicable;
• Complete reliable functional and technical documentation about the implemented functionality;
• Perform test management;
• Create and execute relevant test cases demonstrating the expected behavior in terms of requirements fulfillment and software quality;
• Create training material conduct trainings if necessary and other change management material as needed to support the change management process;
• Manage internal and external communication

DESIRED CONSULTANT PROFILE

• The Consultant will have the following profile:
• Technical skills:
• Bachelors degree in information technology data science or equivalent degree/experience
• 7 years of direct experience with similar and relevant IT projects:
• - Developer - Senior Consultant: 7-10 years
• - Developer - Expert Consultant: at least 10 years
• Development and rollout experience with VBA and MS Office Macros (Access & Excel).
• Good understanding of modern IT architecture.
• Good understanding of and experience with: SQL XML XSLT.
• Good project management skills: Ability to manage multiple tasks under competing deadlines and shifting priorities
• Experience in providing reporting and other communications at a senior management level
• Ability to document clear and complete business requirements
• Experience with Microsoft Azure Desired
• Professional experience with PowerBI and/or Microsoft Fabric Desired
• Experience in the financial services industry Desired
• Experience with the following financial IT systems: SWIFT Murex Bloomberg Desired

Soft-skills:

• Proven customer-oriented change management communication skills Mandatory
• Excellent communication and presentation skills Mandatory
• Excellent organizational skills Mandatory
• Excellent English communication skills both oral and written Mandatory