Business Intelligence Analyst

Location: Gurugram / Bengaluru Business Unit: NBFC / Lending Experience: 2–5 years We’re looking for a Business Intelligence Analyst who can transform large volumes of transactional, financial, and behavioural data into actionable business insights. You will own business metrics across secured and unsecured lending, build scalable data models and dashboards, and work closely with Growth, Product, Business, Risk, Finance, and Engineering teams. The role requires strong technical expertise in SQL, Python, PySpark, AWS, and large-scale data processing, with the ability to translate complex data into business decisions. What You’ll Do Own business metrics end to end. Define and maintain a single source of truth for KPIs across lending, including AUM, disbursements, collection efficiency, loan book growth, approval rates, portfolio quality, delinquency, NPA, revenue, profitability, CAC, and LTV. Build business intelligence dashboards using Redash to provide actionable insights to product, growth, risk, finance, and leadership teams. Process and analyse large volumes of data using SQL, Python, and PySpark across transactional and financial data systems. Build scalable data pipelines leveraging AWS services, Redshift, S3, SQS, SNS, Kafka, and Debezium for data ingestion, transformation, and analytics. Perform deep-dive analysis across customer onboarding, KYC, loan sourcing, credit assessment, approval, disbursement, repayment, and collection journeys to identify business opportunities and operational bottlenecks. Develop statistical and regression models to identify business trends, analyse portfolio performance, understand customer behaviour, and support risk and business decisions. Ensure data accuracy and reliability. Implement data quality checks, financial reconciliations, and monitoring for data completeness, consistency, and freshness. Partner with business and engineering teams to translate business requirements into analytical solutions, data models, and scalable reporting systems. Support regulatory and financial reporting while ensuring data accuracy, auditability, and compliance with applicable RBI and data privacy requirements. Leverage AI tools to improve analytical productivity, automate reporting, and accelerate query development and insight generation. Maintain documentation for business metrics, data models, data pipelines, and dashboards. What We’re Looking For Must-haves 2–5 years of experience in Business Intelligence, Data Analytics, or Data Engineering, preferably in fintech, NBFC, lending, or financial services. Strong SQL expertise , including complex queries, CTEs, window functions, query optimisation, and large-scale data analysis. Strong Python and PySpark skills for data processing, transformation, analysis, and automation. Hands-on experience with AWS, Amazon Redshift, Airflow, S3, SQS, and SNS . Practical experience with Kafka and Debezium for event-driven data ingestion and Change Data Capture (CDC). Hands-on experience building dashboards and reports using Redash or similar BI tools. Experience handling and analysing large-volume datasets with a strong understanding of performance optimisation and scalable data processing. Understanding of statistical concepts, hypothesis testing, cohort analysis, and regression models . Strong understanding of financial and lending metrics such as AUM, disbursements, interest income, loan outstanding, delinquency, NPA, and portfolio performance. Strong analytical thinking, problem-solving, and communication skills with the ability to convert business requirements into actionable insights. Good to have Experience with Golang, PostgreSQL, and GraphQL . Exposure to AWS data engineering and analytics services beyond the core stack. Familiarity with Mixpanel or other product analytics platforms. Experience working with NBFCs, secured lending, unsecured lending, Loan Against Mutual Funds, or other financial products. Knowledge of RBI regulatory reporting, financial reconciliations, and audit requirements. Experience using LLMs and AI tools for analytics automation and business intelligence. Show more Show less