Capital Markets QRM Analyst

Summary

Guild Mortgage Company is a mortgage banking firm dedicated to providing affordable home financing and professional service to homeowners and buyers. The Capital Markets QRM Analyst operates and supports the QRM Mortgage Banking risk management system, ensuring accurate pipeline and trade data, producing risk and best execution reporting, maintaining PowerBI dashboards, and supporting the Capital Markets trading desk with hedging and exposure information.

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

Skills

• Bachelors Degree in Finance, Economics, Information Technology, Computer Science, Engineering, Mathematics, or a related field
• 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
• 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
• 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
• Work is primarily sedentary; mobility in an office setting
• Ability to operate standard office equipment and keyboards
• Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation
• Office environment – moderate noise, no substantial exposure to adverse environmental conditions
• Must be able to adhere to process protocol. Must be able to apply established protocols in a timely manner
• Work is primarily performed during the business week, Monday - Friday
• Travel: 5% or less
• Hands-on experience with the QRM Risk Framework, QRM Management Repository (QRM-MB), and QRM Central Administration; exposure to Microsoft HPC Clusters a plus
• 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
• 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 operating and supporting the QRM platform (data import, trade entry, reporting) preferred

Qualifications

Must Haves

• Bachelors Degree in Finance, Economics, Information Technology, Computer Science, Engineering, Mathematics, or a related field
• 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
• 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
• 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
• Work is primarily sedentary; mobility in an office setting
• Ability to operate standard office equipment and keyboards
• Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation
• Office environment – moderate noise, no substantial exposure to adverse environmental conditions
• Must be able to adhere to process protocol. Must be able to apply established protocols in a timely manner
• Work is primarily performed during the business week, Monday - Friday
• Travel: 5% or less
• Hands-on experience with the QRM Risk Framework, QRM Management Repository (QRM-MB), and QRM Central Administration; exposure to Microsoft HPC Clusters a plus
• 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

Nice to Haves

• 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 operating and supporting the QRM platform (data import, trade entry, reporting) preferred

Benefits

• Medical
• Dental
• Vision
• Life insurance
• AD&D
• LTD
• 401(k) with employer match