Data Engineer @ Integrated Specialty Coverages, LLC

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 Data Engineer role will be the technical liaison between multiple groups including a data science team, the engineering team, product management, and business stakeholders. You do not need any insurance knowledge prior, however, you must quickly dive deep into the insurance world and ask questions to become a subject matter expert. You will be responsible for building a data platform to facilitate the data science team. You must be a self-starter that can build out features such as a data pipeline from scratch. There will be support from both engineering and data science for any buildout.

Position Responsibilities:

Create and maintain optimal data pipeline architecture.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using AWS technologies, SQL, and Python.
Work with stakeholders including the Executive, Product, Data Science, and Engineering teams to assist with data-related technical issues and support their data infrastructure needs.
Work with data science and analytics teams to strive for greater functionality in our data systems.

Minimum Qualifications:

Advanced working SQL knowledge and experience working with relational databases, strong query authoring (SQL) as well as working familiarity with a variety of databases (Snowflake, Redshift, MySQL, MSSQL, etc.)
Experience with writing software in a production environment with Python (3-5 years)
Experience building and optimizing data pipelines, architecture and data sets.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
A successful history of transforming, processing and extracting value from large disconnected, datasets from a variety of data sources (Flat files, Excel, databases, etc.)
Strong analytic skills related to working with unstructured datasets.
Strong project management and organizational skills.
Experience supporting and working with cross-functional teams in a dynamic environment.
Ability to mentor/guide/collaborate with other team members.
Experience developing software in an agile environment from the requirements stage to production.
Experience with version control: git
Experience with container technologies: Docker
Experience with AWS cloud services: EC2, ECS, Batch, S3, EMR, RDS, Redshift
Experience with data modeling and data warehouse design

Preferred Qualifications:

Experience with data pipeline and workflow management tools: Airflow, Jenkins, AWS Glue, Azkaban, Luigi, etc.
Experience with Snowflake as a data warehouse

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

$130,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
Burnalong digital health and wellness platform
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 without employer sponsorship.**

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

Data Engineer

Integrated Specialty Coverages, LLC

Compensation Overview

6 month growth

1 year growth

2 year growth

Simplify's Take

What believers are saying

What critics are saying

What makes Integrated Specialty Coverages, LLC unique