Business Intelligence Analyst II

Overview

At Novacore, we’re entering an exciting new chapter. Novacore is the newly formed specialty insurance entity created from the April 2025 sale of NSM Insurance Group’s U.S. commercial division. While we carry forward a 35-year legacy of deep industry expertise, we’re transforming what commercial insurance can be. The name Novacore reflects our ambition — nova for new and brilliant, core for strength and purpose. We’re building something bold and meaningful, and every team member plays a vital role in that mission.

With more than $1.3 billion in premium across 15+ specialty insurance programs, we’re transforming the commercial insurance experience — delivering exceptional value to our agent partners and customers through smarter, faster and more collaborative ways of doing business. We specialize in tailored Property & Casualty and Accident & Health insurance solutions for niche industries, powered by advanced analytics, modern technology and a commitment to innovation at every level. Backed by strong leadership and a fresh vision, we’re bringing together the best of our past with bold new ideas to shape the future of specialty insurance.

With a renewed focus, Novacore is positioned to grow and expand through strategic mergers and acquisitions — and to lead the way in the commercial insurance space.

The BI Analyst II plays a pivotal role in shaping the future of the specialty insurance industry.

As a BI Analyst II, you will work closely with cross-functional teams—underwriting, claims, IT, and Segment Presidents—to deliver actionable insights, build scalable data solutions, and support the development of predictive models and AI-powered tools. You’ll be responsible for refining our reporting infrastructure, identifying trends, and contributing to the design of data strategies that align with our evolving digital transformation roadmap. **This is a hybrid position, working from the Conshohocken, PA Home Office**

Responsibilities

• Promote use of new metrics and data visualization tools/techniques to make recommendations of operational adjustments/changes that may be needed to improve results.
• Monitor established KPIs across Novcore’s commercial lines and proactively meet business stakeholders to stay informed about current business goals, initiatives and provide insights based on data.
• Perform quantitative and qualitative analysis on available data, metrics, trends. Enhance existing models and reports to identify meaningful insights/opportunities to business stakeholders to help grow the business. 
• Synthesize financial, sales, underwriting, claims and CRM operational data to create actionable dashboards and professional presentations for key stakeholders e.g., divisional leadership, executive leadership, front line management, etc. to enable informed, data-based decision-making.
• Utilize SQL, R, or Python to query data from databases.
• Develop and/or enhance Power BI reports.
• Develop and/or enhance Azure ADF ETL pipelines.
• Perform ad-hoc queries/reports to provide support for special initiatives and business unit needs.
• Provide day-to-day support of existing analysis tools and uncover ideas about how to improve the design and capabilities of existing reports with segment leaders.

Qualifications

• Bachelors-degree in Data Analysis, Statistics, Finance, or other relevant analytical degree, preferred.
• 3+ years of experience utilizing SQL.
• 2+ years of experience developing ETL pipelines.
• 2+ years of experience utilizing data visualization tools such as Power BI, Qlik, Tableau, etc.
• 2+ years of providing analytical insights and developing summary decks to business stakeholders.
• Advanced understanding of data modeling and data warehousing concepts.
• Data analysis & trending experience with demonstrated proficiency in analytical methodologies, tools, and dashboard development to interpret, visualize, simplify and present/communicate data, analyses, results and findings.
• Demonstrated project management skills and ability to work independently to prioritize workload and handle multiple responsibilities, deadlines, etc.
• Strong organizational, problem-solving, and critical thinking abilities. 
• High attention to detail to identify, evaluate and resolve data quality issues and reasonability check analytical results.
• Ability to build relationships and communicate effectively with senior leaders across the organization.
• Excellent oral presentation and written communication skills.
• Preferred:
  • Insurance industry experience.
  • Exposure to Azure technology stack.
  • Exposure to statistical languages such as R/Python.