INTERNSHIP DETAILS

Business Analytics Intern

CompanyNovacore
LocationConshohocken
Work ModeOn Site
PostedNovember 5, 2026
Internship Information
Core Responsibilities
The intern will build and maintain reports and dashboards in Power BI and Excel while writing SQL queries to manage data from the enterprise warehouse. They will also support data quality checks, document processes, and assist analysts with project testing and market research.
Internship Type
full time
Company Size
429
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
At Novacore, we’re transforming what it means to be an exceptional partner in specialty insurance. Headquartered in Conshohocken, PA, Novacore operates across 11 U.S. offices with over 500 insurance professionals, leading the way in Property & Casualty, Accident & Health, Reinsurance and through our retail agency, NSM Insurance Brokers. Formerly the U.S. commercial division of NSM Insurance Group, Novacore has entered a bold new chapter — fueled by a single mission: to help our agent partners thrive. With a portfolio of 20+ high-performing programs, a network of 20,000+ agents, and over $1.5B in premium, we deliver customized solutions for complex, hard-to-place risks. Our momentum is powered by continued investment in smart technology, real-time analytics and scalable operations — all designed to help agents quote faster, work smarter and grow stronger. We bring 35 years of underwriting expertise, strong carrier partnerships and a reputation for outstanding service to every interaction. And while our name is new, our trusted team and unwavering commitment to agents remain unchanged. Here’s what sets Novacore apart: Faster, easier quoting Streamlined workflows Next-generation tools Stronger support at every step We proudly serve niche industries nationwide, including: Addiction treatment & behavioral health Coastal condos Commercial & residential contractors Employer stop loss & managed care Facultative reinsurance Habitational & community associations Nonprofits & social services Owner-operators & specialty transportation Professional liability School bus contractors Sports & wellness Staffing agencies Towing & garage Workers’ compensation
About the Role


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 Intern

We 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

Key Skills
Business analyticsPower BIExcelSQLData warehousingData qualityUnderwritingClaims analysisFinancial reportingProcess mappingMarket researchBenchmarkingAnalytical thinkingAttention to detailCommunication skills
Categories
Data & AnalyticsFinance & AccountingTechnology
Benefits
Paid internshipMentorshipProfessional developmentNetworking eventsVolunteer opportunities