Data Analytics & Reporting Analyst

Kimoha Technologies; Kalastavadi; On-site; INR 600,000 - 800,000; Full time

Job summary

Kimoha Technologies is looking for a Data Analytics & Reporting Analyst in Karnataka, India. This role focuses on the U.S. mortgage domain, requiring 3+ years of relevant experience. Candidates should possess strong SQL skills and be proficient with BI tools like Tableau and Power BI.

The analyst will work with mortgage datasets, supporting analytics and reporting efforts, while ensuring data accuracy and timely delivery of insights. Strong analytical thinking and attention to detail are essential for success in this position.

Qualifications

• 3+ years of experience in the U.S. mortgage domain.
• Strong SQL experience related to data reporting.
• Hands-on experience with BI/reporting tools.

Responsibilities

• Analyze U.S. mortgage datasets for reporting.
• Build and maintain dashboards for data visualization.
• Automate recurring reporting workflows.

Skills

SQL

Data analysis

Business intelligence tools

Attention to detail

Analytical thinking

Tools

Tableau

Power BI

Snowflake

Sigma Computing

Job description

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
• 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

• Perform data validation, cleansing, and reconciliation across multiple mortgage data sources
• Support development of curated datasets for analytics and reporting
• 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
• 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