BUSINESS OVERVIEW:
The Information Services Group (ISG) is responsible for providing authoritative sources of reference data to our clients across Banking's Institutional Client Group (ICG). ISG implements state of the art technologies and operational processes which promote the collection, storage, analysis, and distribution of product, pricing, account, corporate action, and financial contract data. The ISG organization has a very diverse portfolio of clients and works in partnership with them to deploy solutions to increase their competitiveness, through restructuring business processes, simplifying information access, and providing business intelligence around critical data.
The ISG Pricing team will be responsible for building the Strategic Pricing reference data platform. This involves end to end responsibilities from data modeling, application design, data integration / analysis and working with business partners for implementation. End of day and Intra-Day Pricing data is critical to the bank and must be available and accurate as it reflect Banking's books and record and also Client's Client portfolios.
PURPOSE OF THE ROLE: The Business Analyst will participate in the design and build out of the Strategic Pricing data platform, which is aiming to create a unified framework and aligned operational processes to ensure Client's regulatory obligations are met. The ideal candidate must have an understanding of database design, SQL, and data analytic skillsets in both qualitative and quantitative against large and complex data structure. The candidate needs to be able to work independently.
KEY RESPONSIBILITIES:
- Design and drive execution of accurate and reliable database / application modeling.
- Ability to perform analysis on datasets to determine their quality, coverage, complexity
- Normalize disparate data sets into a common logical model
- Independently query data from multiple relational databases for analysis
- Work directly with Technology, Operations, and Business partners to successfully deliver complex projects leveraging our enterprise reference data platform
- Create BRD/FRD translating business logic into functional requirements
- Communicate business concepts and expected functional behavior to Developers and other stakeholders
- Create comprehensive use cases for testing
- Provide leadership and guidance to the local teams on technical challenges and client communication
- Project management, implementation and testing plans
CANDIDATE QUALIFICATIONS:
- Database design and modeling knowledge, understanding of data integrity and normalization
- SQL knowledge with hands on experience, ability to run analysis and complex SQLs against large sets of data is a must. Preferably experience with Oracle DBMS.
- 4 year Bachelor's degree or higher in one of the science majors is ideal
- Strong analytical, problem solving and communication skills
- Experience managing the full project cycle for complex business deliverables - including translating client logic into functional requirements, writing FRDs/BRDs, working with the technology teams to ensure accurate implementation, and partner with business for user acceptance testing and production go-live.
- Experience with Pricing and/or securities reference data background in capital markets is a plus
- Technically proficient in Microsoft Office Suite
- Capable of managing multiple tasks under tight deadlines