Who's Clearcover?

Clearcover is the smarter car insurance company. We use powerful technology to offer everyday drivers better coverage for less money. We’re proud to be one of the fastest growing startups in Chicago, and we’re currently looking to add a few more extraordinary people to our team.

Reporting to the Team Lead, the Data Engineer acts as a high value steward for our modern unified data platform.  This person is responsible for transforming and ingesting data into our data warehouse and providing frameworks and services for operating on that data while also maintaining high standards for quality, security, and reliability.  Our data comes from a multitude of sources, including our eventing pipeline, write-ahead logs, APIs and legacy flat files.  Our stakeholders rely on us daily to make data access and reliability a strength of our business.

What will you do?

• Building pipelines for a wide variety of data sources/destinations and maintaining their mapped schemas.
• Building and maintaining the core raw datasets for Machine Learning and Analytics.
• Ensuring privacy, compliance, and security protocols for our data.
• Integrating our core raw datasets into the rest of the technical organization and products.
• Delivering tooling and processes for operating on data, securing data storage, and ensuring data reliability.
• Providing technical mentorship to fellow Engineers and Analysts.

What do you need?

• Passionate about data security, discovery, and reliability.
• Team oriented, possessing strong collaboration skills.
• Dedication to continuous learning as a core component of the position.
• Experience implementing, testing, debugging and deploying data pipelines using 2+ of the following tools: Prefect, Airflow, Glue, Kafka, Serverless(Lambda, Kinesis, SQS, SNS), Fivetran, Stitch Data/Singer.
• Experience with 1+ Cloud Data Warehousing technologies: Redshift, BigQuery, Spark, Snowflake, Presto, Athena, S3.
• Experience with SQL DB administration (PostgreSQL, MS SQL, etc.).
• Proficient with Python for backend and/or data pipeline development . Bonus points for contributions to open source projects.
• Proficient with cloud operations management/configuration using tools like Terraform and/or Cloudformation.
• Proficient with SQL for analytical querying and data processing.
• Familiarity with BI tools: Periscope, Tableau, Looker.
• Familiarity with containerization: Docker, ECS, Kubernetes.
• Familiarity with distributed processing: Dask and/or Spark.

What's in it for you?

• Unlimited vacation, we hire adults 
• Equity for all employees, so you own a piece of the pie too 
• Dental and Vision, we've got you covered 100%
• Medical, we cover the vast majority of your premiums to make the cost of you and your family's coverage affordable. Plus, we contribute to your HSA and HRA (cha-ching)
• We invest in your future by contributing 3% of your salary to a 401(K), even if you don't
• Come to work pre-taxed through our FSA commuter benefits 
• and yes, we have unlimited LaCroix, beer, snacks and the occasional ice cream social

Clearcover is an Equal Opportunity Employer (EOE) that welcomes and encourages all applicants to apply regardless of age, race, color, religion, sex, sexual orientation, gender identify and/or expression, national origin, disability, veteran status, marital or parental status, ancestry, citizenship status, pregnancy or other reasons prohibited by law.