SQL jobs

About Integrated Specialty Coverages

Integrated Specialty Coverages, LLC (ISC) is a growth stage technology and data-driven commercial insurance wholesaler leading innovation in the market.

Backed by one of the leading private equity firms, KKR, and led by a forward-thinking management team, ISC is combining the worlds of insurance and technology to create an Insurtech powerhouse. As a leading online distributor of insurance products for a range of industries and “Main Street USA”, we are looking for the right people to help us in our mission of achieving exponential growth. We strive to be the number one place to go for brokers and agents to source insurance. To accomplish this, we’re building a digitally focused team that deeply understands the intersection between user experience, data, and AI/ML to optimize the way we engage with our customers and partners.

Job Summary

The Commercial Lines Product Manager (CLPM) focuses on P&C insurance lines with complex, high-touch case underwriting, high limits of exposure and long-tailed loss profiles. The CLPM works closely with the underwriting business unit leaders, the company’s technology team, and the company’s finance and executive management to optimize MGA gross margin for the assigned P&C insurance programs through premium production, loss ratio management and operational efficiency. The CLPM has a thorough and comprehensive understanding of the coverages, rating mechanisms, business processes, systems and data for the assigned programs. The CLPM serves as a subject matter expert for policy data archived, transformed and reported using ISC’s data warehouse and business intelligence tools. The CLPM reports to the AVP of Product Management and Actuarial.

Position Responsibilities

• Develop and maintain product scorecards to monitor key product performance indicators, evaluate scorecards to identify trends in program performance, opportunities, and actionable recommendations. Compile results to share with Business Unit leaders and company management.
• Acquire Subject Matter Expertise on insured policy and claim data acquired by ISC and partner systems, including data retention and storage and reportability and visualization using ISC data warehouse and reporting tools. Use SQL, Python or other analytical applications to acquire, summarize and report policy, premium and loss data. Use data and information for reporting and analysis to develop insights, unearth opportunities, increase process efficiency and improve automation.
• Work with underwriting business unit leaders to manage the rating plans, including ISO advisory rates and independent pricing. Employ pricing strategies and direction to aid the business unit leaders. Monitor and summarize premium and exposure trends and underwriter discretionary rating activity at the portfolio level. Analyze program metrics, underwriting insights and market environment to identify price segmentation opportunities. Lead the implementation efforts in conjunction with the Tech team.
• Work with underwriting business unit leaders to manage the policy forms kits, including ISO, carrier-specific and proprietary policy forms and applications. Lead the implementation efforts in conjunction with the Tech team.
• Work with underwriting business unit leaders and tech team to identify and describe requirements to streamline, structure and automate new and renewal underwriting and policy issuance processes applicable to agents or underwriters. Evaluate third-party data sources which may improve process efficiency or risk assessment.
• Work with ISC tech team to ensure loss runs from claims TPAs are properly ingested, archived and reported. Analyze loss results with appropriate considerations for statistical credibility and loss development maturity.
• Develop a detailed understanding of key competitors and market segments. Evaluate ISC competitive advantages and identify opportunities to exploit them. Expose competitive gaps and work to close them through product enhancements.
• Work with underwriting business unit leaders to optimize financial results by balancing production, loss ratio, and agency commission and fees.

Minimum Qualifications

• Bachelor's degree required, Quantitative discipline preferred
• 2-3 years P&C insurance product management experience, or 3-5 years P&C insurance Product Analyst experience.
• Familiarity with P&C insurance policy and claims work processes and P&C insurance data and relevant metrics.
• Experience with commercial lines rating plans using ISO loss costs or proprietary rating plans.
• Expertise in insurance pricing strategies, particularly within the property and casualty insurance space.
• Demonstrated process analysis and automation competency.
• Strong analytical and data skills. Excel power user. Experience with SQL, Python or other data extraction and reporting tools to acquire policy and premium data from data warehouse tables.
• Working knowledge of actuarial fundamentals including loss development triangles, rate level indications, premium trends, loss trends and credibility.
• Exceptional communication and interpersonal skills are required to collaborate with underwriters and other domain experts, brief executives and external partners and develop actionable recommendations for product and process innovations.

This role also offers bonus pay. Your ISC Talent Acquisition representative will share more details about the bonus component should you advance in the interview process.

The starting annual pay scale for this position is listed below. Actual starting pay will be based on factors such as skills, qualifications, training, and experience. In addition, the company offers comprehensive benefits including medical, dental and vision insurance, 401(k) plan with match, paid time off, and other benefits.

ISC's salary ranges are determined by role and level. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations and could be higher or lower based on a multitude of factors, including job-related skills, experience, and relevant education or training.

National Pay Range$125,000—$150,000 USD

Benefits of Working at ISC

• Employee Ownership Program - every eligible employee shares in the financial rewards that grow when the company grows
• Professional development opportunities
• Owner Referral Program
• Work from home reimbursement for remote/hybrid roles
• Canary emergency financial assistance program
• Comprehensive medical, dental, vision
• Life/AD&D Insurance
• Confidential, Employee Assistance Program
• Health Savings Account, includes company contribution
• Short-term disability
• Voluntary benefits - supplemental accident, critical illness, hospital insurance
• Employee discounts
• 401(k) Plan with company match contribution
• Various Time Off Programs
• 11 company paid holidays

Applicants may contact the ISC HR department via e-mail or phone to request and arrange for an accommodation that will allow the applicant to successfully complete the application process. Applicants needing assistance may request accommodation at any time. Please contact ISC at [email protected] or 760-599-7242.

ISC believes in creating long-term relationships by being responsive and relevant and by consistently delivering value to our community of customers. Specifically, we focus on attracting, developing, and retaining the best talent for our business, challenging our people, demonstrating a “can-do” attitude, and fostering a collaborative and mutually supportive environment.

Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, gender, gender identity, sexual orientation, marital status, medical condition, genetic information, mental or physical disability, military or veteran status, or any other characteristic protected by local, state, or Federal law.

**Must be legally authorized to work in the United States.**

**ISC participates in the Federal E-Verify program**