Posted on 
Jun 6, 2024

Principal Data Analytics Engineer

Cambridge
Mid-Senior ICs
Data Science + Analytics, Engineering
CarGurus
CarGurus
CarGurus
Public
1001-5000
Consumer Products & Tech

Headquartered in Cambridge, Massachusetts, CarGurus is the all-in-one platform that’s moving the entire car shopping journey online and guiding customers through each step. This includes everything from selling an old car to financing, purchasing, and delivering a new one. Today, tens of millions of consumers visit CarGurus.com each month, and more than 30,000 dealerships use our products. We have a people-first culture that fosters kindness, collaboration, and innovation, while empowering our Gurus with tools and resources to fuel their career growth. Our goal is to give all people—consumers, dealers, and our employees—the power to reach their destination. 

Job Description

Role overview

We are looking for a Principal Data Analytics Engineer with experience in data modeling to join the Data Engineering team at CarGurus as we scale out our data modeling framework in dbt. As a Principal Data Analytics Engineer at CarGurus, you will be responsible for transforming raw data in the data warehouse into clean, reliable, organized data models that allow our organization to make informed data-driven decisions. Our tech stack currently consists of Snowflake, dbt, and Looker, along with an in-house built ETL pipeline using Airflow.  

What you'll do

  • Design, build, and maintain scalable, modularized data models using dbt for our core data marts
  • Partner with analysts and non-technical stakeholders across the company to gather business requirements for modeling projects
  • Create explores in Looker to surface data models for self-service
  • Drive best practices and standards for data modeling, documentation, and testing
  • Mentor junior team members on their modeling projects and assist with code reviews
  • Lead Architecture design and implement best practices within Snowflake
  • Engage key decision makers across business functions to support complex initiatives
  • Contribute to platform ownership tasks such as permissioning, metadata management, and maintenance for the data warehouse and Looker platform

What you'll bring

  • 7+ years of experience as an Analytics Engineer, Data Engineer or similar role
  • 3+ years of experience with building complex data models in dbt or similar
  • Expert-level proficiency with SQL, including writing performant queries on large data sets
  • Experience working with cloud data warehouses (Snowflake, BigQuery, and/or Redshift)
  • Experience with Looker or a similar BI platform (Tableau, PowerBI, Sigma)
  • Experience with Data Observability Tools
  • Strong communication skills and ability to work effectively with both technical and non-technical stakeholders
  • Interest in coaching and mentoring junior engineers on the Analytics Engineering team
  • Bonus: Proficient with Python

Who we are

At CarGurus (NASDAQ: CARG), our mission is to give people the power to reach their destination. We started as a small team of developers determined to bring trust and transparency to car shopping. Since then, our history of innovation and go-to-market acceleration has driven industry-leading growth. In fact, we’re the largest and fastest-growing automotive marketplace, and we’ve been profitable for over 15 years.

What we do

The market is evolving, and we are too, moving the entire automotive journey online and guiding our customers through every step. That includes everything from the sale of an old car to the financing, purchase, and delivery of a new one. Today, tens of millions of consumers visit CarGurus.com each month, and ~30,000 dealerships use our products. But they're not the only ones who love CarGurus—our employees do, too. We have a people-first culture that fosters kindness, collaboration, and innovation, and empowers our Gurus with tools to fuel their career growth. Disrupting a trillion-dollar industry requires fresh and diverse perspectives. Come join us for the ride!

Role overview

We are looking for a Principal Data Analytics Engineer with experience in data modeling to join the Data Engineering team at CarGurus as we scale out our data modeling framework in dbt. As a Principal Data Analytics Engineer at CarGurus, you will be responsible for transforming raw data in the data warehouse into clean, reliable, organized data models that allow our organization to make informed data-driven decisions. Our tech stack currently consists of Snowflake, dbt, and Looker, along with an in-house built ETL pipeline using Airflow.  

What you'll do

  • Design, build, and maintain scalable, modularized data models using dbt for our core data marts  
  • Partner with analysts and non-technical stakeholders across the company to gather business requirements for modeling projects  
  • Create explores in Looker to surface data models for self-service  
  • Drive best practices and standards for data modeling, documentation, and testing  
  • Mentor junior team members on their modeling projects and assist with code reviews 
  • Lead Architecture design and implement best practices within Snowflake
  • Engage key decision makers across business functions to support complex initiatives
  • Contribute to platform ownership tasks such as permissioning, metadata management, and maintenance for the data warehouse and Looker platform  

What you'll bring

  • 7+ years of experience as an Analytics Engineer, Data Engineer or similar role  
  • 3+ years of experience with building complex data models in dbt or similar
  • Expert-level proficiency with SQL, including writing performant queries on large data sets  
  • Experience working with cloud data warehouses (Snowflake, BigQuery, and/or Redshift)  
  • Experience with Looker or a similar BI platform (Tableau, PowerBI, Sigma)  
  • Experience with Data Observability Tools
  • Strong communication skills and ability to work effectively with both technical and non-technical stakeholders  
  • Interest in coaching and mentoring junior engineers on the Analytics Engineering team  
  • Bonus: Proficient with Python  

Working at CarGurus

We reward our Gurus’ curiosity and passion with best-in-class benefits and compensation, including equity for all employees, both when they start and as they continue to grow with us. Our career development and corporate giving programs, as well as our employee resource groups (ERGs) and communities, help people build connections while making an impact in personally meaningful ways. A flexible hybrid model and robust time off policies encourage work-life balance and individual well-being. Thoughtful perks like daily free lunch, a new car discount, meditation and fitness apps, commuting cost coverage, and more help our people create space for what matters most in their personal and professional lives.

We welcome all

CarGurus strives to be a place to which people can bring the ultimate expression of themselves and their potential—starting with our hiring process. We do not discriminate based on race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. We foster an inclusive environment that values people for their skills, experiences, and unique perspectives. That’s why we hope you’ll apply even if you don’t check every box listed in the job description. We also encourage you to tell your recruiter if you require accommodations to participate in our hiring process due to a disability so we can provide the appropriate support. We want to know what only you can bring to CarGurus. #LI-Hybrid

Receive Tech Ladies'
newest jobs in your inbox,
every week.

Join Tech Ladies for full-access to the job board, member-only events, and more!

If you're already a member, we haven't forgotten you. We promise. It's a new system. If you fill out the form once, it'll remember you going forward. Apologies for the inconvenience.

Cambridge
Cambridge
Java
Java
JavaScript
JavaScript
JQuery
JQuery
Node.Js
Node.Js
Python
Python
R
R
React
React
Redux
Redux
Ruby
Ruby
Spring
Spring
SQL
SQL
AWS
AWS
Kubernetes
Kubernetes
Docker
Docker
Jenkins
Jenkins
Elasticsearch
Elasticsearch
Kafka
Kafka
Data Science + Analytics
Data Science + Analytics
Engineering
Engineering
In-Person
In-Person