Job Description

Your Opportunity

As part of the Corporate Controller’s Department, the Bank Regulatory Reporting team is responsible for the preparation and filing of all required financial reporting to Bank regulators including the Federal Reserve Board (FRB), the Federal Deposit Insurance Corporation (FDIC) and various state regulators. Due to the company’s growth, and regulators’ heightened interest in regulatory report content, the team is currently undergoing numerous initiatives ranging from automation to new report implementation, while fulfilling its core reporting responsibilities. The team is looking for a new member to take ownership of preparing the FR Y-14M report submitted to the Federal Reserve, the end-to-end process used to generate it, and continued efforts to better automate, improve data quality, and prevent reporting errors. The report focuses on the company’s mortgage and HELOC loan portfolio and presents over 100 data attributes for each individual loan within the portfolio.

Workplace Flexibility Program: We're proud to support our employees in a working approach that allows you to bring your best self to work – whether that’s in the office or remote.

Most Schwabbies have the opportunity to voluntarily work in the office or at home based on their preference, through the remainder of 2021.
When the firm is ready to fully return to the office, employees will have the flexibility of a hybrid work environment, spending some time working remote and some time in the office.
Employees and managers can discuss and decide what works best for them, with additional flexibility available based on their role, business needs, and individual circumstances.

*Subject to change as Schwab is continually evaluating the current environment in order to best care for the safety and well-being of our employees.

What you are good at

Participate in the process of preparing and submitting the FR Y-14M regulatory report. This involves reading and interpreting regulatory instructions, figuring out applicability to

Schwab’s loan portfolio, sourcing vital data, and preparing report schedules with appropriate supporting work papers.
Partner with Alteryx software designers within Bank Regulatory Reporting to run, troubleshoot, update, and test the automated workflow used to aggregate and transform loan data for use in the FR Y-14M report.
Work with data analytics tools used to identify data quality issues and errors, validate data accuracy, and highlight data trends.
Work with the Data Governance Office to write, observe, and update data quality rules for Critical Data Elements identified within the FR Y-14M report.
Collaborate with internal functions and teams, as well as external loan servicers, to develop working relationships to ensure reported data aligns to regulatory instructions, to implement regulatory reporting changes, and to ensure sourcing of appropriate data.
Perform other ad hoc requests and projects including assistance with automation and new report form requirements/ implementation.
Support audit activities for regulatory examinations as well as operational risk and internal audits.

What you have

Bachelor’s degree or higher in Accounting, Finance, Statistics, or related field

4+ years of data analytics and/or general analysis experience
Relevant banking or financial services experience, with a strong understanding of mortgage loan origination and servicing systems and processes
Shown ability to process large quantities of data, summarize key findings, and present effectively to team members
Excellent written, verbal, and interpersonal communication skills
Strong working knowledge of Excel

Other desirable experience:

Experience with MSP, FIS, Jack Henry or other loan origination and servicing software
Experience leading a loan operations team
Experience with Axiom SL/Controllerview software
Advanced proficiency with Microsoft and Adobe applications, including Excel, PowerPoint and Visio
Knowledge of or experience with SQL such as Microsoft Access, Toad or Alteryx
Prior regulatory experience