Bank of America Merrill Lynch provides comprehensive market, industry, product and advisory expertise to more than 140,000 businesses around the globe. With unrivalled insight and access delivered by dedicated relationship teams, we connect clients with the right opportunities in more than 150 countries throughout Europe, the Middle East and Africa, Asia Pacific and the Americas.
Bank of America Merrill Lynch’s Europe, Middle East and Africa (EMEA) footprint comprises of 32 cities across 23 countries on three continents. The company is a long-established participant in the European markets, with a presence since 1922. Currently over 14,000 associates are based in EMEA.
Globally, Bank of America Merrill Lynch serves clients and customers in more than 150 countries and has relationships with 99 percent of the U.S. Fortune 500, nearly 96 percent of the Fortune Global 500 and 33 percent of the FTSE 100.
Today, the company offers an integrated and comprehensive set of products and services across all businesses, serving the needs of individual, corporate, institutional and government clients, by combining the best of local knowledge and international expertise. Bank of America Merrill Lynch has a strategic and measured approach to its international development and is strengthening its business and infrastructure to create sustainable, long-term growth.
Global Banking & Markets includes corporate banking, investment banking and sales trading. The group provides services to middle-market and large corporations, government entities and institutional investors. These services include mergers and acquisition advice, equity and debt capital raising, corporate lending, sales and trading in fixed income, commodities, currency and equities, risk management, research, and liquidity and payments management.
Bank of America Merrill Lynch offers a number of outstanding career opportunities designed to attract and retain all skill levels – a chance for both personal and professional development as well as a salary and benefit package designed to reflect the individual’s contribution.
Job Description
The MIS Consultant role within the MIS portfolio is to support the delivery of projects surrounding a new data warehouse / business intelligence system known internally as Globalisation of Reporting (GoR). The MIS portfolio operates two BI / reporting and data provisioning systems which run on distinct technologies. The first is GBS MIS - a legacy mainframe system (VM / NOMAD) currently being sunset. The second is GoR – a system based on up to date technologies and utilising a Netezza MPP data warehousing appliance, Oracle, Informatica and Microstrategy.
The role focuses on internal, IT led, projects that are continuing the build out of the GoR system and also on supporting business (or other technology partner) focussed projects leveraging the GoR system. Respective examples of these types of projects are the construction of reporting data stores and the delivery of end user reporting. The role therefore encompasses elements of requirements analysis (and negotiation), systems analysis, mentoring, data modelling support, development support and test support. An end to end focus on solution delivery and the ability to liaise with GoR users and other IT team members are therefore key qualities as is banking domain knowledge (treasury / commercial highly desirable). The role is not suitable for candidates who favour a specific area of the systems development lifecycle or who are solely motivated by either IT or business facing roles. Excellent inter-personal skills are essential.
In addition the MIS consultant will need to have a broad background in different technologies and some experience of BI / data warehousing / data modelling / ETL / SQL is essential. Specific experience of the technologies used within the MIS portfolio is desirable although it is recognised that these are niche in places. Thorough training and KT will be provided in these areas. However an appetite to learn new technologies and their application within a commercial treasury banking context will be essential to success in this role. There is an expectation that the successful applicant will become a recognised expert in all aspects of the GoR system and its business context.
Responsibilities
Representing MIS portfolio to business and technology partners.
Management of business and technology partner expectations.
Support end to end solution delivery:
Interpretation / negotiation of requirements into solutions
Creation of functional and reference documentation
Support for the data modelling team in interpreting requirements
Support for developers and testers during coding, unit testing, SIT and UAT.
Ensuring timeliness and quality of deliverables
Ability to write code and design and execute tests if required
Support the project estimation process
Technical mentoring of junior development team members
Contributing to MIS portfolio strategy.
Requirements
Essential
Previous experience in a business / technology facing role.
Demonstrable experience of working on data warehousing and / or BI projects
SQL proficiency
Experience of working on IT projects, end to end
Finance experience
A self starting, results oriented, inquisitive, ‘can do’ approach tempered with the ability to say ‘no’ and work in a team.
Excellent spoken and written English, clear oral communication skills; must be willing and able to express new ideas, concerns and opinions directly to wider team in team meetings via teleconference
Attention to detail and accuracy are essential
Desirable
Previous experience with NOMAD, REXX , COBOL, JCL, VM
Experience with Microstrategy or other reporting technology.
Database / datamart design skills
Informatica experience.
Treasury / commercial banking business knowledge.
