Project Details:
2-3 times a week onsite in NYC
Supporting Market Risk (MUR, MRK, MKT)
Responsible for all market risk engine calculations work and market data sourcing
FRTB project – Fundamental Review of Trade Booking – all banks must adhere to FRTB regulations to make sure financial risk is calculated accurately and with certain data quality and governance standards. This project is to create documents to notate and streamline processes and ensure data quality to stay in line with Federal regulatory guidelines.
Perform data lineage to ensure data coming from upstream systems is flowing and documented correctly, data coming in and going out needs to be quality checked
How is data captured, what are the controls put in place if there is a failure
Data going into vendor product – what are the touchpoints with BNY systems, what are the CDEs, document data quality and perform data quality checks
Prepare data requirement document
Identify Critical Data Elements (CDEs), data maps, workflows
Data monitoring, controls, remediation
Tools: Collibra (Data Lineage), JIRA, Confluence, Visio diagrams
Role Summary:
Working with business users and technology team to understand how data is flowing today, what are the controls we have, how the business is in alignment with controls, and make sure data initiatives are added to backlog of work.
Join sprint meetings with business and technology team
Discuss data quality – document what is missing, what needs to be added, based on ongoing conversations with business stakeholders, primarily risk and compliance team
Make sure data work is slated for sprints
Liaise to data team what is being asked, part of development lifecycle
BA will have database access, ability to view tables
Perform data analysis and reporting
Must understand relational database functionality (they use SQL Server)
Mid-level SQL experience – ability to write moderately complex queries (joins)
Querying the database and performing data analysis –
Required Experience:
Preferred Experience:
Key Stakeholders: risk managers, modeler and market risk, counterparty risk management
Soft Skills: approachable, team oriented, good communication skills
Deliverables: Data lineage, data mapping, critical data elements
Framework: Agile Scrum
Tools/Technology: Collibra – Data Lineage tool, JIRA, Confluence, Visio, SQL Server
Industry/Domain Knowledge: Market risk experience is required, FRTB highly preferred