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