Build dashboards, KPI tracking systems, automated reports, and ad hoc analyses for collections, payments, risk, finance, and customer operations. Ensure data quality through audits, reconciliation, schema documentation, and lineage tracking. Collaborate with Engineering on ingestion pipelines, data warehouse design, ETL improvements, query optimization, and scalability. Communicate actionable insights to technical and non-technical stakeholders.
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
Similar Jobs
Gaming
Own analytics for Words With Friends Instant, providing insights on player behavior, product performance, experimentation, revenue, retention, and engagement. Design statistical experiments, dashboards, telemetry, and ETL pipelines; analyze trends and feature health; maintain data tools and models; and communicate recommendations to product, engineering, design, and executive stakeholders. The role also supports AI initiatives and optimization of the player experience.
Top Skills:
A/B TestingData VisualizationETLGitMachine LearningPythonSQLTableau
Fintech • Information Technology • Financial Services
Conducts secondary research and analyzes private-market companies, deals, ownership structures, valuations, and corporate events. Builds structured intelligence, resolves conflicting or incomplete information, identifies new companies and investor relationships, and maintains data quality and evidence-backed documentation. Uses AI-assisted research tools and collaborates with global data, product, and engineering teams.
Top Skills:
Ai-Assisted Research ToolsCopilotExcelMicrosoft Office 365PythonSharepointSQL
Gaming
Analyze large player datasets to identify opportunities, improve game metrics, and support evidence-based decisions. Build dashboards and maintain trusted data sources, communicate insights to technical and non-technical stakeholders, and collaborate with product, design, and engineering teams. Design, test, verify, and help deploy machine learning models and product features at scale. Deliver impactful analytics and data science projects aligned with product roadmaps.
Top Skills:
SparkHadoopPythonQlikviewSQLTableau
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
