Data Analyst Intern

Credit91; Gurugram District; On-site; INR 254,000 - 304,000; Full time

Job summary

Credit91, a digital lending platform in India, is offering a 6-month full-time Data Analyst Intern role based in Gurugram. You will build dashboards, run SQL queries, and generate MIS reports to support decision-making across operations, underwriting, and product teams.

You will work hands-on with Excel/Google Sheets, Python for data cleaning, and BI tools like Metabase to reveal insights on customer journeys, loan performance, and marketing attribution. Immediate joining preferred.

Qualifications

• Proven ability to create dashboards and MIS reports.
• Experience with data analysis in fintech / digital lending is a plus.
• Comfortable working with cross-functional teams and stakeholders.

Responsibilities

• Create and maintain business dashboards using Metabase / BI tools.
• Write SQL queries to extract, clean, and analyze data from internal databases.
• Prepare daily, weekly, and monthly MIS reports for management.
• Analyze customer journey funnels, drop-offs, approvals, disbursals, repayments, and collections.
• Track key business metrics such as lead conversion, KYC completion, loan approval rate, disbursal rate, repayment behavior, DPD, and collection efficiency.
• Work with operations and business teams to identify process gaps and improvement areas.
• Support marketing attribution analysis across campaigns, affiliates, and UTM sources.
• Assist in portfolio analysis, borrower segmentation, and risk trend identification.
• Use Excel / Google Sheets for quick analysis, reconciliations, and reporting.
• Use Python where required for data cleaning, automation, and deeper analysis.
• Help improve data quality by identifying missing, incorrect, or inconsistent data.
• Convert business requirements into clear reports, dashboards, and actionable insights.

Skills

Excel / Google Sheets

SQL

Metabase / BI tools

Python for data analysis

Data cleaning & reporting

Ability to work with large datasets

Communication skills

Attention to detail

Tools

Metabase

Python (Pandas)

Job description

Duration: 6 months (Full-time Internship)

Stipend: Up to ₹25,000 / month

Mode: Work from Office (Immediate)

About Credit91

Credit91 is a digital lending platform focused on building fast, data-driven, and technology-enabled credit products for Indian consumers. We work across lending operations, underwriting, collections, customer journey analytics, marketing attribution, and portfolio monitoring.

We are looking for a Data Analyst Intern who can help us build strong reporting, analytics, and data systems across the business.

About the Role

As a Data Analyst Intern, you will work closely with the business, operations, underwriting, collections, and product teams to analyze data, create dashboards, identify trends, and support decision-making.

This is a hands-on role suitable for someone who is comfortable working with data, enjoys solving business problems, and wants exposure to the fintech / digital lending industry.

Key Responsibilities

• Create and maintain business dashboards using Metabase / BI tools.
• Write SQL queries to extract, clean, and analyze data from internal databases.
• Prepare daily, weekly, and monthly MIS reports for management.
• Analyze customer journey funnels, drop-offs, approvals, disbursals, repayments, and collections.
• Track key business metrics such as lead conversion, KYC completion, loan approval rate, disbursal rate, repayment behavior, DPD, and collection efficiency.
• Work with operations and business teams to identify process gaps and improvement areas.
• Support marketing attribution analysis across campaigns, affiliates, and UTM sources.
• Assist in portfolio analysis, borrower segmentation, and risk trend identification.
• Use Excel / Google Sheets for quick analysis, reconciliations, and reporting.
• Use Python where required for data cleaning, automation, and deeper analysis.
• Help improve data quality by identifying missing, incorrect, or inconsistent data.
• Convert business requirements into clear reports, dashboards, and actionable insights.

Required Skills

• Strong working knowledge of Excel / Google Sheets.
• Basic to intermediate knowledge of SQL.
• Familiarity with Metabase or any BI/dashboarding tool.
• Basic knowledge of Python for data analysis is preferred.
• Understanding of data cleaning, filtering, joins, aggregations, and reporting.
• Ability to work with large datasets.
• Strong analytical and problem-solving skills.
• Good communication skills and ability to explain insights clearly.
• Attention to detail and comfort with numbers.
• Willingness to work from office in Udyog Vihar Phase 4, Gurugram.

Good to Have

• Prior internship or project experience in analytics.
• Experience with Python libraries such as Pandas / NumPy.
• Basic understanding of fintech, lending, credit, or collections.
• Familiarity with dashboards, cohort analysis, funnel analysis, or business reporting.
• Ability to automate recurring reports.

Ideal Candidate

We are looking for someone who is:

• Curious and data-driven.
• Comfortable with Excel, SQL, dashboards, and business metrics.
• Able to work independently with minimal hand-holding.
• Detail-oriented and structured in their work.
• Interested in fintech, lending, analytics, and business operations.
• Comfortable working in a fast-paced startup environment.

What You Will Learn

• Real-world fintech and digital lending analytics.
• SQL-based business reporting.
• Customer funnel and journey analysis.
• Loan portfolio and collections analytics.
• Marketing campaign and attribution analysis.
• How data is used in business, risk, operations, and management decisions.
• Role Type: Paid Internship
• Duration: 6 months
• Stipend: Up to ₹25,000 per month
• Mode: Work from Office
• Joining: Immediate / early joiners preferred