Data Engineer III

Summary

Join Integrated Specialty Coverages (ISC), a leading Insurtech company, as a Senior Data Engineer. You will serve as the technical liaison between various teams, building and maintaining a data platform using AWS technologies, SQL, Python, and other tools. This senior-level role requires 5+ years of data engineering experience and a strong background in building data pipelines and warehousing. You will work with stakeholders to address data-related issues and support their infrastructure needs. The position offers a competitive salary, comprehensive benefits, and professional development opportunities. Prior insurance knowledge is not required, but a willingness to learn is essential. ISC is committed to fostering a collaborative and supportive work environment.

Requirements

• 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

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

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

• Medical, dental and vision insurance
• 401(k) plan with match
• Paid time off
• 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