200+ applicants

This job has closed.

Company

Original Job Post

ISC (Integrated Specialty Coverages, LLC) · 1 week ago

Data Engineer

United States

Full-time

Remote

Mid Level

$130K/yr - $150K/yr

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Artificial Intelligence (AI)Information Technology

Insider Connection @ISC (Integrated Specialty Coverages, LLC)

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLRelational databasesSnowflakeRedshiftMySQLMSSQLPythonData pipelinesData architectureRoot cause analysisData transformationMetadata managementWorkload managementData extractionData processingData sets optimizationUnstructured datasetsAgile developmentVersion controlGitContainer technologiesDockerAWS cloud servicesEC2ECSBatchS3EMRRDSData modeling

Required

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.

Experience with

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

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

Experience with Snowflake as a data warehouse

Benefits

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

Company

ISC (Integrated Specialty Coverages, LLC)

Integrated Specialty Coverages (ISC) is a World-Class Program Administrator dedicated to underwriting excellence, client service, and customer experience.

Founded in 2016

Harrison, New York, USA

201-500 employees