Loan Transformation Data Analyst

Loan Transformation Data Analyst 12 month+ possible extension/conversionAll individuals working on-site must be fully vaccinated against COVID-19*** NO C2C***

Loans Transformation Data Analyst

Function background / context:The Institutional Credit Management (ICM) team is a critical component of First Line of Defense for wholesale lending and counterparty credit risk. ICM partners with businesses wide to ensure we have best-in-class risk and control capabilities. ICM also plays a key role in Transformation efforts by helping to drive a wide focus on wholesale credit risk management. Through ongoing investment in processes, controls, systems, and governance, ICM continues to further embed consistency and best practices across, driving closer alignment between our business and regulatory goals.

ICM Lending Transformation is looking for an experienced Data Analyst, who is proactive, independent, and comfortable with identifying and resolving blockers. Role includes creating and maintaining centralized SharePoint site and associated content for the overall Data Remediation Transformation Program. Develop and maintain automated workflow tools to facilitate regulatory remediation efforts. Support BAU and analytics processes.

You will interact and work closely with multiple areas across the organization, including the broader Institutional Credit Management (ICM) function and the business lines supported by ICM, as we enhance our processes and technology to better deliver for our clients. You will provide data management support to the Transformation teams initiatives.

Responsibilities:• Create and maintain centralized SharePoint site and associated content for overall Data Remediation Transformation Program• Develop and maintain automated workflow tools to facilitate regulatory remediation efforts• Support BAU reporting & analytics processes• Support transformation and/or risk and control agenda/priorities for the larger team• Analysis and report on remediation progress/ metrics to key stakeholders• Design and implement governance processes for escalation where required• Partners with cross function peers to create, administer, track, and eventually close projects• Appropriately assesses risk when decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency, as well as effectively supervising the activity of others and creating accountability with those who fail to maintain these standards• Integrates subject matter and industry expertise• Proactively identifies emerging risks and assists the control team with resolving control gaps and issues and helps to create corrective action plans, inclusive of root cause identification and resolution• Actively focus on process improvement, creating efficiencies, and ensuring proactive approach and partnership to audit management• Ensure timely project tracking, status reporting and escalation• Develop and maintain RAID logs and general issue management, with appropriate escalation• Establish strong relationships with stakeholders across at all levels, businesses, and locations

Qualifications:• 10+ years of experience in finance/ project management• Experience and proficiency building data pipelines and performing analytics using KNIME (or similar software)• Experience creating team SharePoint sites and maintaining content to make information and documents easily accessible• Proficiency with Visual Basic for Applications (VBA) for Microsoft Office• Proficiency with SQL and relational database management systems• Strong proficiency with Microsoft Excel• Significant experience building end-user tools with Microsoft Access*Additional experience and knowledge for Internal Candidate• Experience in using Lynx UI, Optima Cognos Reporting Tool, Risk (Facility Management, Collateral) and extracting data from Data Globe (especially data schemas: DGSTREAM, DGFU, DGREF & DGLOBE)• Good understanding on Loan data hierarchy (Request/Credit Agreement/Facility/GFRN) in Lynx.