Data & Business Support Analyst

This position is responsible for supporting the Capital Markets business unit’s systems and databases along with its data needs by providing requirements gathering and analysis, quality assurance and data analysis services. This role may include creation of test plans, execution of tests, logging of defects, identification and resolution management of data integrity issues and communication with team members to ensure business requirements are satisfied. This role will also participate in Capital Markets sales and liquidity analysis (analyzing and reporting asset portfolio and the various funding programs to make informed business decisions) and portfolio insurance process. Data Mining Analysis and Reporting Perform complex data analysis to support various initiatives within the team. Document and present data analysis and data mining results to the manager Keep current with data mining methodologies and recommends use of them where appropriate Support building and maintaining various reporting templates and models. Quality Assurance and Testing Identify and document the test cases, steps to execute test cases, required data, and expected results required to validate that the functional and non-functional requirements have been met Participate in test automation and test strategy activities Execute tests as planned, and record actual results, to provide traceable documentation Compare actual results to expected results, and analyze any variances to identify defects Create problem logs and tracks defects. Manage the defects through resolution by working with appropriate IT and business resources. Summarize test results to provide documentation for IT and Business partners Builds and enhance regression tests for supported systems Triage issues, confirm and troubleshoot production defects Conducts post-implementation confirmation testing Portfolio Insurance Reporting Prepare scheduled reports for review by Capital Markets management Process insurance premium payment based on the established procedures Work with internal counterparties to collect and analyze various reports to ensure the information is precise and accurate Identify eligible mortgages to be submitted for portfolio insurance program Assist in preparing portfolio insurance submissions and co-ordinate communication with the insurers Liquidity and Sales Planning Analyze eligibility and recommend portfolio for sale transactions based on the asset liquidity. Prepare and distribute data tapes timely and accurately. Work with internal counterparties to collect and analyze data to ensure the information is precise and accurate. Support bulk sale submissions. Prepare scheduled reports for review by Capital Markets management Support audit process Produce and deliver post settlement documents Miscellaneous regular/ad-hoc Tasks Perform ad‐hoc tasks/analysis upon the management's requests timely and accurately. Prepare scheduled reports. Create and maintain procedure documents. Provide documents and samples for audit Process contractual repurchase Run and save query results from various systems and databases