We’re looking for a curious, detail-oriented Analytics Intern to join our Data & Analytics team for the summer. You’ll work with real lending data, including applications, approvals, payments, and delinquency, to answer business questions, build reporting, and support decisions that affect thousands of borrowers. You’ll partner with Engineering, QA, Product, and Operations, and you’ll finish the summer with projects you can point to.

Write and run SQL queries against our Azure SQL / SQL Server and Microsoft Fabric lakehouse to answer business questions, investigate issues, and build reports.

Build and maintain dashboards in Hex covering metrics such as the application-to-funded funnel, payment success rates, and delinquency trends.

Use Python (pandas, Jupyter/Hex notebooks) to clean, explore, and summarize data, and present findings to stakeholders in plain language.

Learn core lending metrics (vintages and cohorts, days-past-due buckets, roll rates, first-payment default) and apply them in your analysis.

Help measure borrower communication and marketing campaigns, including tracking results and supporting A/B test analysis.

Gather requirements from business stakeholders and translate them into clear specs and acceptance criteria for the development team.

Support data quality: flag anomalies, document data definitions in our data catalog, and help validate pipeline outputs.

Assist with vendor data and reporting relationships.

Tools You’ll Use

SQL (T-SQL), Microsoft Fabric / Azure Synapse, Hex, Python, Git / Azure DevOps, Hex, Claude, Jira and Confluence, and AI assistants for analysis and documentation.

Analytics Internship 2027

Responsibilities

Qualification

Required

Preferred

Company

Hive Financial Systems

More roles at Hive Financial Systems