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