IT Business Analyst with a focus on Data discovery & mapping in the context of a larger data warehouse initiative.
Responsibilities
Understand data requirements from a content perspective and drive data discovery, sourcing and analytics to support the creation of data flows and models in Oracle (and equivalent services on GCP).
Collaborate with "Data Consumers" in Anti-Financial Crime, Compliance to translate their data needs for transaction monitoring / filtering and similar requirements along typical products held by our Wealth Management clients as well as associated transactions and data attributes (e.g., Shares, Bonds, Funds, Loans, Deposits, FX, Derivatives), client / account static data, etc.
Research in sources such as our Core Banking Platform, across Wealth Management banking data categories such as banking & investment products, transactions, performance, KYC.
Perform data mapping from a high level down to detailed attribute components in the database using SQL queries to retrieve data and provide input to developers.
Work with Business and IT stakeholders to generate data flow diagrams and take ownership end to end to propagate data from source systems up to consuming systems.
Collaborate with other analysts, developers and business subject matter experts across multiple locations to ensure a globally aligned solution where possible.
Support and co-ordinate UAT, defining testing requirements together with the data consumers / users.