Data Analytics & Reporting Analyst

Job description

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