Data Engineer III

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 Senior 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.  This is a senior level position.

Position Responsibilities 

• 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 flexibility, etc.
• Build and maintain the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using AWS technologies, SQL, Python, Docker, and Airflow.
• 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 extend data systems with greater functionality using existing infrastructure and tooling.
• Take ownership of technical project implementations from the requirements gathering stage through initial release and maintenance using a Kanban approach for tracking key milestones. 

Minimum Qualifications 

• 5+ years of data engineering experience from the requirements stage to production and maintenance
• Bachelor’s Degree in Computer Science or related degree or equivalent experience
• Strong experience building, optimizing and debugging data models, pipelines and data warehousing using SQL, DBT and Snowflake
• 5+ years of experience writing software in a cloud native production environment using Python  
• Experience building and maintaining cloud infrastructure, preferably with AWS cloud services: EC2, ECS, Batch, S3
• Experience with version control: git
• Experience with container technologies: Docker
• A successful history of transforming, processing and extracting value from large disconnected, datasets from a variety of data sources (Flat files, Excel, databases, APIs, etc.)
• Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Experience taking hands on technical ownership of small to enterprise impactful projects and leading communications with stakeholders
• Experience working in a complex, fast-moving environment, working dynamically and collaboratively in a small team
• Strong ability to mentor, collaborate and communicate with other team members and cross functional stakeholders  

Preferred Qualifications: 

• Insurance industry systems and technology experience
• Experience with data pipeline and workflow management tools: Airflow, Jenkins, AWS Glue, Azkaban, Luigi, etc.
• Experience working with relational databases, strong query authoring (SQL) as well as working familiarity with a variety of databases (Redshift, MySQL, MSSQL, etc.)
• Strong analytic skills related to working with unstructured datasets. 

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 HR@ISCMGA.com 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**