Analytics Engineer at Clearcover

| Chicago
Sorry, this job was removed at 11:18 a.m. (CST) on Friday, September 4, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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. 

What is an Analytics Engineer at Clearcover? 
Reporting to the Director of Business Intelligence, the Analytics Engineer will work within the larger Product team collaborating with all business units to deploy analytic solutions as well as supporting self-service analytics across Clearcover.

What will you do? 

  • Provide leadership to a fast-paced and talented team that is focused on delivering analytical solutions
  • Design and optimize our cloud based data warehouse architecture
  • Write production-quality ELT/ETL data transformation code with an eye towards performance, maintainability and scalability
  • Coach product analysts and business users on utilizing BI data tools
  • Collaborate with data engineers on infrastructure projects for sourcing data
  • Responsible for delivering new, re-usable business intelligence solutions and demonstrating value proposition to business stakeholders
  • Work with the product team to develop novel approaches to finding, collecting and using data

What do you need? 

  • Significant experience developing and delivering data solutions as a member of a business intelligence or analytics team 
  • Have a passion for solving problems using data and analytics
  • Must have a solid understanding of data warehouse architecture and best practices
  • Deep understanding of SQL query writing and use it on a daily basis in your current role 
  • Experience with DBT (Data Built Tool) or ETL/ELT tools in a production environment
  • Experience with Snowflake or Redshift serving as the Data Warehouse production platform
  • Experience with Tableau or other data visualization tools (Looker, Periscope)
  • Experience working with semi-structured data types such as JSON and XML.
  • Have used Python, Ruby, or R when SQL failed you or was needed for a complex report or analysis
  • Strong written and verbal communication skills including the ability to collaborate across teams

What's in it for you?

  • Unlimited vacation and flexible work schedule, 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 90% of your premium, 75% of your dependents and 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 
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • KotlinLanguages
    • PythonLanguages
    • RubyLanguages
    • ScalaLanguages
    • ReactLibraries
    • Ruby on RailsFrameworks
    • PostgreSQLDatabases
    • SnowflakeDatabases

Location

33 W Monroe, Chicago, IL 60603

An Insider's view of Clearcover

How does your team reward individual success?

We celebrate "wins" on Fridays with the entire company where we celebrate the success of the week with the rest of the organization, it is a fun and casual way to be recognized by peers. However, I also find a moment to individually recognize my team during our weekly touch bases for something specific that they accomplished.

Rosyln

Head of Agency Distribution

How do you empower your team to be more creative?

I manage a hybrid team of traditional "creatives" and business strategists. I work hard to foster a spirit of creativity by asking my teammates to consider a variety of ways to solve every problem we encounter. Then, I create opportunities for them to be creative in ways that align with their superpowers.

Ariana

VP of Brand & Creative

What makes someone successful on your team?

People who are successful on the Customer Experience team communicate with empathy, love solving problems for our customers, continually look for ways to work smarter, and thrive in the face of challenge.

Heidi

Head of Customer Experience

What are Clearcover Perks + Benefits

Clearcover Benefits Overview

Clearcover offers a comprehensive benefits package along with a number of perks in an effort to support our employees and their families. We work to align our perks with our core values and empower our employees to balance work and their personal lives.

Culture
Volunteer in local community
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Clearcover covers 100% of the employee's dental benefits.
Vision Benefits
Clearcover covers 100% of the employee's vision benefits.
Health Insurance Benefits
Clearcover's health insurance plan is with United Healthcare with a range of plans including PPO, HDHP and HSA. If you elect an HSA, we cover your out-of-pocket deductible as an HSA contribution.
Life Insurance
Clearcover offers voluntary life insurance.
Pet Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Clearcover provides employees with a 401(k) contribution of 3% of an employee's annual gross pay.
Company Equity
Child Care & Parental Leave Benefits
Child Care Benefits
Dependent Care FSA allows you to put away pre-tax dollars towards daycare expenses for dependents under the age of 13.
Generous Parental Leave
Clearcover offers parental leave for new parents after birth or adoption of a child. Full-time employees that have been employed for six months are eligible for six weeks of paid Parental Leave.
Flexible Work Schedule
Clearcover has flexible start and end times based upon your position and your team.
Remote Work Program
Our remote work program includes work from home Full-time remote for specific positions, as well as work flexible remote work for most position.
Family Medical Leave
Employees who have been with the company for 12 months are eligible for 12 weeks of family medical leave. Other policies apply to those here less than 12 months.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Employees receive 5 paid sick days each year.
Perks & Discounts
Casual Dress
Commuter Benefits
Clearcover's offers Commuter Benefits, employees can save an average of 30 percent off their commute by contributing pre-tax dollars.
Company Outings
Clearcover celebrates company wins by organizing quarterly outings to a variety of places like the Escape Room, Punchbowl Social and Bounce.
Game Room
Clearcover's game room includes a state-of-the-art ping pong table, custom Nerf gun wall and a Pop-a-Shot to let employees enjoy breaks between work.
Stocked Kitchen
We send snack boxes monthly since we are virtual.
Home Office Stipend for Remote Employees
We offer a one-time $250 stipend to set up your work from home office. Use this for anything that will support your work from home arrangement.
Professional Development Benefits
Job Training & Conferences
Clearcover offers a stipend to each employee to invest as they choose in their own professional development.
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available
More Jobs at Clearcover18 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Internships
Legal
Marketing
Product
Sales
Finance
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Internships
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Product
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Clearcover's full profileSee more Clearcover jobs