Pointo Logo

Pointo

Data Analyst

Posted One Month Ago
In-Office
Bengaluru, Karnataka, IND
Mid level
In-Office
Bengaluru, Karnataka, IND
Mid level
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.
The summary above was generated by AI
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

3 Days Ago
Easy Apply
In-Office
Bangalore, Bengaluru Urban, Karnataka, IND
Easy Apply
Entry level
Entry level
Cloud • Security • Software • Cybersecurity • Automation
The Staff Data Analyst will transform data into insights for GitLab’s Support Engineering organization. Responsibilities include capacity and budget modeling, utilization scorecards, support economics analysis, performance indexes, AI adoption ROI dashboards, predictive churn analytics, customer-schema standardization, executive reporting, and ad hoc analysis. The role partners with Support Engineering, go-to-market, Business Operations, and Product Engineering in a remote environment.
Top Skills: Artificial IntelligenceLarge Language ModelsLookerMachine LearningSQLTableauZendesk Explore
24 Days Ago
In-Office
Bengaluru, Bengaluru Urban, Karnataka, IND
Junior
Junior
Food • Greentech • Logistics • Sharing Economy • Transportation • Agriculture • Industrial
Analyzes moderately complex datasets to support corporate audit objectives, including control effectiveness, operational and IT risk assessment, anomaly detection, and audit findings. Builds automated reports, dashboards, and visualizations; validates data accuracy and integrity; identifies process improvements; and collaborates with auditors, data engineering, and technology teams. Requires knowledge of audit, risk, Finance or IT processes, with preferred experience in Power BI, Tableau, SQL, Python, ERP systems, and AI tools.
Top Skills: ChatgptClaudeLarge Language Models (Llms)Microsoft CopilotMicrosoft Power BiOraclePythonSAPSQLTableau
2 Days Ago
In-Office or Remote
Bengaluru, Bengaluru Urban, Karnataka, IND
Entry level
Entry level
Agency • Marketing Tech
Build and maintain Power BI finance and FP&A dashboards, semantic models, datasets, and DAX calculations. Transform and validate data from Dataverse, Cosmos DB, and enterprise systems using Power Query and SQL. Develop reporting on revenue, profitability, budgets, forecasts, costs, and variance analysis. Ensure data quality, governance, security, and performance while documenting reporting logic. Partner with Finance, FP&A, Data, Technology, and commercial teams to translate business requirements into scalable insights and automate reporting processes.
Top Skills: Azure Cosmos DbAzure SqlCi/CdCosmos DbDataflowsDaxDynamics 365Fabric LakehouseMicrosoft DataverseMicrosoft FabricPower BIPower Bi ServicePower QuerySQLSQL Server

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.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account