Data & Analytics Intern

Divit Finance; Northern (KY); Hybrid; USD 50,000 - 80,000; Full time

Job summary

Divit Finance is seeking a data analyst to work with investments and operations teams to clean and analyze data and build dashboards that support underwriting and monitoring.

You will collect, clean, and normalize deal and portfolio data, create Excel templates, and contribute to KPI definitions and data quality checks. The role emphasizes independent work with clear documentation and opportunities to improve processes.

Qualifications

• Pursuing a quantitative degree (Statistics, CS, Engineering, Finance).
• Proficient with Excel; Python/SQL/BI tools a plus.
• Strong attention to detail and documentation discipline.
• Enjoy digging into messy data and structuring it.
• Able to explain analyses to non-technical teammates.

Responsibilities

• Collect, clean, and normalize deal and portfolio data.
• Build simple Excel templates and dashboards for recurring analyses.
• Assist with KPI definitions and data quality checks.
• Support ad-hoc analytics for diligence and portfolio reviews.
• Help define data dictionaries and naming conventions for consistency.
• Identify small process improvements to reduce manual work.

Skills

Excel

Python

SQL

BI tools

Attention to detail

Education

Quantitative degree in progress

Tools

Power BI

Data visualization

Job description

Work with the investments and operations teams to clean and analyzedata, and build simple dashboards that enable consistent underwriting and monitoring.

About the Role

What You’ll Do

• Collect, clean, and normalize deal and portfolio data
• Build simple Excel templates and dashboards for recurring analyses
• Assist with KPI definitions and data quality checks
• Support ad-hoc analytics for diligence and portfolio reviews
• Help define data dictionaries and naming conventions so datasets are consistent
• Identify small process improvements that reduce manual work for the team

What We Look For

• Progress toward a quantitative degree (Statistics, CS, Engineering, Finance)
• Comfort with Excel; bonus for Python/SQL/BI tools
• Attention to detail and documentation discipline
• Enjoy digging into messy data and figuring out how to structure it
• Ability to explain your analysis clearly to non-technical teammates
• Comfort working independently once scope is clear, while asking questions when needed

Nice to Have

• Experience with basic data visualization (e.g., Excel charts, simple dashboards)
• Exposure to finance, credit, or investing through coursework or projects
• Familiarity with version control or collaborative tooling for spreadsheets/code