At Key, employee and candidate health is a top priority. Due to the ongoing spread of COVID-19, most interviews are being conducted virtually. Our talent acquisition team is diligently working to provide you the support you need throughout our hiring process. Learn more.

Asset Liability Management Data Analyst in Cleveland, OH at KeyBank

Date Posted: 1/5/2021

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    127 Public Square
    Cleveland, OH
  • Date Posted:
    1/5/2021

Job Description

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

Not Ready to Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.

At Key, we’re committed to diversity and inclusion in all we do. Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by email.