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.
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.
Pay Range: $16.07-$24.04 Hourly
This hiring range is a reasonable estimate of the base pay range for this position at the time of posting. Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements and geographic location.
** Note that the following statements only apply to candidates who will be working from an unincorporated area within Los Angeles County. **
First American will consider for employment all qualified applicants, including those with arrest or conviction records, in a manner consistent with the requirements of applicable state and local laws (e.g., the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act).
First American intends to conduct a review of an applicant’s criminal history in connection with a conditional offer. First American reasonably believes that a criminal history may have a direct, adverse and negative relationship with the following material job duties for this position potentially resulting in the withdrawal of the conditional offer of employment: handling of confidential, proprietary or trade secret information belonging to First American or its customers, administrating or facilitating financial transactions, and the ability to meet customer-imposed criminal history requirements.
What We OfferBy choice, we don’t simply accept individuality – we embrace it, we support it, and we thrive on it! Our People First culture is inclusive for all employees - not just because it's the right thing to do, but because it's the key to our success. We are proud to foster an authentic and inclusive workplace For All. You are free and encouraged to bring your entire, unique self to work. First American is an equal opportunity employer in every sense of the term.Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.Skills Required
- Three to five years of recent experience performing data reconciliation, regulatory reporting, financial reporting, or data analysis in banking, mortgage servicing, or financial services
- Advanced proficiency with Microsoft Office Suite
- Expert-level Microsoft Excel knowledge, including PivotTables, XLOOKUP, Power Query, and advanced formulas
- Experience reconciling reports and analyzing large datasets
- Proficiency in prompt engineering and generative AI tools such as ChatGPT or Claude
- 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 internal and external customers, peers, auditors, regulators, and management
- Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools
First American Title Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about First American Title and has not been reviewed or approved by First American Title.
-
Healthcare Strength — Health coverage includes medical, dental, vision, telehealth, and healthcare advocacy services, and is often described as a strong point. Low‑cost options in some cases help overall compensation feel more reasonable.
-
Retirement Support — A 401(k) savings plan with a company match is part of the package. This retirement support is highlighted as helping to offset base‑pay concerns in several roles.
-
Equity Value & Accessibility — An employee stock purchase plan is available and viewed favorably. Access to discounted equity contributes to the perceived competitiveness of total rewards.
First American Title Insights
What We Do
First American provides financial services through its Title Insurance and Services segment and its Specialty Insurance segment. The First American Family of Companies’ core business lines include title insurance and closing/settlement services; title plant management services; title and other real property records and images; valuation products and services; home warranty products; property and casualty insurance; and banking, trust, and investment advisory services. First American Title Insurance Company provides comprehensive title insurance protection and professional settlement services for homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers, title agencies and legal professionals to facilitate real estate purchases, construction, refinances or equity loans. First American's thorough title searches, title clearance and title insurance policies help to produce clear property titles and enable the efficient transfer of real estate. As one of the largest title insurance companies in the nation, First American offers title insurance and settlement services through its direct operations and an extensive network of agents throughout the United States and internationally. First American Title Insurance Company traces its history to 1889 and is the largest subsidiary of First American Financial Corporation (NYSE: FAF).
