Analytics Engineer at Rachio

| Greater Denver Area | Remote
Sorry, this job was removed at 12:47 p.m. (MST) on Wednesday, October 14, 2020
Find out who's hiring in Colorado.
See all Developer + Engineer jobs in Colorado
Please apply via our careers page https://rachio.com/careers/
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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 development and improvement of our data warehouse by designing and developing new data tables and procuring new data sources. 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 designing database views, bringing data sources into data warehouses, and transforming data to be analysis-ready
  • 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 Tableau and Looker/LookML a plus
  • 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

  • Medical, dental, and vision insurance -- premiums are 100% paid for employees and 60% paid for dependents
  • 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

How to Apply

  • Please apply via our careers page
  • You must be legally authorized to work in the United States on a full-time basis

About Rachio

Rachio is a mission-based startup striving to make sustainable water use effortless and rewarding. A category leader within the smart home industry, our revolutionary smart sprinkler controllers, wireless flow meter and best-in-class app technology make it easy for homeowners to balance personal goals with efficient, transparent water use. With a passion for innovation, we are continuously innovating to develop products that homeowners love and solve meaningful problems with technology. Together, the Rachio community has saved *billions* of gallons of water - and counting. 

We strive to create an inclusive environment where everyone can thrive, feel a sense of belonging, and do great work together. As an equal opportunity employer, we prohibit any unlawful discrimination against a job applicant on the basis of their race, color, religion, veteran status, sex, parental status, gender identity or expression, transgender status, sexual orientation, national origin, age, disability or genetic information. We respect the laws enforced by the EEOC and are dedicated to going above and beyond in fostering diversity across our company.

Read Full Job Description
Please apply via our careers page https://rachio.com/careers/
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • OracleDatabases
    • PostgreSQLDatabases
    • WordpressCMS
    • ShopifyCMS
    • RechargeCMS
    • Retention ScienceEmail
    • IterableEmail

Location

We are located near Larimer Square, with easy access to the Cherry Creek Trail, Union Station, and many restaurants!

An Insider's view of Rachio

How does your team reward individual success?

Everyone at Rachio is incredibly supportive of each other and celebrating successes is commonplace. We regularly cheer each other on in our weekly team meetings and company-wide All-Hands meeting. Furthermore, we highlight individuals who embody our values on a quarterly basis (with prizes!)

Eve

Staff Accountant

How do you collaborate with other teams in the company?

I have the pleasure of getting to work with every department at Rachio. From Finance to Engineering, we get to collaborate, plan, and execute on projects across the board to drive revenue and growth for our channels. Rachio's best asset is the wonderful people that work here.

Lou

Account Operations Partner

What makes someone successful on your team?

There are two strengths I feel drive success for our team - communication, and a willingness to dig into projects. We have a small team making a lot of big decisions, so clear, concise communication is incredibly important to growing the business. Along that same line, we are small enough that everyone is integral to moving projects forward.

Dani

Director of Marketing Acquisition

What are Rachio Perks + Benefits

Rachio Benefits Overview

Rachio covers 100% of employee premiums and 60% of dependent premiums for medical, dental, and vision insurance.

Due to COVID-19, Rachio is currently fully remote. We are exploring our options for in-person engagement for 2021 and are open to full-time remote positions with some travel.

401(k) plan (not matching)

Unlimited vacation

Relaxed dress code

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Unconscious bias training
All Rachians involved in our Talent Acquisition process are required to complete unconscious bias training & gender pronoun training. These trainings are available for everyone to participate in
Health Insurance & Wellness Benefits
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Rachio employees are required to take at least 10 PTO days each year, and encouraged to take as much time off as they need to maintain a healthy work-life balance
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Rachio provides an eco-pass
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
We offer employees a $100 monthly parking reimbursement
Pet Friendly
Acme Co.'s pet policy is dog friendly daily.
Professional Development Benefits
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
We offer $1200 annualy for continuing education.
More Jobs at Rachio6 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Data + Analytics
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Denver
Marketing
new
Denver
Design + UX
new
Denver
Please apply via our careers page https://rachio.com/careers/
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Rachio's full profileSee more Rachio jobs