Data Analyst Intern

- Conduct analytical deep-dives such as funnel analysis, cohort tracking, branch-wise performance reviews, TAT analysis, portfolio diagnostic, and credit risk analytics to derive actionable insights. - Collaborate with stakeholders to translate business questions into measurable analyses and communicate the findings effectively. - Assist in digital underwriting initiatives by developing and analyzing underwriting APIs for borrower eligibility and exposure sizing decisions. - Create and maintain periodic MIS and KPI reporting for key business functions like pipeline, disbursals, TAT, conversion rates, collections performance, and portfolio trends. - Utilize Python (pandas, numpy) for data cleaning, transformation, and analysis, automate recurring reports, and data workflows. - Perform basic scripting to support data validation, extraction, and lightweight automation processes. Required Skills and Qualifications: - Strong proficiency in Excel, including pivots, lookup functions, data cleaning, and structured analysis. - Solid working knowledge of SQL, including joins, aggregations, CTEs, and window functions. - Proficiency in Python for data analysis (pandas, numpy) with the ability to write clean, maintainable scripts and notebooks. - Strong logical reasoning, attention to detail, and the capability to identify errors and validate results rigorously. - Ability to work with ambiguous requirements and imperfect datasets while ensuring output quality. Preferred (Good to Have): - Knowledge of REST APIs and previous experience with API development/integrations. - Familiarity with basic AWS tools/services such as S3, lambda, EC2, and Glue Jobs. - Experience with Git and basic engineering practices. - Any exposure to the lending/finance industry would be advantageous. Join Optimo Capital to embark on a journey of learning, growth, and impactful contributions in a fast-paced startup environment where your skills, attitude, and hunger to excel are valued.