Data Reconciliation Analyst (Remote)
Read straight from First American's careers page, verified 4d ago.Seekless can tailor your résumé to it.
Seekless can write your résumé for this posting first.
Before you apply
SalaryNo pay range posted
LocationUSA, South Carolina, Fort Mill; USA, Ohio, Remote; USA, Arizona, Remote; USA, Florida, Remote; USA, Georgia, Remote; USA, Texas, Remote; USA, California, Remote
Work moderemote · United States
Typefull-time
SeniorityMid
Experience3–5 yrs
Company size10,000+ people
PostedOct 26, 2026 · 1w ago
Verified live4d ago
At a glanceSummarised by Seekless from the posting.
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 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
Skills
Microsoft Excel
Power BI
SharePoint
Power Automate
ChatGPT
Claude
SQL
Who We Are
ServiceMac is a new sub-servicing entity backed by some of the leading practitioners of the mortgage servicing industry. ServiceMac is focused on providing superior technology, products, and services for the mortgage and real estate industries backed by highly personalized service and support. Through continuous innovation and acquisition, our offerings comprise of personalized solutions that span the mortgage continuum and enhance security, compliance, customer satisfaction, and profitability. Our inclusive, people-first culture has earned our company numerous accolades, including being named to the Fortune 100 Best Companies to Work For® list for eleven consecutive years. We have also earned awards as a best place to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American will always strive to be a great place to work, for all.
What We Do
ServiceMac is a subservicing entity backed by some of the leading practitioners of the mortgage servicing industry. ServiceMac is focused on providing superior technology, products, and services for the mortgage and real estate industries backed by highly personalized service and support. Through continuous innovation and acquisition, our offerings comprise personalized solutions that span the mortgage continuum and enhance security, compliance, customer satisfaction, and profitability.
The Data Reconciliation Analyst will be responsible for the day-to-day reconciliation, validation, maintenance, and continuous improvement of data supporting ServiceMac’s Regulatory team. This role focuses on coordinating with the respective teams to ensure the accuracy, completeness, and integrity of reporting through detailed data reconciliations, quality assurance reviews, root cause analysis and collaboration with multiple business and data teams. Qualified candidates will have a proven background performing data analysis, reconciliations, SQL reporting, AI tools and process improvement within a financial services or mortgage servicing environment.
What You’ll Do
•
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.
Requirements
What You’ll Bring
•
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 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.