Data Analyst
Chennai, India
- Posted 1w ago
- From Consolidated Analytics’s careers page
- Location
- Chennai, India
- Department
- Data and Analytics
Opens the listing on ats.rippling.com
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
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.
About Consolidated Analytics
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.
Skills they ask for
Pick one to see other roles that ask for it.
About Consolidated Analytics
Mortgage due diligence and operationsConsolidated Analytics helps mortgage lenders, servicers and investors with due diligence, valuations, business process services and advisory.
See all 28 roles at Consolidated AnalyticsMore roles at Consolidated Analytics
See all 28- Desktop EngineerChennaiInformation TechnologyChennai, India1w
- Closing CoordinatorChennaiBusiness OperationsChennai, India3w
- QA UnderwriterChennaiQuality AssuranceChennai, India3w
- Pipeline CoordinatorChennaiBusiness OperationsChennai, India3w
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.