Policy Admin App Support

Oliver James Group; United States; Hybrid; USD 83,000 - 131,000; Full time

Job summary

Oliver James Group is seeking a hands-on Technical Specialist to support and enhance P&C policy administration systems. The role focuses on strong SQL Server expertise, writing and tuning complex queries, and supporting a new policy platform.

The candidate will maintain current systems while contributing to data migration, testing, and production support for the upcoming policy administration platform, collaborating with stakeholders and external vendors.

Qualifications

• Intermediate/advanced SQL Server / T-SQL skills with complex queries and tuning.
• Experience supporting P&C policy administration systems and processes.
• Understanding of policy issuance, endorsements, renewals, billing, and cancellations.
• Experience with application issues, root cause analysis, and data migration readiness.
• Strong communication with technical and business stakeholders.

Responsibilities

• Develop, maintain, and optimize SQL Server queries, procedures, views, and scripts.
• Investigate and resolve complex data and application issues in P&C systems.
• Support configuration changes to rating tables, rules, workflows, and forms.
• Assist in implementing a new policy administration platform, including data migration.
• Troubleshoot data flows between policy systems and enterprise apps.
• Collaborate with stakeholders, developers, and vendors to resolve issues.
• Support ongoing improvements, documentation, and change management.

Skills

SQL Server / T-SQL

Query optimization

Stored procedures

Data troubleshooting

P&C policy administration knowledge

Stakeholder communication

Tools

Guidewire

Duck Creek

Majesco

Insurity

OneShield

BriteCore

Job description

Technical Specialist - P&C Insurance Applications & SQL Server

Location: Remote / Hybrid (TBD) Employment Type: Contract-to-Hire

Overview

We are partnering with an established insurance organization seeking a hands-on Technical Specialist to support and enhance its Property & Casualty (P&C) policy administration systems.

This position requires strong Microsoft SQL Server expertise, particularly in writing, troubleshooting, and optimizing complex SQL queries and stored procedures, alongside experience supporting and configuring insurance policy administration platforms.

The successful candidate will play a key role in maintaining existing systems while contributing to the implementation and integration of a new policy administration platform.

Key Responsibilities

• Develop, maintain, and optimize SQL Server queries, stored procedures, views, and database scripts to support business operations, reporting, and troubleshooting.
• Investigate and resolve complex application and data-related issues within P&C policy administration systems.
• Support configuration changes involving rating tables, business rules, workflows, forms, and policy administration processes.
• Contribute to the implementation of a new policy administration platform, including data migration, reconciliation, testing, and production support.
• Troubleshoot integrations and data flows between policy administration systems and other enterprise applications.
• Collaborate with business stakeholders, developers, and external vendors to identify and resolve technical issues.
• Support ongoing application improvements, documentation, and change management.

Required Experience

• Intermediate / Advanced Microsoft SQL Server / T-SQL skills, including extensive experience developing, modifying, debugging, and performance-tuning stored procedures, complex queries, views, joins, and CTEs.
• Strong understanding of relational databases, data structures, and SQL performance optimization.
• Experience supporting, configuring, or troubleshooting P&C insurance policy administration systems.
• Good understanding of P&C insurance processes, including policy issuance, endorsements, renewals, cancellations, and billing.
• Experience investigating production application issues and performing root cause analysis.
• Exposure to application implementations, system migrations, or major platform upgrades.
• Strong communication skills and ability to work directly with technical and business stakeholders.

Desirable Experience

• Experience with platforms such as Guidewire, Duck Creek, Majesco, Insurity, OneShield, BriteCore, or similar.
• Familiarity with application integrations, REST APIs, and data migration processes.
• Experience with scripting or automation tools such as Python or PowerShell.
• Exposure to AI-assisted development tools and modern enterprise technologies.

This is an excellent opportunity for a technically strong SQL Server specialist with P&C insurance experience to take ownership of business-critical applications and contribute to a significant platform modernization initiative.