Business Analytics Intern

Novacore; Conshohocken (Montgomery County); Hybrid; USD 25,000 - 30,000; Part time

Job summary

Novacore invites high-performing college students to join our 2027 Summer Internship Program in Business Analytics. This paid internship offers hands-on experience with underwriting, claims and finance analytics, plus mentorship and executive visibility.

The program runs May 17th through August 5th and is a hybrid role with 3 days onsite at our Conshohocken, PA office and 2 days remote. We’ll train on SQL and Power BI as needed.

Qualifications

• Sophomore or Junior, preferred.
• Majors such as Data Analytics, Statistics, Information Systems, Finance, Math or Risk Management.
• Excel (intermediate, required). SQL and Power BI training available.
• Strong attention to detail and analytical thinking.
• Able to work independently across deadlines and collaborate with a team.

Responsibilities

• Build and maintain reports and dashboards in Power BI and Excel for underwriting, claims and finance stakeholders.
• Write SQL queries to pull, clean and validate data from our enterprise data warehouse.
• Support data quality checks by reconciling figures between source systems and reports.
• Document data definitions, report logic and processes (process maps, requirement notes).
• Assist analysts on active projects, including testing new reports and data feeds and validating outputs meet requirements.
• Conduct market and benchmarking research to support program performance analysis.

Skills

Excel

SQL

Power BI

Education

Sophomore or Junior

Majors: Data Analytics, Statistics, Information Systems, Finance, Math, or Risk Management

Tools

Excel

SQL

Power BI

Job description

Why join the Novacore team? Because your next stellar chapter starts here — and we’re building something bold and meaningful.

At Novacore, we’re not your average insurance company. We’re a team of driven professionals passionate about redefining the specialty insurance experience for our agents, carrier partners — and for each other.

We specialize in tailored solutions for niche industries, powered by advanced analytics, modern technology and a culture of innovation. Backed by strong leadership and strategic growth initiatives, Novacore is poised to scale and lead in the specialty insurance market.

But at our core, we believe it’s not just what we do — it’s how we do it and who we do it with.

Recognized as a top workplace, Novacore is a place where ambition is supported, growth is continuous and culture matters. From day one, you’ll find mentorship, hands‑on learning and clear paths for advancement. You’ll grow your skills, expand your expertise and become even more exceptional — because when you succeed, we all do.

We offer:

• A collaborative, results‑driven environment
• Competitive compensation and comprehensive benefits
• Year‑round social and community events
• Ongoing mentorship and professional development
• Endless opportunities for upward mobility

So if you're ready to be part of something extraordinary — with a team that’s transforming commercial insurance — we want to meet you.

Business Analytics InternWe are currently seeking high-performing college student(s) interested in learning and gaining hands‑on experience within Business Analytics to join Novacore’s 2027 Summer Internship Program.

All internship opportunities are paid and offer mentorship, peer interaction, project work, executive visibility, volunteer opportunities, and networking events.

Our internship program will run from May 17th through August 5th.

This is a hybrid internship with 3 days required onsite at the Conshohocken, PA, Home Office and 2 days’ work from home.

Responsibilities:

• Build and maintain reports and dashboards in Power BI and Excel for underwriting, claims and finance stakeholders.
• Write SQL queries to pull, clean and validate data from our enterprise data warehouse.
• Support data quality checks by reconciling premium, exposure and loss figures between source systems and reports.
• Document data definitions, report logic and processes (process maps, requirement notes).
• Assist analysts on active projects, including testing new reports and data feeds and validating outputs meet requirements.
• Conduct market and benchmarking research to support program performance analysis.

Qualifications:

• Sophomore or Junior, preferred
• Majors such as Data Analytics, Statistics, Information Systems, Finance, Math or Risk Management
• Systems preferences: Excel (intermediate, required). SQL and Power BI are a plus, not a requirement. We'll train on both
• Strong attention to detail and analytical thinking
• Comfortable working independently across multiple deadlines, and curious about how insurance data drives decisions
• Strong verbal and written communication skills
• Thrives in a fast-paced environment, learns new tools quickly, and works well on a team