Analytics Intern: Power BI & SQL for Insurance Data

Novacore Insurance Services, LLC; Conshohocken (Montgomery County); Hybrid; USD 22,000 - 30,000; Part time

Benefits offered by this job

Paid internship

Mentorship

Executive visibility

Networking events

Volunteer opportunities

Job summary

Novacore Insurance Services, LLC in Conshohocken, PA invites ambitious college students to join its 2027 Summer Internship Program in Business Analytics. This paid internship offers hands-on experience, mentorship from analytics professionals, peer collaboration, project work, executive visibility, volunteer opportunities, and networking events.

The internship runs May 17 through August 5 and is hybrid: three days onsite at the Conshohocken Home Office and two days remote.

Qualifications

• Sophomore or Junior student majoring in data analytics, statistics, information systems, finance, math, or risk management.
• Excel (intermediate, required).
• SQL and Power BI are a plus, not required.
• Strong attention to detail and analytical thinking.
• Strong verbal and written communication skills.
• Thrives in a fast-paced environment and works well on 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 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.

Skills

Attention to detail

Analytical thinking

Communication skills

Team player

Independent working

Education

Sophomore/Junior student

Tools

Excel

SQL

Power BI

Job description

Novacore Insurance Services, LLC in Conshohocken, PA invites ambitious college students to join its 2027 Summer Internship Program in Business Analytics. This paid internship offers hands-on experience, mentorship from analytics professionals, peer collaboration, project work, executive visibility, volunteer opportunities, and networking events.

The internship runs May 17 through August 5 and is hybrid: three days onsite at the Conshohocken Home Office and two days remote.