NextRaiseNextRaiseFind jobs
Sign inSign up free
Jobs / Data & Analytics Consultant in United States of America
9 days ago
Apply with autofill
Apply with autofill
Wells Fargo·BFSI·9 days ago
9 days ago

Senior Mortgage Valuation and Cash Flow Analytics Consultant

CHARLOTTE, United States of AmericaFull-timeHybridMid · 5-8 yearsData & Analytics Consultant

Sign up free to see how well your resume matches this role.

Boost your chances at Wells Fargo

How you compare FREE

?
Your scoreYour score: not yet known
→
71
Top 10%Top 10%: 71 out of 100

Top 10% of NextRaise users matched against Data & Analytics Consultant roles in United States.

Must-have skills for this role

  • risk analytics

PDF or DOCX · no account needed

Apply faster with autofill FREEThe NextRaise extension autofills your application in one click.careers.example.com/applyAutofillingFull namePriya SharmaEmailpriya.sharma@example.comPhone+49 30 1234567LocationBerlGet the extension

What you'll do

  • Analyze mortgage portfolio performance, valuation, cash flows, and profitability across mortgage-related assets and portfolios while helping develop future Home Equity analytics and securitization capabilities.
  • Evaluate mortgage pricing and product economics, including note rate versus par rate and price, points and lender credits, fixed-rate versus adjustable-rate mortgages, and 30, 45, and 60-day lock terms.
  • Model origination behavior using pull-through assumptions that estimate the probability of locked loan funds and assess fallout drivers such as rate movements relative to the lock rate and borrower characteristics.
  • Decompose expected profitability into revenue components, including Net Interest Margin and fee income, and cost components, including fulfillment, hedge, capital, and liquidity costs.
  • Produce and interpret core profitability metrics such as Net Present Value (NPV), Return on Assets, Return on Equity, and capital utilization and allocation measures.
  • Partner with Mortgage Capital Markets and Secondary Marketing to evaluate pipeline strategies, mandatory versus best-efforts delivery, and best execution across agency, whole-loan, and securitization alternatives.
  • Assess the margin impact of rate volatility and optimize execution selection based on pricing, market conditions, and portfolio objectives.
  • Perform scenario and sensitivity analysis across interest-rate shocks, CPR, pull-through, and spread assumptions, including the interaction between pricing, volume, fallout, and margin.
  • Develop forecasts, reporting, dashboards, and analytical insights for senior leadership, translating complex findings into clear business recommendations.
  • Partner across Finance, Risk, Treasury, Mortgage Capital Markets, and Business teams on portfolio optimization, profitability enhancement, and other strategic initiatives

What they're looking for

  • 4+ years of Risk Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Nice to have

  • Experience supporting financial or portfolio analytics within Mortgage Finance, Home Equity, Mortgage Capital Markets, Mortgage Banking, Secondary Marketing, mortgage securitization, or a related financial services environment.
  • Experience supporting securitization, structured finance, capital markets, or secondary marketing initiatives, including cash flow analysis, collateral analytics, valuation, and execution economics.
  • Working knowledge of mortgage and home equity products, pricing, valuation, and portfolio performance, including experience with Mortgage-Backed Securities (MBS), Residential Mortgage-Backed Securities (RMBS), home equity loans and HELOCs, securitization structures, and secondary market execution.
  • Experience supporting cash flow analytics, portfolio analytics, profitability analysis, forecasting, scenario analysis, business performance measurement, and mortgage-related modeling to support strategic decision-making
  • Familiarity with pull-through, fallout, prepayment, pipeline, and loan-level performance drivers, with the ability to translate assumptions into profitability, capital utilization, valuation impacts, and broader business outcomes.
  • Ability to assist with evaluating mortgage portfolios, identify profitability and risk drivers, assess valuation impacts, and deliver actionable insights and recommendations to senior leaders and business partners.
  • Experience supporting the development, maintenance, and validation of analytical models, dashboards, and reporting solutions that support mortgage valuation, profitability measurement, capital markets activities, portfolio monitoring, forecasting, and executive decision-making.
  • Proficiency with one or more analytical and reporting tools, such as SQL, Python, SAS, Power BI, or Tableau, to extract, analyze, validate, visualize, and communicate mortgage and financial data.

Summarised by NextRaise from the employer’s description, which follows in full below.

Full description from employer

About this role:

Wells Fargo is seeking a Senior Risk Analytics Consultant (Mortgage Valuation and Cash Flow Analytics Consultant) professional to join the Consumer Banking and Lending Finance team. The role supports evaluation of mortgage portfolio performance, cash flows, valuation, profitability, capital usage, and business outcomes. Positioned at the intersection of mortgage finance, capital markets, and business performance analytics, this individual will assist in converting complex analysis into actionable insights that support portfolio value, pricing, profitability, capital allocation, and strategic decision-making.

This is not a pure model-development role. The successful candidate will combine strong mortgage product and secondary-market knowledge with the ability to apply cash flow, behavior, valuation, and profitability analytics to business and risk decisions across mortgage originations and portfolios.

Learn more about the career areas and business divisions at wellsfargojobs.com


In this role, you will:

  • Analyze mortgage portfolio performance, valuation, cash flows, and profitability across mortgage-related assets and portfolios while helping develop future Home Equity analytics and securitization capabilities.

  • Evaluate mortgage pricing and product economics, including note rate versus par rate and price, points and lender credits, fixed-rate versus adjustable-rate mortgages, and 30, 45, and 60-day lock terms.

  • Model origination behavior using pull-through assumptions that estimate the probability of locked loan funds and assess fallout drivers such as rate movements relative to the lock rate and borrower characteristics.

  • Decompose expected profitability into revenue components, including Net Interest Margin and fee income, and cost components, including fulfillment, hedge, capital, and liquidity costs.

  • Produce and interpret core profitability metrics such as Net Present Value (NPV), Return on Assets, Return on Equity, and capital utilization and allocation measures.

  • Partner with Mortgage Capital Markets and Secondary Marketing to evaluate pipeline strategies, mandatory versus best-efforts delivery, and best execution across agency, whole-loan, and securitization alternatives.

  • Assess the margin impact of rate volatility and optimize execution selection based on pricing, market conditions, and portfolio objectives.

  • Perform scenario and sensitivity analysis across interest-rate shocks, CPR, pull-through, and spread assumptions, including the interaction between pricing, volume, fallout, and margin.

  • Develop forecasts, reporting, dashboards, and analytical insights for senior leadership, translating complex findings into clear business recommendations.

  • Partner across Finance, Risk, Treasury, Mortgage Capital Markets, and Business teams on portfolio optimization, profitability enhancement, and other strategic initiatives


Required Qualifications:

  • 4+ years of Risk Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education


Desired Qualifications:

  • Experience supporting financial or portfolio analytics within Mortgage Finance, Home Equity, Mortgage Capital Markets, Mortgage Banking, Secondary Marketing, mortgage securitization, or a related financial services environment.

  • Experience supporting securitization, structured finance, capital markets, or secondary marketing initiatives, including cash flow analysis, collateral analytics, valuation, and execution economics.

  • Working knowledge of mortgage and home equity products, pricing, valuation, and portfolio performance, including experience with Mortgage-Backed Securities (MBS), Residential Mortgage-Backed Securities (RMBS), home equity loans and HELOCs, securitization structures, and secondary market execution.

  • Experience supporting cash flow analytics, portfolio analytics, profitability analysis, forecasting, scenario analysis, business performance measurement, and mortgage-related modeling to support strategic decision-making

  • Familiarity with pull-through, fallout, prepayment, pipeline, and loan-level performance drivers, with the ability to translate assumptions into profitability, capital utilization, valuation impacts, and broader business outcomes.

  • Ability to assist with evaluating mortgage portfolios, identify profitability and risk drivers, assess valuation impacts, and deliver actionable insights and recommendations to senior leaders and business partners.

  • Experience supporting the development, maintenance, and validation of analytical models, dashboards, and reporting solutions that support mortgage valuation, profitability measurement, capital markets activities, portfolio monitoring, forecasting, and executive decision-making.

  • Proficiency with one or more analytical and reporting tools, such as SQL, Python, SAS, Power BI, or Tableau, to extract, analyze, validate, visualize, and communicate mortgage and financial data.

  • Experience working with financial datasets and collaborating with Risk, Finance, Capital Markets, Servicing, and business teams to support analytical deliverables, reporting, and business performance monitoring.

  • Strong analytical, problem-solving, communication, presentation, and collaboration skills, with the ability to explain findings clearly, respond to stakeholder needs, and contribute effectively in a team environment.


Job Expectations:

  • This position offers a hybrid work schedule.

  • Willingness to work onsite at stated location on the job posting.

Job Locations:

  • Three Wells Fargo Center, 401 S Tryon St, CHARLOTTE, NC

  • Las Colinas Bldg B, Irving Campus, IRVING, TX

  • West Des Moines Campus, 800 S Jordan Creek Pkwy, WEST DES MOINES, IA

Posting End Date: 

22 Sep 2026

*Job posting may come down early due to volume of applicants.

We Value Equal Opportunity

Wells Fargo is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit’s risk appetite and all risk and compliance program requirements.

Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.

Applicants with Disabilities

To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo.

Drug and Alcohol Policy

 

Wells Fargo maintains a drug free workplace.  Please see our Drug and Alcohol Policy to learn more.

Wells Fargo Recruitment and Hiring Requirements:

a. Third-Party recordings are prohibited unless authorized by Wells Fargo.

b. Wells Fargo requires you to directly represent your own experiences during the recruiting and hiring process.

BFSI

Company

Wells FargoBFSI
CHARLOTTE, United States of America

Company facts come from this company's own listings. We only show what the postings themselves carry.

Sourced from Wells Fargo's careers site·first seen 12 Sept 2026·last verified 17 Sept 2026·How we source jobs

Similar jobs

  • AI Senior Consultant at caiCLIENT, United States of America–match not yet calculated
  • Business Analytics Consultant - Regulatory Reporting System Support at pncPittsburgh (15222), United States of America–match not yet calculated
  • Business Analytics Consultant - Regulatory Reporting System Support at PNC Financial ServicesPittsburgh, United States of America–match not yet calculated
  • Marketing Technology & Data Consultant (Dealer & Marketing Data Focus) at CaterpillarIrving, United States of America–match not yet calculated
  • Principal Analytics Consultant (Power BI) at phdataUS - Remote–match not yet calculated

Browse more jobs

  • Data & Analytics Consultant jobs in United States
  • Cybersecurity Consultant jobs in United States
  • IT Consultant jobs in United States
  • Business Analyst jobs in United States
  • Data & Analytics Consultant jobs in Netherlands
  • Data & Analytics Consultant jobs in United Kingdom