Analytics Engineer

Rachio

Denver, CO, US
  • Job Type: Full-Time
  • Function: Data Science
  • Post Date: 01/08/2021
  • Website: rachio.com
  • Company Address: 1321 15th Street, Denver, CO, 80202

About Rachio

Rachio is a Denver-based software and hardware company focused on improving the water efficiency of homes. Rachio makes the best-selling smart sprinkler controller. The Rachio Smart Controller enables you to control your outdoor sprinkler system from the palm of your hand, using a WiFi-enabled iOS or Android device. Rachio’s cloud-based software allows customers to manage their sprinkler system from anywhere. Installation takes less than 30 minutes and you begin saving water and improving your yard's health immediately. The Rachio Smart Controller makes landscapes beautifully efficient.

Job Description

About this Opportunity

Rachio is in the process of developing best-in-class strategic analytics capabilities to drive our next wave of growth. As such, we are seeking an Analytics Engineer to support our growing capabilities, help drive insights, and empower our organization with self-serve analytics.  

As a part of the Strategic Analytics team, you will work closely with internal stakeholders in both the Consumer and Engineering teams to understand strategic data needs, collect requirements, design, and build BI and reporting solutions for Rachio. You will support the growth and improvement of our data warehouse by designing, developing, and supporting new and existing data marts, procure new data sources, packages, and reports. In addition, you will help with ingesting and transforming existing data from our data lake into a usable business format to solve key questions and better understand our customers.  

Rachio’s mission is to make sustainable water use effortless and personally rewarding for our customers. Through our integrated approach to efficient watering and sustainability - combining our industry-leading smart sprinkler controller with natural soil treatments - we aim to revolutionize yard care.

Job Duties and Responsibilities

  • Enable the Strategic Analytics team by creating advanced SQL queries, maintaining database structures, and collaborating to find new business insights
  • Take full ownership of the analytics data warehouse by implementing analytical database design principles and establishing business process best practices 
  • Maintain and monitor our data pipeline services and BI-platform
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Maintain the organization’s business KPIs and business intelligence data layer for uniform metrics and self-serve analytics

Required Skills

  • 5-7 years working with database designs as a part of data analytics teams
  • Deep working knowledge of analytical database design and data modeling
  • Experience with star/snowflake schemas, dimensional modeling, OLAP data structures, and best practices for curating data for BI and visualization
  • Excellent SQL skills for advanced queries and database development
  • Past experience with data governance principles, KPI management, and supporting data operations for business intelligence
  • Excellent communication skills with the ability to communicate complex concepts with business stakeholders and engineers
  • Experience with Python, Javascript, or other scripting language a plus
  • Some project management experience a plus

Compensation

  • Salary based on experience
  • Stock options

Benefits and Perks

  • Rachio covers 100% of employee premiums and 60% of dependent premiums for the following insurance plans
    • United Health Care PPO 1000 plan
    • Aetna Dental 100 Group
    • Aetna EyeMed Group Insurance.
    • We have a variety of other plans to choose from. However, if you select a plan with a higher premium you would be responsible for covering the difference in cost.
  • Due to COVID-19, Rachio is currently fully remote. We are exploring our options for in-person engagement for 2021 and are open to this being a full-time remote position.
  • 401(k) plan (not matching)
  • Unlimited vacation
  • Relaxed dress code

Related Jobs

Senior Web Engineer

Rachio - Denver, CO, US

Server Lead

Rachio - Denver, CO, US

Senior Software Engineer, Backend

Rachio - Denver, CO, US
Disclaimer: Local Candidates Only
This company does NOT accept candidates from outside recruiting firms. Agency contacts are not welcome.