Senior Lead Treasury Analyst, AML Data & Analytics
About The Position
Reporting to the Senior Manager, ALM Data & Analytics, the candidate is responsible for the data management and analysis surrounding Asset Liability Management (ALM). The successful candidate should have database querying and data transformation expertise and experience dealing with complex and large data sets from multiple sources. The candidate will develop deep understanding of the ALM framework and should have working knowledge of ALM concepts such as liquidity, interest rate risk (IRR) and/or funds transfer pricing (FTP). This role will provide the analyst with comprehensive exposure to the different functions of interest rate risk such as scenario analysis and modeling. This position requires strong analytical skills, attention to detail and strong collaboration and problem-solving across Finance, various Lines of Business (LOB), Finance Division’s Financial Planning and Analysis (FP&A) Finance Enablement, and the Quantitative Modeling and Advanced Analytics (QMAA) team. This role will also heavily interact with the ALM production and Methodologies and Models teams.
Requirements
- Bachelor's Degree (Finance, Information Technology, Accounting or related field)
- Familiarity with using, supporting and upgrading ALM software (e.g., QRM, Empyrean)
- Experience working with financial reporting systems (e.g., Workday, Essbase)
- Curiosity-driven work ethic
- Database querying and data transformation expertise (e.g., SQL, python, DB2, SAS)
- Proficiency in using analytical tools (Python, SQL, SAS, Visual Basic) and Microsoft Office Suite products
- Experience dealing with complex and large data sets from multiple sources to support analytical processes
- Experience in basic Treasury, ALM or interest rate risk functions
- Strong financial and/or accounting acumen
- Interest, willingness and ability to assimilate information quickly and succinctly
- Strong verbal and written communication skills coupled with the ability to work and communicate with personnel at all levels in the corporation
- Ability to understand and interpret modeling requests/needs, and respond to questions with clear and effective answers, and give cohesive presentations
- Proven team player, willing to assist others as needed to ensure that group deadlines are met, and quality standards are achieved
- Hands-on experience with database compilation and analysis
Nice To Haves
- 3+ years of analytical experience in Finance, Business or related field preferred
Responsibilities
- Assist in maintaining a clear ALM data inventory (sources, lineage, transformations, owners, controls) for core products and instruments (loans, deposits, securities, derivatives, FTP curves, behavioral attributes)
- Assist in defining and monitoring data quality rules (completeness, validity, timeliness, reconciliation tolerances) and ensure breaks are tracked and timely remediated
- Help build and implement processes in ALM framework to support centralized forecasting, IRR, FTP, capital and liquidity planning, and internal stress testing
- Assist and support the development, implementation, testing and documentation of data processes to support the various modeling initiatives of Corporate Treasury
- Assist in producing accurate ALM results and risk reporting that is based on accurate, controlled, well-governed data and analyses that reliably measure and explain balance sheet risk (IRR/IRRBB, NII/EVE sensitivity, optionality/behavioral assumptions) and support risk governance and regulatory expectations
- Support and assist the framework and comprehensive process to identify, measure, monitor, and control IRR with strong governance and controls
- Execute monthly data load process and reconciliations
- Maintain exception logs and issue remediation status
- Develop understanding of foundational financial systems and work to develop interfaces to the QRM framework
- Partner with multiple developers to understand modeling data requirements and develop data transformations, translation tables, parameters, data loads, security, reports, etc. to support projects/modeling
- Work independently with Finance Enablement to ensure data requirements or process changes are identified and incorporated into model development schedule
- Coordinate with multiple stakeholders with diverse backgrounds, perspectives and priorities
- Perform data and process validation during testing and production phases of projects and ongoing work efforts
- Review and process data throughout the month to help ensure that modeling requirements are satisfied
- Continuously improve production validation and other processes
- Provide modeling support throughout testing and production phases of projects and ongoing work efforts
- Participate simultaneously in multiple work efforts and activities
- Develop and maintain comprehensive control policies and procedures to ensure the integrity of the data process
- Leverage automated technology to achieve the highest level of quality and efficiency
- Maintain an awareness of current market and economic conditions
- Provide insights into process efficiencies, functional realignments and overall continuous improvement
- Participate in strategy discussions around hedging and investing as part of overall balance sheet management
Benefits
- Please click here for a list of benefits for which this position is eligible.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Number of Employees
5,001-10,000 employees
