Treasury Analyst - Investment Bank

In this role, you will :

- Strong SQL/PL-SQL Skills

- Strong knowledge on UAT / ETL/ Database/ User Interface Testing

- Excellent data analytics skills including experience with SQL Server, Oracle or similar relational database platforms.

- Complete root cause analysis of issues reported by Downstream systems (QRM ) data or data staged for QRM

- Perform Data profiling, data quality analysis and reporting of data quality trends and metrics

- Good communication and interpersonal skills

- Good Automation skills in any language will be an advantage.

- Ability to manage multiple concurrent projects Detail oriented, accurate, organized, excellent judgment

- Analyze systems of record data for information relevant to model assumptions and suggesting changes justified by data

- Significant experience reporting and analysis of large datasets including data mining and profiling.

- Work with technology partners on ensuring Downstream QRM requirements are met at all times and that we are informed of any potential data source issues/changes that may impact ALM.

- Analyze data to support business objectives including research/reporting on elements not necessarily used by QRM - e.g., new vs. previously existing loan reporting, new volume characteristics for comparison to model assumptions, etc.

Essential Qualifications :

- Experience in analyzing/designing ETL workflows in a multi-system environment will be an advantage.

- Experience in Finance/Accounting/Treasury/Risk functions will be an advantage

- Good understanding of Finance/Treasury/Risk domain will be an advantage

- Partner with QRM Operations and Balance Sheet Analysis functions within Corporate ALM to meet objectives

- Participate and advocate for QRM requirements in system conversions, including the incorporation of new/replacement data sources.

- GL Reconciliation (source system, manual entries, missing data)

- Support Compliance with evolving internal data integrity standards and reporting requirements as well as regulatory expectations (e.g., the Basel Committee on Banking Supervision (BCBS) principals for risk data aggregation and reporting)

Required Qualifications : 5+ years of Treasury experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education.