Data Analyst

Consolidated Analytics, Inc.

Chennai

On-site

INR 500,000 - 900,000

Full time

13 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Consolidated Analytics, Inc. in Chennai is seeking a detail-oriented US Mortgage Specialist to join our Data Analytics team.

You will analyze mortgage data, handle report requests from Transaction Managers, and ensure timely delivery of reports while maintaining accuracy and compliance with regulatory requirements. The role requires strong Excel skills and deep knowledge of US mortgage products (Conventional, FHA, VA, USDA).

Qualifications

  • US mortgage products knowledge: Conventional, FHA, VA, USDA.
  • Familiar with US mortgage processes and regulatory requirements.
  • Proficient in Excel with VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, Pivot Tables.
  • Experience in data analysis, reporting, validation, and reconciliation.
  • Ability to handle large datasets and identify data discrepancies.
  • Strong analytical, problem-solving, and attention-to-detail skills.

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.

Skills

Excel
Data analysis
Attention to detail
Reporting

Tools

Pivot Tables

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

loanDNA • Chennai

On-site
INR 1,200,000 - 1,800,000
Executive to Assistant Manager
Executive to Assistant Manager

Consolidated Analytics, Inc. • Chennai

On-site
INR 800,000 - 1,200,000
Team lead - Valuation QC
Team lead - Valuation QC

Consolidated Analytics Inc • Chennai District

On-site
INR 1,200,000 - 1,800,000
Data Analytics & Reporting Analyst
Data Analytics & Reporting Analyst

Kimoha Technologies • Mysuru

On-site
INR 600,000 - 800,000
Closing Coordinator
Closing Coordinator

Consolidated Analytics, Inc. • Chennai

On-site
INR 300,000 - 600,000
Mortgage Payoff & Reconciliation
Mortgage Payoff & Reconciliation

Consolidated Analytics, Inc. • Chennai District

On-site
INR 7,225,000 - 11,561,000
Contract-Desktop Engineer
Contract-Desktop Engineer

Consolidated Analytics, Inc. • Chennai

On-site
INR 300,000 - 520,000
Mortgage Closer- Post closing- Chennai
Mortgage Closer- Post closing- Chennai

Consolidated Analytics, Inc. • Chennai District

On-site
INR 600,000 - 1,000,000
Walk-in | US Mortgage (Underwriting)- Data Analyst! Immediate joiners ! Chennai
Walk-in | US Mortgage (Underwriting)- Data Analyst! Immediate joiners ! Chennai

Consolidated Analytics • Chennai

On-site
INR 550,000 - 750,000
L1 Tech Support - Pune
L1 Tech Support - Pune

Consolidated Analytics, Inc. • Pune District

On-site
INR 300,000 - 600,000