We’re hiring a Data Warehouse Engineer in Columbus, OH

The engineering team at Root strives to be one of the most transformative engineering teams ever. We’re changing the way that car insurance works. We’re competing with companies that have been around for a century and comprise a $200B industry—and we’re doing it with an astonishingly small team.

Our data warehouse tech stack includes:
--Redshift, PostgreSQL, Aurora
--ETL pipeline built with Ruby, Rails and Resque
--AWS Cloudformation, AWS Lambda, AWS ECS for automation and deployment
--Buildkite for CI

We recently raised one of the largest VC rounds ever for an Ohio technology company:

At Root, we are not only building high-quality consumer-facing software products, but also a top-tier auto insurance company. We are creating a highly capable and adaptable engineering team to expose business critical data to our team of product analysts, actuaries, data scientists, and accountants.

For more information on engineering at Root see https://eng.joinroot.com/

We divide the areas of responsibility for engineers into three major areas:

Technical: The skills and knowledge that make up an engineer’s basic problem-solving toolbox.
Planning and Execution: The ability to plan and execute assigned work beyond basic technical solutions.
Working with Others: The ability to work effectively with other engineers and people in other functions.

Scope of Impact Team/Initiative/Company

What we look for in senior data warehouse engineers:

Technical Skills

  • Familiarity with dimensional modeling and star schema design
  • Strong knowledge of SQL database management and performance
  • Knowledgeable of ETL best practices and tradeoffs
  • Incorporates testing and thinks about reliability as a natural part of delivering working software
  • Experienced with several programming paradigms
  • Solid knowledge version control tools

Planning and Execution

  • Approaches problems with a domain first mentality
  • Plans and completes large and complex tasks/projects without supervision
  • Foresees issues and requirements for large projects and features
  • Completes large pre-planned tasks in an efficient manner
  • Thinks critically about work to guarantee business functionality. Understands and takes into account business goals into their technical decisions.
  • Can break down large initiatives into incrementally implementable deliverables

Working with Others

  • Provides effective and accurate technical feedback in code reviews
  • Able to work across teams to tackle complex issues
  • Able to positively influence other engineers, both directly and indirectly
  • Works with product owners, analysts and other functions to move company’s priorities forward

Get in touch

Finding the right people to help us build Root is a top priority. Whether you would like to explore the possibility of working together or simply learn more about the position, we’d love to hear from you!

Apply now

Current job openings

Data Science

If you’d like to be a part of what we are building but don’t see an opening that suits you, email us at [email protected].