Analytics Engineer (Mid/Senior)

Our Value Proposition: Clearcover is a venture-backed technology start-up disrupting the trillion-dollar legacy insurance market. We’ve focused on building products that create confident, happy customers - and we’re flourishing. We believe in putting our people first, paying them well, and working together to solve tough problems. If you’d like a high-growth opportunity with an award-winning company, let’s chat.

In this role:

The Analytics Engineer works closely with data engineers, data analysts and data stakeholders to deliver tested and documented datasets to various data domains at Clearcover. These datasets enable our stakeholders to make effective decisions and answer questions in a self-serving manner. The ability to speak the language of a business user while applying technical prowess is key to this role.

What will you do?

Own and maintain all analytic data models sourced from various production systems in our data warehouse
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
Design, build, and maintain data pipelines to ensure reliable business reporting
Advocate for improvements to data quality and performance
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 data stakeholders to develop approaches in finding, collecting, and using data

What do you need?

Strong written and verbal communication skills including the ability to collaborate across teams
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, writing complex queries and/or stored procedures in current role
Have used Python, Ruby, or R when SQL failed you or was needed for a complex report or analysis
Experience with Snowflake, BigQuery or other Cloud Data Platforms serving as a production Data Warehouse
Experience with Looker or other data visualization tools (Tableau, Superset, PowerBI)

What’s nice to have?

Experience with dbt (Data Build Tool)
Experience with version control tools (Github, Bitbucket)
Experience working with semi-structured data types such as JSON and XML
Experience in Property and Casualty insurance industry

‌