Consolidated Analytics, Inc.

Role Description The Freddie Mac (FHLMC) Reconciliation Consultant will review and reconcile the mortgage servicing organization's FHLMC accounts. - Perform Freddie Mac monthly reconciliations and completion of Required Monthly Forms utilizing MSP standard reports. - Confirm the correct daily, weekly, and monthly processes to identify and clear any discrepancies. - Understand the Freddie Mac Reconciliation Bulletin 2025-2, issued 2/12/25, to ensure accurate loan-level records and eliminate inaccurate edits. - Reconcile each data element included in the monthly Freddie Mac Trial Balance report within 30 days after the end of each Accounting Cycle. - Prepare a separate monthly reconciliation for each unique Seller/Servicer number using the online version of the new Guide Form 75 or an exact replica. - Provide Freddie Mac with a copy of the completed Form 75 and supporting documentation for up to one year from the date of the related reconciliation worksheet. - Perform reconciliations and establish written procedures to support Servicer adoption of the portfolio reconciliation process from March 1, 2025, to June 30, 2026. - Understand that Freddie Mac will waive contract noncompliance and change compensatory fees if actions are taken prior to July 1, 2026. - Be aware that data corrections identified through the monthly portfolio reconciliation process will incur contract noncompliance and compensatory fees starting July 1, 2026. Qualifications - Must have "hands-on" Mortgage Servicing/Mortgage Banking Account Reconciliation experience in the Freddie Mac FHLMC domain. - Must be able to create and provide training documentation to support adoption of the revised reconciliation process. - Teach the revised reconciliation process to client staff. - Assess staff's ability to re-reconcile prior reconciliations with inaccurate edits. - Determine the time required to teach staff to re-reconcile previously submitted reconciliations or complete the reconciliations themselves. Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances

Role Description The Freddie Mac (FHLMC) Reconciliation Consultant will review and reconcile the mortgage servicing organization's FHLMC accounts. - Perform Freddie Mac monthly reconciliations and completion of Required Monthly Forms utilizing MSP standard reports. - Confirm the correct daily, weekly, and monthly processes to identify and clear any discrepancies. - Understand the Freddie Mac Reconciliation Bulletin 2025-2, issued 2/12/25, to ensure accurate loan-level records and eliminate inaccurate edits. - Reconcile each data element included in the monthly Freddie Mac Trial Balance report within 30 days after the end of each Accounting Cycle. - Prepare a separate monthly reconciliation for each unique Seller/Servicer number on the online version of the new Guide Form 75 or an exact replica. - Provide Freddie Mac with a copy of the completed Form 75 and supporting documentation upon request for up to one year from the date of the related reconciliation worksheet. - Perform reconciliations and establish written procedures to support Servicer adoption of the portfolio reconciliation process from March 1, 2025, to June 30, 2026. - Understand that Freddie Mac will waive contract noncompliance and change compensatory fees if actions are taken prior to July 1, 2026. - Be aware that beginning on July 1, 2026, data corrections identified through the monthly portfolio reconciliation process will incur contract noncompliance and compensatory fees. Qualifications - Must have "hands-on" Mortgage Servicing/Mortgage Banking Account Reconciliation experience in the Freddie Mac FHLMC domain. - Must be able to create and provide training documentation to support adoption of the revised reconciliation process. - Teach the revised reconciliation process to client staff. - Assess staff's ability to re-reconcile prior reconciliations with inaccurate edits. - Determine the time required to teach staff to re-reconcile previously submitted reconciliations or complete the reconciliations themselves. Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances

Role Description This role supports the EPIC program, a large-scale initiative to transition from a highly customized version of LoanServ to the industry-standard SaaS platform. The position blends data warehouse development with business analysis and project support, requiring a strong understanding of both data systems and operational processes. Must be legally authorized to work in the United States. No C2C - corp to corp, No 1099, No W9. Location: This is a remote position, but travel to Oklahoma City will be required throughout the project. Bonus: You will receive a sign-on bonus of $500.00. This bonus will be paid out on the paycheck following the pay period in which you complete 90-days of employment. You will also receive a $500.00 bonus upon completion of the project, including any extensions offered by the client. There is a 6-month project minimum to receive the bonus, and you must remain employed through project completion. This bonus will be paid out in your final paycheck with the company. To receive either payout, you must be in active status in good standing with the company. Key Responsibilities - Design SQL specifications for new data warehouse tables, including: - Defining table structures - Writing and optimizing queries - Supporting development and post-build testing - Collaborate with Corporate Technology teams to ensure accurate implementation of data models and warehouse solutions - Provide business analysis and project support across EPIC workstreams, including: - Requirements gathering and documentation - Solution design and validation - Testing oversight and coordination - Support migration and modernization efforts, including: - Redesign of scripts and batch processes - Data transformation and reporting solutions - Warehouse table and reporting enhancements - Ensure solutions align with: - Business operations and workflows - Risk management and compliance requirements - Flexibility for case-by-case operational scenarios - Assist in the replacement or redesign of: - Process batches and automation workflows - Reporting and data pipelines - Operational and data-driven processes Qualifications - Strong SQL expertise, including data modeling and query design - Experience designing and supporting data warehouse solutions - Have recent, hands-on experience designing and owning stored procedures and data warehouse tables, not just consuming or extracting data. - Are comfortable operating independently at the data-layer level with minimal handoff. - Can proactively escalate unresolved dependencies or barriers and drive issues to resolution. - Spend the majority of their time on data architecture, development, and backend design, rather than report development or BI consumption. - Ability to translate business requirements into technical specifications - Understanding of business processes and operational workflows - Experience with testing, validation, and quality assurance - Experience with LoanServ (highly preferred but not required) - Background in financial services, lending, or mortgage servicing - Experience supporting large-scale system migrations or SaaS transformations - Familiarity with batch processing, automation, and reporting systems - Strong analytical and problem-solving skills - Ability to bridge technical and business teams - Project coordination and stakeholder communication - Attention to detail with a focus on data accuracy and integrity - This is not a purely technical SQL role - candidates must understand business operations and processes - The role supports a multi-year enterprise transformation initiative (EPIC) - Work may span multiple domains, including data, reporting, automation, and operational redesign Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances

Role Description This role supports the EPIC program, a large-scale initiative to transition from a highly customized version of LoanServ to the industry-standard SaaS platform. The position blends data warehouse development with business analysis and project support, requiring a strong understanding of both data systems and operational processes. Location: This is a remote position, but travel to Oklahoma City will be required throughout the project. Bonus: You will receive a sign-on bonus of $500.00. This bonus will be paid out on the paycheck following the pay period in which you complete 90-days of employment. You will also receive a $500.00 bonus upon completion of the project, including any extensions offered by the client. There is a 6-month project minimum to receive the bonus, and you must remain employed through project completion. This bonus will be paid out in your final paycheck with the company. To receive either payout, you must be in active status in good standing with the company. Key Responsibilities - Design SQL specifications for new data warehouse tables, including: - Defining table structures - Writing and optimizing queries - Supporting development and post-build testing - Collaborate with Corporate Technology teams to ensure accurate implementation of data models and warehouse solutions - Provide business analysis and project support across EPIC workstreams, including: - Requirements gathering and documentation - Solution design and validation - Testing oversight and coordination - Support migration and modernization efforts, including: - Redesign of scripts and batch processes - Data transformation and reporting solutions - Warehouse table and reporting enhancements - Ensure solutions align with: - Business operations and workflows - Risk management and compliance requirements - Flexibility for case-by-case operational scenarios - Assist in the replacement or redesign of: - Process batches and automation workflows - Reporting and data pipelines - Operational and data-driven processes Qualifications - Strong SQL expertise, including data modeling and query design - Experience designing and supporting data warehouse solutions - Recent, hands-on experience designing and owning stored procedures and data warehouse tables - Comfortable operating independently at the data-layer level with minimal handoff - Ability to proactively escalate unresolved dependencies or barriers and drive issues to resolution - Spend the majority of their time on data architecture, development, and backend design - Ability to translate business requirements into technical specifications - Understanding of business processes and operational workflows - Experience with testing, validation, and quality assurance - Experience with LoanServ (highly preferred but not required) - Background in financial services, lending, or mortgage servicing - Experience supporting large-scale system migrations or SaaS transformations - Familiarity with batch processing, automation, and reporting systems - Strong analytical and problem-solving skills - Ability to bridge technical and business teams - Project coordination and stakeholder communication - Attention to detail with a focus on data accuracy and integrity - This is not a purely technical SQL role; candidates must understand business operations and processes - The role supports a multi-year enterprise transformation initiative (EPIC) - Work may span multiple domains, including data, reporting, automation, and operational redesign Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances

Role Description The right candidate is a substantially-seasoned mortgage servicing "Service Release SME" and "Loan Boarding SME" that can manage all aspects of the loan boarding division including: - Loan boarding - Loan de-boarding - Acquisition boarding - De-boarding - Managing the loss mitigation "in-flight" transfers both in and out of the portfolio - Leading the division in all required activities, processes, and tasks General Duties and Responsibilities: - Must be able to work on California PST scheduled hours, required - Responsible for handling and managing the servicing release of loans, sending goodbye letters, reviewing outages, and balancing each transfer - Review all requests for boarding & funding for approval, completeness & accuracy - Enter critical data and information for reporting purposes gleaned and/or translated from the Credit Approval Document, Loan Documentation Checklist, or other documents which supports governmental, regulatory, GL and management reporting - Set up all entities, including borrowers, co-borrowers, and guarantors in the mortgage servicing system - Ensure CIS records have been established prior to funding the loan for all parties to the credit - Determine causes of rejected items and process corrections - Balance work and prepare appropriate GL entries to various cost centers as required - Requires strong Excel knowledge intermediate expertise to perform regular Hlookup, Vlookup, and any other organizational boarding file prep - Append and manage large volumes of data from multiple sources via Excel or other loan boarding- / service release-related systems - Strong project management skills and organizational skills managing large volumes of servicing transfers in a short period of time - Basic SQL understanding related to servicing queries and data extractions or entry level knowledge and editing Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances

Role Description The right candidate is a substantially-seasoned mortgage servicing "Service Release SME", and "Loan Boarding SME" that can manage all aspects of the loan boarding division including: - Loan boarding - Loan de-boarding - Acquisition boarding - De-boarding - Managing the loss mitigation "in-flight" transfers both in and out of the portfolio - Leading the division in all required activities, processes, and tasks General Duties and Responsibilities: - Must be able to work on California PST scheduled hours, required - Responsible for handling and managing the servicing release of loans, sending goodbye letters, reviewing outages, and balancing each transfer - Review all requests for boarding & funding for approval, completeness & accuracy - Enter critical data and information for reporting purposes gleaned and/or translated from the Credit Approval Document, Loan Documentation Checklist, or other documents which supports governmental, regulatory, GL and management reporting - Set up all entities, including borrowers, co-borrowers, and guarantors in the mortgage servicing system - Ensure CIS records have been established prior to funding the loan for all parties to the credit - Determine causes of rejected items and process corrections - Balance work and prepare appropriate GL entries to various cost centers as required - Requires strong Excel knowledge with intermediate expertise to perform regular Hlookup, Vlookup, and any other organizational boarding file prep - Append and manage large volumes of data from multiple sources via Excel or other loan boarding- / service release-related systems - Strong project management skills and organizational skills managing large volumes of servicing transfers in a short period of time - Basic SQL understanding related to servicing queries and data extractions or entry level knowledge and editing Benefits - Medical Insurance - Dental Insurance - Vision Insurance - Life & Disability Insurances