Regulatory Data Quality Analyst

Remote Jobs

Fort Mill (SC)

Remote

USD 22,000 - 33,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

First American’s ServiceMac is seeking a Data Reconciliation Analyst to manage day-to-day data reconciliations, validation, and reporting to support the Regulatory team. This role emphasizes accuracy, completeness, and collaboration with data and business teams across Mortgage and financial services.

The analyst will develop reconciliation procedures, build reports in Excel and Power BI, and assist with regulatory exams and client inquiries.

Qualifications

  • Three to five years of recent experience performing data reconciliation, regulatory reporting, financial reporting, or data analysis in a banking, mortgage servicing, or financial services environment.
  • Advanced proficiency with Microsoft Office Suite, including expert-level knowledge of Microsoft Excel (PivotTables, XLOOKUP, Power Query and advanced formulas).
  • Experience with reconciliation reports and analyzing large data sets.
  • Proficiency in prompt engineering and utilizing generative AI tools like ChatGPT or Claude to streamline reporting and/or reconciliations.
  • Demonstrated ability to research, analyze, and resolve complex data discrepancies.
  • Strong analytical, organizational, and problem-solving skills with exceptional attention to detail.
  • Excellent verbal and written communication skills with the ability to effectively communicate with internal and external customers, peers, auditors, regulators, and management.
  • Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools is preferred.

Responsibilities

  • Perform reconciliations between multiple internal systems, databases, regulatory reports and/or source documents to ensure the accuracy and completeness of regulatory reporting.
  • Validate data supporting Mortgage Call Reports (MCR), NMLS reporting, state licensing reports, investor reporting and other reporting needs/requirements.
  • Develop operational, reconciliation, management, and exception reports.
  • Analyze and investigate data discrepancies, identify root causes, and coordinate corrective actions with business partners.
  • Interpret regulatory reporting requirements and translate them into reconciliation and validation processes.
  • Work closely with the business units they define the data requirements to fulfill requests and validate report results.
  • Perform data quality assurance reviews, reconciliation testing, and validation procedures to ensure regulatory reports are complete, accurate, and submitted within required deadlines.
  • Monitor recurring reconciliation exceptions and recommend process improvements, automation opportunities and enhanced data controls.
  • Develop and maintain reconciliation procedures, desktop procedures, data dictionaries and supporting documentation.
  • Assist in testing regulatory reporting changes and new reporting requirements.
  • Support regulatory examinations, internal audits, client due diligence requests and management inquiries by providing reconciliation support and documentation.
  • Utilize Microsoft Excel, Power BI, and other reporting tools to analyze large datasets, identify trends and develop management reporting.
  • Maintain detailed documentation supporting reconciliation activities, issue resolution, and regulatory reporting controls.
  • Coordinate responses to clients and/or third parties regarding reporting questions.

Skills

Data reconciliation
Regulatory reporting
Financial reporting
Data analysis
Excel
Power BI
SharePoint
Power Automate
AI tools (ChatGPT/Claude)

Tools

Excel
Power BI
SharePoint
Power Automate
AI tools (ChatGPT/Claude)

Job description

First American’s ServiceMac is seeking a Data Reconciliation Analyst to manage day-to-day data reconciliations, validation, and reporting to support the Regulatory team. This role emphasizes accuracy, completeness, and collaboration with data and business teams across Mortgage and financial services.

The analyst will develop reconciliation procedures, build reports in Excel and Power BI, and assist with regulatory exams and client inquiries.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integrity & Regulatory Reporting Analyst
Data Integrity & Regulatory Reporting Analyst

First American Financial Corporation • Arizona

Remote
USD 22,000 - 33,000
Medical benefits
Dental benefits
Vision benefits
+3
Data Reconciliation & Regulatory Reporting Analyst
Data Reconciliation & Regulatory Reporting Analyst

First American • Fort Mill (SC)

Remote
USD 22,000 - 33,000
Medical
Dental
Vision
+3
Data Reconciliation & Regulatory Reporting Analyst
Data Reconciliation & Regulatory Reporting Analyst

First American Financial Corporation • Florida

Remote
USD 22,000 - 33,000
Medical, dental, vision coverage
401(k) plan
PTO / paid sick leave
+1
Data Integrity & Regulatory Reporting Analyst
Data Integrity & Regulatory Reporting Analyst

First American Financial Corporation • Ohio

Remote
USD 22,000 - 33,000
Regulatory Data Reconciliation Analyst
Regulatory Data Reconciliation Analyst

First American Financial Corporation • California

Remote
USD 22,000 - 33,000
Data Integrity & Regulatory Reporting Analyst
Data Integrity & Regulatory Reporting Analyst

First American • United States

Remote
USD 22,000 - 33,000
Comprehensive benefits package (health
Data Reconciliation & Regulatory Reporting Analyst
Data Reconciliation & Regulatory Reporting Analyst

First American Financial Corporation • Georgia

Remote
USD 22,000 - 33,000
Data Reconciliation Analyst — Regulatory Reporting & AI Tools
Data Reconciliation Analyst — Regulatory Reporting & AI Tools

First American Financial Corporation • Texas

Remote
USD 22,000 - 33,000
Medical, dental, vision benefits
401k with company match
PTO / paid time off
Data Reconciliation Analyst (Remote)
Data Reconciliation Analyst (Remote)

Remote Jobs • Fort Mill (SC)

Remote
USD 22,000 - 33,000
Bank Reconciliation Analyst - Mortgage Servicing & Compliance
Bank Reconciliation Analyst - Mortgage Servicing & Compliance

First American • Fort Mill (SC)

On-site
USD 29,000 - 39,000
Medical benefits
Dental benefits
Vision benefits
+3