Data Business Analyst - New York, United States - Saxon Global

    Default job background
    Description
    Project Details:

    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 : Market Risk Responsible for all market risk engine calculations work and market data sourcing Murex if no murex NEEDS FRTB
    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 :Yes
    Exclusive to Apex :Yes
    Face to face interview required :Yes
    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