First American Title Logo

First American Title

Data Reconciliation Analyst (Remote)

Posted 23 Days Ago
In-Office or Remote
6 Locations
16-24 Hourly
Mid level
In-Office or Remote
6 Locations
16-24 Hourly
Mid level
Performs data reconciliations, validation, quality assurance, and root-cause analysis for mortgage and regulatory reporting. Develops reconciliation, exception, management, and operational reports; investigates discrepancies; coordinates corrective actions; documents procedures and controls; supports audits and regulatory examinations; and identifies automation and process-improvement opportunities using Excel, Power BI, SQL, and generative AI tools.
The summary above was generated by AI
Who We AreServiceMac 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 DoServiceMac 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.

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.

Similar Jobs

An Hour Ago
Remote or Hybrid
USA
146K-272K Annually
Senior level
146K-272K Annually
Senior level
Machine Learning • Payments • Security • Software • Financial Services
Leads and develops an architecture team supporting asset management technology. Defines data, automation, and AI strategies, target architectures, reference patterns, governance, and delivery roadmaps. Evaluates platforms, guides solution design, promotes responsible AI adoption, and partners with business, engineering, risk, cybersecurity, and enterprise architecture stakeholders. Oversees talent development, architecture decisions, modernization, data enablement, automation, and executive communication in a regulated financial-services environment.
Top Skills: Agentic AiAnalytics PlatformsAPIsArtificial IntelligenceCloud ServicesData CatalogsData Governance ToolsData Integration PlatformsEvent StreamingGenerative AiLow-Code PlatformsMachine LearningMiddlewareRetrieval-Augmented GenerationRobotic Process AutomationSoftware Development LifecycleVersion ControlWorkflow Automation
3 Hours Ago
In-Office or Remote
United States
60K-90K Annually
Mid level
60K-90K Annually
Mid level
Big Data • Information Technology • Software • Analytics • Energy
Provides customer-facing technical consulting for AEC and utility customers implementing and optimizing SBS solutions. Leads technical discovery, configures workflows and models, delivers training and workshops, troubleshoots technical issues, documents solutions, manages customer requirements, and partners with Customer Success, Project Management, Product, and Engineering teams.
Top Skills: Autocad ElectricalAutodesk AutocadBimCadCivil 3DInventorRevit
3 Hours Ago
In-Office or Remote
United States
90K-95K Annually
Senior level
90K-95K Annually
Senior level
Big Data • Information Technology • Software • Analytics • Energy
Staff Product Designer will shape product strategy, design systems, and scalable product experiences across multiple teams. Responsibilities include simplifying complex data-heavy workflows, setting design standards, leading critiques, partnering with Product and Engineering, influencing executives, mentoring designers, and building design practices in an evolving organization. The role also involves prototyping with front-end code and experimenting with AI tools to improve design and development workflows.
Top Skills: Ai ToolsCSSHTMLJavaScriptReact

What you need to know about the San Francisco Tech Scene

San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.

Key Facts About San Francisco Tech

  • Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Google, Apple, Salesforce, Meta
  • Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
  • Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
  • Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account