Mortgage Regulatory Data Analyst — Reporting & Validation

First American; Iowa (LA); On-site; USD 85,000 - 113,000; Full time

Job summary

First American is seeking a Regulatory Reporting Business Analyst with strong mortgage servicing experience to translate regulatory data into executable reporting requirements. The role bridges Regulatory/Risk, operations, clients, and development teams, driving accurate reports and validations.

You will interpret complex regulatory requirements, document precise data needs, and lead end-to-end delivery while ensuring data integrity and compliance.

Qualifications

• Mortgage servicing experience is required.
• Experience with regulatory reporting within the mortgage servicing or mortgage banking industry.
• Working knowledge of mortgage-related loan, transaction, and servicing data.
• Ability to read and write basic to intermediate SQL queries for research, reconciliation, and data validation.
• Strong requirements documentation and written communication skills.

Responsibilities

• Review incoming regulatory data and reporting requests to identify required data, reporting periods, populations, calculations, classifications, and submission requirements.
• Translate regulatory reporting requirements into specific, development-ready data and reporting requirements.
• Identify incomplete, ambiguous, or conflicting requirements before requests are submitted for development.
• Document detailed requirements for SQL report developers, including data elements, business rules, calculations, populations, filters, reporting periods, and outputs.
• Own and actively manage assigned regulatory reporting requests from intake through final delivery.
• Coordinate activities across Regulatory/Risk, servicing operations, clients, development teams, and stakeholders.

Skills

Mortgage servicing experience

Regulatory reporting experience

SQL knowledge

Attention to detail

Written communication

Leadership in meetings

Tools

SQL Server Management Studio

Microsoft SQL Server

Microsoft Excel

Microsoft Azure DevOps

Microsoft Word

Job description

First American is seeking a Regulatory Reporting Business Analyst with strong mortgage servicing experience to translate regulatory data into executable reporting requirements. The role bridges Regulatory/Risk, operations, clients, and development teams, driving accurate reports and validations.

You will interpret complex regulatory requirements, document precise data needs, and lead end-to-end delivery while ensuring data integrity and compliance.