Claims Data Analyst (Hybrid)

Selective Insurance Company of America; Short Hills (NJ); On-site; USD 83,000 - 108,000; Full time

Job summary

Selective Insurance Company seeks a skilled Analytics/Reporting professional to partner with Claims leadership and drive a robust reporting suite. You will build dashboards with Power BI and Cognos, delivering monthly packages for Staff Counsel and executives.

You will analyze data, develop descriptive metrics, and train teams on new processes while collaborating with cross-functional stakeholders to uncover efficiencies and cost improvements.

Qualifications

• Bachelor’s Degree preferred or 5+ years of analytics experience.
• Experience with BI tools such as Power BI, Cognos, or related platforms.
• Knowledge of claims financial/transactional platforms and databases.

Responsibilities

• Develop and maintain claims reporting platforms and dashboards using Power BI and Cognos.
• Establish a monthly claims legal/operational reporting package with dashboards, scorecards, and reports.
• Support ad-hoc analytical requests from management platforms and databases.
• Analyze audit data on law firms and vendor performance; identify cost-saving opportunities.
• Perform descriptive analytics and create executive summaries with charts and graphs.
• Document data extraction/ cleaning processes and train staff on new processes.
• Educate end users and scale Claims platforms; assess impact of tech changes.
• Collaborate with cross-functional stakeholders and participate in meetings as needed.

Skills

Claims platforms

Collaboration

Time management

Excel

PowerPoint

Cognos analytics

Attention to detail

P&C knowledge

Education

Bachelor’s Degree

Tools

Power BI

Cognos

Excel

Team Connect

Legal X

Job description

About Us

At Selective, we don't just insure uniquely, we employ uniqueness. Selective is a midsized U.S. domestic property and casualty insurance company with a history of strong, consistent financial performance for nearly 100 years. Selective's unique position as both a leading insurance group and an employer of choice is recognized in a wide variety of awards and honors, including listing in Forbes Best Midsize Employers in 2025 and certification as a Great Place to Work® in 2025 for the sixth consecutive year. Employees are empowered and encouraged to Be Uniquely You by being their true, unique selves and contributing their diverse talents, experiences, and perspectives to our shared success. Together, we are a high-performing team working to serve our customers responsibly by helping to mitigate loss, keep them safe, and restore their lives and businesses after an insured loss occurs.

Overview

Partner closely with the Claims leadership team and other functions within Claims to develop reports, metrics, and dashboards that support Staff Counsel and potentially the larger claims organization initiatives. Build, update, and maintain a claims operations reporting suite and deliver on several high-impact and high-visibility analytical projects for both the Claims and the Executive Leadership Teams. All job duties and responsibilities must be carried out in compliance with applicable legal and regulatory requirements.

Responsibilities

• Develop and maintain subject matter expertise for all claims reporting platforms and delivery methods, including but not limited to advanced functionality and content.
• Establish and maintain a monthly claims legal, operational reporting package that includes a dashboard, scorecards, and reports utilizing Power BI, Cognos, Microsoft Excel, and legal platforms.
• Support the claims team with ad-hoc analytical requests from management platforms such as Team Connect, Legal X, and claims financial/transactional platforms and databases.
• Compile and analyze audit data relating to law firm performance and litigation support vendor performance. Provide creative alternatives and recommendations to reduce costs and improve financial performance, including opportunities for Staff Counsel efficiencies.
• Perform descriptive analytics by producing and analyzing metrics and identifying data trends. Develop tables, charts, and graphs, including executive summaries for Executive Leadership.
• Develop and document processes and techniques to extract, clean, and analyze data. Conduct training, including developing user procedures, guidelines, and documentation. Train the various Claims teams and new system users on new processes/functionality.
• Educate end users on the various claims platforms. Seek out opportunities to scale Claims platforms and flag opportunities for efficiencies. Conduct impact analysis of technology changes on business processes and existing technology.
• Leverage effective facilitation and collaboration skills to partner with cross-functional stakeholders.
• Attend team meetings, roundtables, depositions, trials, etc., as needed.

Qualifications

Knowledge and Requirements

• Knowledge of claims financial/transactional platforms and databases
• Demonstrated ability to build and maintain strong, collaborative relationships
• Strong organizational, time management, and project prioritization skills
• Excellent written communication skills; ability to clearly express thoughts and ideas through documentation
• Expert proficiency in most standard business software applications, especially Excel and PowerPoint
• Ability to generate reports and build dashboards utilizing Cognos analytics
• Meticulous attention to detail
• Property and Casualty industry knowledge

Education and Experience

• Bachelor’s Degree preferred or 5+ years of experience developing analytics, reporting and providing actionable recommendations driven by data.
• Experience working with business intelligence tools such as Power BI, Cognos, or various claims management platforms.

Total Rewards

Selective Insurance offers a total rewards package that includes a competitive base salary, incentive plan eligibility at all levels, and a wide array of benefits designed to help you and your family stay healthy, achieve your financial goals, and balance the demands of your work and personal life. These benefits include comprehensive health care plans, retirement savings plan with company match, discounted Employee Stock Purchase Program, tuition assistance and reimbursement programs, and 20 days of paid time off. Additional details about our total rewards package can be found by visiting our benefits page. The actual base salary is based on geographic location, and the range is representative of salaries for this role throughout Selective's footprint. Additional considerations include relevant education, qualifications, experience, skills, performance, and business needs.

Pay Range

USD $83,000.00 - USD $108,000.00 /Yr.

Additional Information

Selective is an Equal Employment Opportunity employer. That means we respect and value every individual’s unique opinions, beliefs, abilities, and perspectives. We are committed to promoting a welcoming culture that celebrates diverse talent, individual identity, different points of view and experiences – and empowers employees to contribute new ideas that support our continued and growing success. Building a highly engaged team is one of our core strategic imperatives, which we believe is enhanced by diversity, equity, and inclusion. We expect and encourage all employees and all of our business partners to embrace, practice, and monitor the attitudes, values, and goals of acceptance; address biases; and foster diversity of viewpoints and opinions.

For Massachusetts Applicants It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.