Data Operations Specialist II - Irvine, CA

Colonial Group; Irvine (CA); Hybrid; USD 70,000 - 90,000; Full time

Job summary

Colonial Group seeks a Data Operations Specialist II to manage foreclosure and REO data, ensuring accuracy, timeliness, and compliance with state statutes and investor guidelines. The role acts as a data and systems SME and partners with operations and technology to improve data quality and auction execution.

The position requires advanced Excel skills, experience with Salesforce, and the ability to resolve complex data/workflow issues while maintaining documentation and SOPs.

Qualifications

• Data operations and governance expertise; ensure accuracy and completeness across inputs.
• Experience with data audits, reconciliations, and process documentation.
• Ability to analyze system behavior and resolve complex data/workflow issues.

Responsibilities

• Manage data ingestion and movement across systems and record status, resolving exceptions.
• Perform data audits to verify completeness and accuracy across sources and platforms.
• Research and resolve complex data, system, integration, and workflow issues affecting timelines.
• Coordinate with attorneys, vendors, and internal teams to correct discrepancies for compliant auction execution.
• Document data flows, validation rules, and SOPs; train users on data-management practices.
• Collaborate with teams to identify process improvements, including AI-driven data quality enhancements.

Skills

Analytical skills

Communication

Cross-functional collaboration

Attention to detail

Time management

Education

High school diploma or equivalent

Associate or Bachelor’s degree (preferred)

Tools

Excel

Salesforce

MS Office

Job description

Data Operations Specialist II

The Data Operations Specialist II manages foreclosure and REO data through auction readiness, ensuring information is accurate, complete, timely, and compliant with state statutes, investor guidelines, and client requirements. Serving as a data and systems subject matter expert and escalation point, this position analyzes system behavior, resolves complex data and workflow issues, and partners with operations and technology teams to improve data quality, system reliability, and auction execution.

This position is in office 4 days per week.

Key Responsibilities

• Manage data ingestion and movement across systems, monitor processing results and record status, and resolve or elevate exceptions that affect accurate and timely processing or publication.
• Perform data audits and reconciliations to verify completeness, accuracy, consistency, and compliance across source files, internal systems, reports, and the Auction.com platform.
• Research and resolve complex data, system, integration, and workflow issues that may affect foreclosure timelines, property information, reporting, or auction readiness.
• Coordinate with attorneys, servicers, vendors, data partners, and internal teams to correct record discrepancies, cure file defects, clarify source information, and support compliant auction execution.
• Document data flows, system dependencies, validation rules, and exception-handling procedures; maintain SOPs and train users on accurate system and data-management practices.
• Partner with operations and technology teams to identify and implement process improvements, including AI-driven solutions that enhance data quality, efficiency, and system reliability.

Qualifications

• High school diploma or equivalent required; associate or bachelor’s degree, or relevant equivalent experience, preferred.
• Advanced Microsoft Excel proficiency, including formulas, lookups, data validation, filtering, reconciliation, and analysis of high-volume datasets.
• Proficiency in Microsoft Office applications and business collaboration tools.
• Working knowledge of Salesforce or similar CRM, including data relationships, reporting, and issue research.
• Strong analytical, problem-solving, communication, and cross-functional collaboration skills.
• Strong attention to detail and commitment to data accuracy and completeness.
• Ability to manage high-volume workloads and meet strict deadlines.
• Ability to learn new systems and adapt to changing business rules, client requirements, and technical processes.