Analytics Internship 2027

hivefinancialsystems; Atlanta (GA); On-site; USD 28,000 - 41,000; Part time

Job summary

Hive Financial Systems in Atlanta, GA is seeking an Analytics Intern for Summer 2027 to work with real lending data, build reports, and support decisions that affect thousands of borrowers. You’ll partner with Engineering, QA, Product, and Operations and finish the summer with projects you can point to.

You will write SQL queries against Azure SQL / SQL Server and Microsoft Fabric lakehouse, build dashboards in Hex, and use Python to clean, explore, and summarize data, presenting findings to

Qualifications

• Junior, senior, or master's student in Information Systems, Data Analytics, Statistics, Computer Science, Finance, or a related field.
• Working knowledge of SQL (SELECT, JOIN, WHERE). Window functions or CTEs are a plus.
• Some exposure to Python or R for data analysis.
• Familiarity with relational database concepts.
• Strong problem-solving and critical-thinking skills.
• Clear written and verbal communication, including the ability to explain numbers to non-technical audiences.
• Ability to work both independently and collaboratively in a fast-paced environment.

Responsibilities

• Write and run SQL queries against Azure SQL / SQL Server to answer business questions and build reports.
• Build and maintain dashboards in Hex covering key metrics like application-to-funded funnel and delinquency trends.
• Use Python (pandas, Jupyter/Hex notebooks) to clean, explore, and summarize data and present findings.
• Learn lending metrics (vintages, cohorts, days-past-due buckets, roll rates, first-payment default) and apply them in analysis.
• Help measure borrower communications and marketing campaigns, including tracking results and A/B test analysis.
• Gather requirements from stakeholders and translate into clear specs for development.
• Support data quality by flagging anomalies and documenting data definitions in the data catalog.
• Assist with vendor data and reporting relationships.

Skills

SQL proficiency

Python

Data analysis

Communication

Collaboration

Education

Undergraduate/Grad student in Information Systems/Data Analytics/Statistics/Computer Science/Finance

Tools

Azure SQL / SQL Server

Microsoft Fabric / Azure Synapse

Hex

Git / Azure DevOps

Jira

Confluence

Claude AI assistants

Job description

Analytics Intern - Summer 2027

Location: Atlanta, Georgia (Buckhead)

Duration: May 17, 2027 - July 30, 2027

Department: Data & Analytics

About Us

Hive Financial Systems is a fintech company expanding financial inclusion through AI-driven lending technology. Our multi-portfolio loan management platform powers multiple lending partners serving tens of thousands of active consumers, building the infrastructure that makes responsible lending possible for underserved markets.

Role Overview

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.

What You'll Do

• 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.

Qualifications

• Junior, senior, or master's student in Information Systems, Data Analytics, Statistics, Computer Science, Finance, or a related field.
• Working knowledge of SQL (SELECT, JOIN, WHERE, GROUP BY). Window functions or CTEs are a plus.
• Some exposure to Python or R for data analysis.
• Familiarity with relational database concepts.
• Strong problem-solving and critical-thinking skills.
• Clear written and verbal communication, including the ability to explain numbers to non-technical audiences.
• Ability to work both independently and collaboratively in a fast-paced environment.

Nice to Have

• Experience with a BI tool (Hex, Power BI, Tableau, or similar).
• Interest in fintech, consumer lending, or credit risk.
• Exposure to cloud data platforms (Azure, Fabric, Snowflake, Databricks).
• Basic statistics, such as distributions, hypothesis testing, and A/B testing.

What You’ll Gain

• Hands-on experience with an enterprise lending data platform and real business problems.
• Practical skills in SQL, Python, BI, and business analysis.
• Mentorship from experienced engineering and analytics professionals.
• A portfolio-ready project presented to company leadership at the end of the summer.