Data Analytics & Reporting Analyst

Location: India (Remote / Hybrid)

Experience: 3 Years - 15 Years 

Overview

We are hiring a Data Analytics & Reporting Analyst with hands-on experience in the U.S. mortgage (loan origination and/or servicing) domain. This role will support analytics reporting and data operations for mortgage portfolios working closely with onshore teams and leveraging modern data platforms.

Key Responsibilities

Mortgage Domain Analytics (Core Focus)

• Work with U.S. mortgage datasets across loan origination and servicing lifecycle
• Analyze and report on key metrics such as:
• UPB (Unpaid Principal Balance) and loan-level roll-forwards
• Delinquency buckets (30/60/90) and default trends
• Prepayments (CPR) payoffs and servicing cash flows
• Loan pipeline lock funding and pull-through metrics
• Support remittance payment escrow and transaction-level reporting

Reporting & Dashboarding

• Build and maintain dashboards using Sigma Computing Tableau or Power BI
• Deliver daily weekly and monthly reports for servicing and origination teams
• Automate recurring reporting workflows

SQL & Data Processing

• Develop SQL queries using Microsoft SQL Server and/or Snowflake
• Perform data validation cleansing and reconciliation across multiple mortgage data sources
• Support development of curated datasets for analytics and reporting

Data Reconciliation & Quality

• Perform loan-level and portfolio-level reconciliation (e.g. UPB roll-forward validation payment vs transaction matching)
• Identify and resolve data discrepancies across systems (LOS servicing investor reporting)
• Ensure accuracy and consistency of reporting outputs

Collaboration & Delivery

• Work closely with U.S.-based stakeholders (servicing ops capital markets reporting teams)
• Translate business requirements into reports and dashboards
• Deliver high-quality outputs within defined SLAs

Required Qualifications (Domain-Focused)

• 3 years of experience in the U.S. mortgage domain (mandatory):
• Loan origination (LOS) OR
• Loan servicing (payments escrow remittance transactions) OR
• Mortgage reporting/capital markets support
• Strong understanding of mortgage lifecycle and key data elements (loan status balances payments delinquency)
• Technical Skills:
• Strong SQL experience (Microsoft SQL Server or similar)
• Experience with Snowflake or other data warehouse
• Hands-on BI/reporting tools like Sigma Computing Tableau or Power BI
• Advanced Excel skills
• Strong analytical thinking and attention to detail

Preferred Qualifications

• Experience with servicing reconciliation remittance reporting or investor reporting
• Exposure to MSR NQM RTL or secondary market data
• Familiarity with data pipelines or tools like dbt or Apache Airflow
• Experience working in offshore/onshore delivery models

Key Success Metrics

• Accuracy of mortgage data reporting and reconciliation
• Ability to independently handle domain-specific analysis
• Reduction in data discrepancies and manual effort
• Timely delivery aligned with U.S. business timelines

Remote Work :

No

Employment Type :

Full-time