Data Analytics & Reporting Analyst

kimohatechnologies
Apply Now ↗
📍 in📍 KA📍 Mysuru📍 Mysuru, KA, IndiaFull time

About this role

Company Description

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

Qualifications

Additional Information

Frequently Asked Questions

Is the salary disclosed for the Data Analytics & Reporting Analyst position at kimohatechnologies?
The salary for this Data Analytics & Reporting Analyst role at kimohatechnologies is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Data Analytics & Reporting Analyst position at kimohatechnologies located?
This Data Analytics & Reporting Analyst role at kimohatechnologies is based in in, KA, Mysuru, Mysuru, KA, India. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Is the Data Analytics & Reporting Analyst role at kimohatechnologies full-time or part-time?
This is listed as a Full time position. It is posted as a Data Analytics & Reporting Analyst role at kimohatechnologies.
How do I apply for the Data Analytics & Reporting Analyst position at kimohatechnologies?
Click the "Apply Now" button on this page. You will be redirected to kimohatechnologies's official application portal hosted on smartrecruiters where you can submit your application directly.
When was the Data Analytics & Reporting Analyst job at kimohatechnologies posted?
This Data Analytics & Reporting Analyst position at kimohatechnologies was posted on Jun 18, 2026. Apply as soon as possible — early applications are often reviewed first.
Data Analytics & Reporting Analyst
kimohatechnologies
Apply for this role ↗

You'll be redirected to kimohatechnologies's official application page on SmartRecruiters.