Capital Markets QRM Analyst

Guild Mortgage•San Diego, CA

2d•Onsite

About The Position

The Quantitative Risk Management (QRM) Analyst is responsible for the daily operation and support of Guild’s QRM Mortgage Banking (QRM-MB) risk management system, which models the daily risk position of rate locks, closed loans, and forward hedge positions. This role ensures the accuracy and integrity of pipeline and trade data, updates and reconciles trades, produces daily risk and best execution reporting, and keeps PowerBI dashboards aligned with underlying QRM data. The QRM Analyst works closely with the Capital Markets trading desk—providing timely, accurate position and coverage information to support hedging decisions—and performs minor configuration and programming within the QRM framework to maintain and improve daily processes.

Requirements

Bachelors Degree in Finance, Economics, Information Technology, Computer Science, Engineering, Mathematics, or a related field. preferred.
Minimum three years experience in Secondary Marketing, Capital Markets, or Quantitative Risk Management (QRM) / Asset Liability Management (ALM) applications, with a technical or functional focus.
Direct experience with QRM-MB preferred.
Hands-on experience with the QRM Risk Framework, QRM Management Repository (QRM-MB), and QRM Central Administration preferred; exposure to Microsoft HPC Clusters a plus.
Strong problem-solving and analytical skills with high attention to detail.
Working knowledge of mortgage Secondary Marketing concepts: pipeline hedging, coverage, best execution, coupon slotting, pull-through/fallout, and loan delivery.
Hands-on experience operating and supporting the QRM platform (data import, trade entry, reporting) preferred.
Ability to perform minor programming and configuration within QRM, including report and rule/setup edits; scripting experience (e.g., VBA, PowerShell, SQL) a plus.
Proficiency with Microsoft SQL Server and the ability to write and troubleshoot queries.
Strong PowerBI skills, including building and maintaining reports and dashboards and reconciling them to source data.
Advanced Microsoft Excel skills, including the development and maintenance of macros using VBA.
Familiarity with LOS and pricing-engine data (e.g., Encompass, Optimal Blue) and how it flows into QRM a plus.
Ability to manage multiple priorities in a fast-paced, deadline-driven, metrics-oriented environment.
Proven ability to build strong working relationships with traders, internal teams, and external stakeholders.
Self-motivated with accountability, initiative, and a team-oriented mindset.
Excellent verbal and written communication skills required.
Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
Commitment to company values.

Nice To Haves

Bachelors Degree in Finance, Economics, Information Technology, Computer Science, Engineering, Mathematics, or a related field.
Direct experience with QRM-MB.
Hands-on experience with the QRM Risk Framework, QRM Management Repository (QRM-MB), and QRM Central Administration.
Exposure to Microsoft HPC Clusters.
Hands-on experience operating and supporting the QRM platform (data import, trade entry, reporting).
Scripting experience (e.g., VBA, PowerShell, SQL).
Familiarity with LOS and pricing-engine data (e.g., Encompass, Optimal Blue) and how it flows into QRM.

Responsibilities

Perform the daily operation and support of the QRM-MB system, ensuring the platform is running correctly and available to support Secondary Marketing and the trading desk.
Import, validate, and reconcile daily pipeline data (rate locks, closed loans, and fallout) between the LOS/pricing engine and QRM, researching and resolving discrepancies to ensure data accuracy and integrity.
Update, enter, and reconcile trades and forward positions (e.g., TBA and specified pools) in QRM, ensuring hedge positions align with the pipeline.
Run and distribute daily risk, position, coverage, and profit-and-loss (P&L) reports; deliver timely coverage and exposure information to traders to support hedging and margin protection.
Generate and validate daily best execution files and reporting to help identify the optimal delivery method and investor destination for closed loans.
Maintain and reconcile PowerBI reports and dashboards, ensuring they remain aligned and consistent with the underlying QRM data and other source systems.
Support the automation of Secondary Marketing processes using QRM-MB, including daily ETL/data-transfer routines to and from the data warehouse.
Perform minor programming, configuration, and edits within the QRM framework—such as report modifications, rule/setup adjustments, and calculation logic—to maintain and improve daily processes.
Validate QRM model inputs and assumptions used in daily processing to ensure accuracy and reliability of the risk position.
Provide day-to-day support to the Capital Markets trading desk and respond to ad hoc data, position, and reporting requests.
Reconcile daily Secondary Marketing activity with internal records and support Finance reconciliation as needed.
Follow and help maintain SOX controls, documentation, and disaster recovery procedures for daily QRM processes.
Contribute to job aids and training materials that document daily QRM procedures.
Partner with business segments across organization to ensure alignment on QRM outputs, data integrity, analytical concepts and methodologies, and control standards.
Perform other duties as assigned.