Data Analyst

Job Summary

We are looking for a detail-oriented US Mortgage Specialist to join our Data Analytics team. The candidate will be responsible for analyzing mortgage data, handling report requests from Transaction Managers, and ensuring accurate and timely delivery of reports. Strong knowledge of the US mortgage industry and advanced Excel skills are essential.

Key Responsibilities:

• Analyze large mortgage datasets and prepare reports, dashboards, and MIS reports.
• Ensure data accuracy, consistency, and completeness across multiple systems.
• Perform data cleansing, validation, and reconciliation to identify and resolve discrepancies.
• Consolidate data from multiple sources while ensuring compliance with business requirements.
• Coordinate with Transaction Managers to understand reporting requirements and deliver reports within defined TAT and SLA.
• Support ad hoc reporting requests and identify opportunities to improve reporting efficiency.

Required Expertise and Experience:

• Good understanding of US mortgage products, including Conventional, FHA, VA, and USDA loans.
• Knowledge of US mortgage processes, terminology, and regulatory requirements.
• Strong proficiency in Microsoft Excel, including VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, and Pivot Tables.
• Experience in data analysis, reporting, data validation, and reconciliation.
• Ability to work with large datasets and identify data discrepancies.
• Strong analytical, problem-solving, and attention-to-detail skills.

Generic Skills and Competencies:

• Excellent verbal and written communication skills.
• Strong time-management and organizational skills.
• Ability to manage multiple tasks and meet strict deadlines.
• Ability to work independently and collaboratively with clients.

Consolidated Analytics | End-to-End Mortgage Solutions. Real Expertise. Real Results.
Consolidated Analytics is a data-driven mortgage solutions partner supporting the full life of the loan, from origination through servicing and capital markets. We combine asset-level intelligence with enterprise-scale solutions to power smarter decisions and measurable business outcomes. Our integrated capabilities span due diligence, residential and commercial valuation, collateral and risk analytics, process and technology optimization, and regulatory compliance, helping clients operate with clarity, agility, and confidence in a rapidly evolving market.
What sets us apart?
We bring together deep mortgage industry expertise, integrated technology, and a multidisciplinary workforce to help clients optimize quality, drive operational performance, and enhance decision-making at scale. Across the loan lifecycle, whether managing volume, acquiring assets in bulk, scaling originations, launching or expanding servicing, or navigating market and regulatory change, our teams deliver with clarity, compliance, and speed.
Core Services
• Mortgage Due Diligence
• Property Valuation + Analytics
• Mortgage Fulfillment (Origination and Servicing)
• Default Services (Claims, REO, Rental Management)
• Risk + Compliance Advisory
• Business Process Solutions (BPS)
Our Evolution
Over the past decade, we’ve strategically acquired and integrated best-in-class firms, including OpEXNOW, Equitable Mortgage Solutions, Carrington Property Services, and RealInfo into a unified platform designed to meet the demands of today’s dynamic market.
We’re not just a vendor, we’re a partner built for transformation.
Careers
We’re always hiring talented professionals who want to grow, lead, and win.

About the role

• Describe the role and team the candidate will be joining

What you'll do

• Describe the specific responsibilities and job functions of the role

Qualifications

• Describe the experience and attributes of the ideal candidate