Financial Modeling & Analytics Modeler Sr ID - 14256

Position Title

Financial Modeling & Analytics Modeler Sr

Location

Nationwide, MI 48098

Job Summary

JOB SUMMARY

A Senior Financial Assets Modeler is responsible for leading the design, build and operation of compliant quantitative models and producing analytics for current expected credit loss (“CECL”), macroeconomic scenarios (“Stress Testing”), and portfolio (“Loan Concentration”) credit risk. Design and assist with the integration of all applicable inputs, outputs, calculations and analytics required by the Assets and Liabilities Management (“ALM”) and the Allowance for Loan and Lease Losses (“ALLL/CECL”) models. Responsible for working under the direction of the Financial Modeling and Analytics Manager Sr. with a minimum amount of direction.

The scope of model design and operation includes development, enhancement, maintenance, and execution of statistical and cash flow models; design, creation, testing and reporting of macroeconomic scenarios; support for governance, benchmarking, management, validation, and regulatory reporting pertaining to quantitative models; and the development, enhancement, maintenance, and execution of production control procedures within the integrated ALM/CECL/Stress Testing model frameworks.

A Senior Financial Assets Modeler is responsible for maintaining the skills and knowledge relevant to their assigned job responsibilities. In addition, the Modeler promotes and advocates the adoption of appropriate new methodologies for quantitative models and analysis that benefit the Bank. Provides assistance with identifying and designing quantitative solutions to problems as presented by management to further the Bank’s strategic plans. This role may provide coaching or mentoring to other members of the department.

Pay Range

$84,878 - $112,462 - $140,048

Pay Range: Local Minimum Wage - $0.00 - $0.00

Job Responsibilities

JOB RESPONSIBILITIES

  • Performs extensive data analysis in support of financial planning, stress testing and reporting.
  • Develops, tests, and documents internally developed quantitative models and analytics, including complex financial, econometric, and statistical frameworks primarily focused on risk management and financial reporting.
  • Implements, tests, and documents externally developed and/or licensed models.
  • Assists with the integration of models within the FMA Department and amongst other Bank departments to ensure consistency and accuracy across all model outputs.
  • Develops, tests, and documents complex model execution procedures and controls to be run in an audited, production environment.
  • Develops, tests, and documents procedures and controls for executing external, third-party models.
  • Assists with the development and implementation of routine analytics and reports.
  • Utilizes industry standard quantitative software, data science programming languages, database systems, and workstation productivity applications to produce required deliverables.
  • Assists with the creation of management and regulatory reports containing descriptions of the development, testing, validation and execution of quantitative modeling and analytic outputs.
  • Ensures compliance with model governance policies and procedures as an integrated feature of all quantitative modeling and analytic activities.
  • Performs model governance procedures including the execution of required production controls; model, data and procedure version control; and end-user computing policies and guidelines.
  • Assists with the analysis and documentation of Management, Internal Audit, Enterprise Risk Management and Regulatory findings and requirements.
  • Assists with departmental cross-training and knowledge transfer to minimize staffing risk and promote effective communications.

Additional Accountabilities

Job Requirements

Required Qualifications:

  • Education level required: Undergraduate Degree (4 years or equivalent) in Finance, Economics, Statistics, Mathematics or another advanced quantitative field.
  • Minimum experience required: 5 to 8 years of experience with credit risk modeling; including linear modeling frameworks (Ordinary Least Squares, Logistic Regression, Generalized Linear Models, Credit Risk Scorecards, Time Series, Roll Rate, Transition Matrix, etc.).
  • 5 to 8 years of experience with commercial lending data; Commercial Real Estate (“CRE”), Commercial and Industrial (“C&I”), Construction, and Asset-Based Lending (“ABL”).
  • 5 to 8 years of experience working with and analyzing model data preparation requirements (missing values, transformations, re-classifications, etc.).
  • 3 to 5 years of experience with CCAR/DFAST modeling requirements.
  • 3 to 5 years of experience with ALLL/CECL modeling requirements.
  • 3 to 5 years of experience deploying credit loss models into a production ALM environment.
  • 3 to 5 years of experience using third-party macroeconomic forecast data.

Preferred Qualifications

  • Education level preferred: Master's Degree (or Postgraduate equivalent).
  • Direct experience working in model development teams and projects within a CCAR regulated organization.

Job Competencies

  • SAS: experience developing and documenting well-structured, standards-based SAS programs using Enterprise Guide, SAS data analysis and management procedures (Base SAS procedures, SAS macros, SAS functions, program factoring such as “Include”, etc.), PROC SQL, statistical procedures (PROC GLM, PROC GEE, PROC GENMOD, PROC LOGISTIC, PROC ARIMA, etc.).
  • R: experience using similar routines mentioned above with RStudio and standard R, additional R experience developing transition matrix models.
  • Excel: experience developing and documenting well-structured, auditable workbooks, credit risk calculations, pivot tables, and publishable tables, charts, and graphs.
  • SQL: experience developing and running complex data extract and transformation queries using SAS’ PROC SQL.
  • Experience working in a SQL Server database environment.
  • Experience working in a SAS Server environment using Enterprise Guide as the development and execution environment.
  • Experience working with various data file formats including SQL databases, SAS, Excel, and raw format data.
  • Experience working in a networked Microsoft Windows end-user computing environment.
  • Travel requirements: Infrequent, domestic.
  • Physical demands (ADA): The job requires a moderate degree of physical exertion and stamina such as standing, sitting, walking, driving or infrequent lifting.

Flagstar is an Equal Opportunity Employer.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...