Data Business Analyst

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 :

• 7+ years of Technical Business / Data Analysis
• Experience identifying and documenting Data Quality, Data Lineage, CDEs
• Experience working on an Agile team
• JIRA for requirements documentation, Agile planning / tracking
• Mid-level SQL, ability to write moderately complex SQL queries
• Understanding of relational databases, SQL Server preferred
• Market risk experience, specific FRTB knowledge preferred

Preferred Experience :

• Collibra data lineage tool
• FRTB 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

Required Skills : Jira

Background Check : Yes

Drug Screen : Yes

Notes :

Selling points for candidate :

Project Verification Info : "The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party.

Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA : Blanket Approval Received Client Letter : Will Not Provide"

Candidate must be your W2 Employee : No

Exclusive to Apex : Yes

Face to face interview required : No

Candidate must be local : Yes

Candidate must be authorized to work without sponsorship : Yes

Interview times set : : No

Type of project : Architecture / Design

Master Job Title : Bus. Analyst : Technical

Branch Code : New York City