JOB DESCRIPTION JOB TITLE: ALM Data Analyst JOB BRIEF (PURPOSE) As part of the Asset & Liability Management group, this position will include working as a part of a development team that is responsible for building and implementing processes in the QRM modeling framework to support centralized forecasting, interest rate risk, funds transfer pricing, capital and liquidity planning and internal stress testing. Responsibilities in this role include supporting the development, implementation, testing and documentation of data processes that will support the use of the QRM framework for various modeling initiatives.
Individuals should have database querying and data transformation expertise and experience dealing with complex and large data sets from multiple sources. Analysts will develop a deep understanding of the QRM framework as well as a basic knowledge of asset/liability management concepts such as liquidity, interest rate risk and/or FTP. This position requires strong analytical skills, attention to detail and collaborative problem-solving. The position has significant interaction with the partners in Finance including the LOB support groups and Planning and Forecasting, as well as other members of Corporate Treasury and Management Reporting and Financial Systems.
ESSENTIAL JOB FUNCTIONS - 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 then develop data transformations, translation tables, parameters, data loads, security, reports, etc. to support projects/modeling
- Work independently with Management Reporting Financial Systems to ensure data requirements or process changes are identified and incorporated into model development schedule
- Able to coordinate interests of 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
- Work to continuously improve production validation and other processes
- Provide modeling support throughout testing and production phases of projects and ongoing work efforts
- Participate simultaneously on multiple work efforts and activities
- Develop and maintain comprehensive control policies and procedures to ensure the integrity of the data process
- Maximize the use of automated technology to achieve the highest level of quality and efficiency
MARGINAL OR PERIPHERAL FUNCTIONS- Maintain an awareness of current market and economic conditions
- Provide insights for process efficiencies, functional realignments and overall continuous improvement
- Participate in strategy discussions around hedging and investing as part of overall balance sheet management
REQUIRED QUALIFICATIONS- Bachelor’s Degree (Finance, Information Technology, Accounting or Related Field)
- 2+ years of analytical experience in Finance, Business or Related Field preferred
- Strong financial and/or accounting acumen
- Database querying and data transformation expertise (i.e., SQL, DB2, SAS)
- Proficiency in using analytical tools (Excel, SQL, Visual Basic, SAS) and in the Microsoft Office Suite (Primarily Excel but proficiency with other Office products a plus)
- Knowledge of KeyBank systems, both legacy product accounting and other supporting or reporting systems (origination, credit decisioning and monitoring, data warehousing) preferred
- Experience dealing with complex and large data sets from multiple sources to support analytical processes
- 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
- Software such as the QRM Framework
COMPETENCIES/SKILLS- Familiarity with using, supporting and upgrading QRM Software (Central Administration, Framework and/or Management Repository)
- Familiarity with Mainframe environment including TSO, SPF, JCL and datasets
- Experience working with financial system reporting environments (i.e.,Workday, IBM TM1 or Cognos, Essbase, QRM, etc.)
- Experience as a systems administrator or business analyst
- Hands on experience with database compilation and analysis
FLSA STATUS:Exempt
KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to engaging a diverse workforce and sustaining an inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
45295BR
