Data Analyst

Role Overview

We are looking for a detail-oriented and analytical data analyst to build dashboards, reports, and analytics that drive business decisions across our operations. You'll work with SQL, BI tools, and cross-functional teams to deliver insights on collections efficiency, payment operations, and customer metrics.

Key Responsibilities

Core Analytics & Reporting

• Build and maintain dashboards and reports for Collections, Payments, Customer Onboarding, and Risk teams
• Create KPI tracking systems for daily/weekly/monthly reporting on collection status, payment success rates, and funnel metrics
• Develop automated reporting solutions to replace manual processes and reduce operational overhead
• Provide ad-hoc analysis to support business decisions and identify trends

Data Quality & Integration

• Own data quality across key systems (Collections, Payments, CRM, Payment Gateways)
• Audit and reconcile data across sources (Zoho, Payment Gateways, NBFC systems, EMI/Check processing)
• Identify and escalate data gaps and inconsistencies to Engineering
• Document data schemas, definitions, and data lineage for stakeholders

Analytics for Core Operations

• Support Collections team: build visibility into payment failure patterns, collection protest trends, and anomalies
• Support Risk/Credit team: analyze credit assessment gaps, onboarding funnel drop-offs, and customer lifecycle metrics
• Support Finance: reconcile vendor payments, identify discrepancies, and trace payment flows for audit trails
• Analyze Onboarding funnel performance and track improvement against targets

Data Infrastructure & Optimization

• Work with Engineering to improve data ingestion pipelines and reduce manual data maintenance
• Identify data scalability risks (e.g., cost drivers, query performance) and recommend optimizations
• Contribute to data warehouse/lake design decisions and ETL improvements

Mandatory Requirement (Critical)

• SQL Expertise: Write complex queries, optimize query performance, work with relational databases (PostgreSQL, MySQL, or similar)
• BI proficiency — Tableau, Metabase, Data Studio, Power BI, or equivalent
• Data Storytelling: Create clear, actionable dashboards and communicate findings to non-technical stakeholders
• Data Validation: Experience identifying data quality issues, performing audits, and reconciling data across systems
• Platforms: Zoho CRM, Payment gateways, internal dashboards
• Problem-solving mindset — break ambiguous questions into actionable analysis

Qualifications & Experience

• 4+ years of experience in data analysis, analytics engineering, or business intelligence
• Proven track record building dashboards and reports that drive business decisions
• Experience working directly with SQL databases in a production environment

Preferred Profile

• Experience in fintech, payments, lending, or collections: Experience with lending platforms, payment systems, or NBFC operations
• OR equivalent: Strong domain knowledge in B2B SaaS, e-commerce, or operations analytics where you've worked with complex financial workflows
• Proficiency in Python or R
• Familiarity with data warehousing (dbt, Airflow) or APIs
• Background in risk analytics or credit assessment